09-14-2016 07:39 AM
Hi, i am putting my data in hive tables and i have a lot of stored procedures to perform business logic. I know that
we can achive stored procedure execution using HPL/SQL but it is not yet in the scope of cloudera. I want to know the other way i can achieve store procedure executing in Hadoop.
Please help I am stuck here i need your suggestion.
09-20-2016 06:52 PM
I think you have two option.
1. write a UDF in java for all your stored procedure logic which is going to be a time consuming effort.
2. Hive supports Views ,althought it is not a subsitute for stored procedure you can still make use of views .