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.

How to migrate Oracle Packages,Stored procedures into Cloudera

Highlighted

How to migrate Oracle Packages,Stored procedures into Cloudera

New Contributor

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

1 REPLY 1

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

Explorer

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

Don't have an account?
Coming from Hortonworks? Activate your account here