[jira] [Created] (HIVE-24230) Integrate HPL/SQL into HiveServer2

["Attila Magyar (Jira)" <ji...@apache.org>]

Attila Magyar created HIVE-24230:
------------------------------------

             Summary: Integrate HPL/SQL into HiveServer2
                 Key: HIVE-24230
                 URL: https://issues.apache.org/jira/browse/HIVE-24230
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2, hpl/sql
            Reporter: Attila Magyar
            Assignee: Attila Magyar


HPL/SQL is a standalone command line program that can store and load scripts from text files, or from Hive Metastore (since HIVE-24217). Currently HPL/SQL depends on Hive and not the other way around.

Changing the dependency order between HPL/SQL and HiveServer would open up some possibilities which are currently not feasable to implement. For example one might want to use a third party SQL tool to run selects on stored procedure (or rather function in this case) outputs.
{code:java}
SELECT * from myStoredProcedure(1, 2); {code}
HPL/SQL doesn’t have a JDBC interface and it’s not a daemon so this would not work with the current architecture.

Another important factor is performance. Declarative SQL commands are sent to Hive via JDBC by HPL/SQL. The integration would make it possible to drop JDBC and use HiveSever’s internal API for compilation and execution.

The third factor is that existing tools like Beeline or Hue cannot be used with HPL/SQL since it has its own, separated CLI.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)