Reply
New Contributor
Posts: 1
Registered: ‎03-24-2018

How to migrate Oracle Packages,Stored procedures into Cloudera

Hi,

I have a  qustion on how to migrate Oracle package into Cloudera(CDH).

Scenario: In Oracle system, a package was developed which is using Functions,Variables and stored procedures.

The same package, i have to develop in Cloudera platform and the package results will be inser into a new table.

How to handle Oracle PL/SQL code in Cloudera?

Can any one please provide your suggestions.

Thanks,

Krishna

Highlighted
Explorer
Posts: 11
Registered: ‎07-10-2014

Re: How to migrate Oracle Packages,Stored procedures into Cloudera

Hi,

 

You might look at HPL/SQL, which provides some level of PL/SQL support for Hive:

http://www.hplsql.org/

 

It's not included with Hive 1.1.0 (CDH 5's version of Hive), but is downloadable and usable as a separate package. Note that it's helpful for porting, but it's not optimized like Oracle PL/SQL would be when run in an Oracle DB, or like a Spark job would be when run on a cluster.

 

Regards,

Mark

Announcements