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)
