03-24-2018 03:23 PM
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.
03-27-2018 06:34 PM
You might look at HPL/SQL, which provides some level of PL/SQL support for Hive:
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.