Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Stored procedure in Hadoop

Stored procedure in Hadoop

Explorer

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.

3 REPLIES 3

Re: Stored procedure in Hadoop

Champion

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 .

 

 

 

Re: Stored procedure in Hadoop

Explorer

can you share some links related to  Hive supports Views for stored procedure.

Re: Stored procedure in Hadoop

Champion

What I was referring to Hive views is  that you can eliminate some of the exciting stored procedure by replacing with Views .