Send HQL query from SQL Server to Hive for processing

Hello All,

I am new to this forum, so not sure what is the proper project. Just wondering if there is a way via Jaspersoft to send just a HQL Query from SQL Server (hql queries will be stored in the table on SQL Server) to HIVE for processing, process it on HIVE (and store output in HDFS) and once its completed, just send notification on completion back to SQL Server.

Thank you,

Andrew