Reply
Highlighted
Explorer
Posts: 16
Registered: ‎05-12-2016

Stored procedure in Hadoop

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.

Champion
Posts: 777
Registered: ‎05-16-2016

Re: Stored procedure in Hadoop

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 .

 

 

 

Explorer
Posts: 16
Registered: ‎05-12-2016

Re: Stored procedure in Hadoop

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

Champion
Posts: 777
Registered: ‎05-16-2016

Re: Stored procedure in Hadoop

[ Edited ]

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