Is there a simple way to migrate from PL/SQL to PL/HQL? Regards, Venkat
From: Dmitry Tolpeko [mailto:dmtolp...@gmail.com] Sent: Friday, February 27, 2015 1:36 PM To: user@hive.apache.org Subject: PL/HQL - Procedural SQL-on-Hadoop Let me introduce PL/HQL, an open source tool that implements procedural SQL on Hadoop. It is going to support all major procedural syntaxes. The tool can be used with any SQL-on-Hadoop solution. Motivation: * Writing the driver code using well-known procedural SQL (not bash) that enables Hadoop to even more wider audience * Allowing dynamic SQL, iterations, flow-of-control and SQL exception handling * Facilitating migration of RDBMS workload to Hadoop Plans (besides extending syntax): * Supporting CREATE PROCEDURE/FUNCTION/PACKAGE to reuse code * Allowing connections to multiple databases (i.e. lookup tables in relational databases) * On-the-fly SQL conversion (SELECT i.e.), compatibility layers More details can be found at http://www.plhql.org/ It is just the first release PL/HQL 0.01 to show that such project exists and get any initial feedback. Thank you, Dmitry Tolpeko This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.