plsql - Convert PL/SQL to Hive QL

Question

I want a tool through which I can get the respective hive query by giving the PL/SQL query. There are lots of tools available which convert sql to hql. ie: taod for cloude database. But it does not show me the respective hive query.

Is there any such kind of tool whose convert given sql to hql. Please help me.

Thanks and Regards, Ratan

Answer 1

Please take a look at open-source project PL/HQL at http://www.hplsql.org/ which is now a part of Hive 2.x or higher version. It allows you to run existing SQL Server, Oracle, Teradata, MySQL etc. stored procedures in Hive.