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.
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 .
What I was referring to Hive views is that you can eliminate some of the exciting stored procedure by replacing with Views .