Oracle PL/SQL to Hive/Spark SQL conversion

[GAURAV SONI]

Hi Team 

I have more then 10000 Oracle PL/SQL code. 

Which I want to migrate to Hive or Spark-SQL can you please suggest me how can I do it. 

Regards

Gaurav Soni

[Lukas Eder]

Hi Guarav,

Thank you for your message. Our parser can currently only parse simple procedural logic, see:

- https://www.jooq.org/doc/latest/manual/sql-building/procedural-statements/

- https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-grammar/

It is unlikely that you'll be able to parse complete PL/SQL packages with it. Also, we don't support Hive / Spark SQL yet.

So, I doubt that jOOQ will be helpful for your specific migration.

Best Regards,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/2bb30dc0-3831-4bcd-b1c4-78396f9fa5c4n%40googlegroups.com.