Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How do I call HPLSQL via an ODBC Hive connection?

Solved Go to solution

How do I call HPLSQL via an ODBC Hive connection?

New Contributor

I'm playing around with the sandbox trying to do some PoC to see if we can call HPL SQL functions via an ODBC connection.

I used the sandbox to call the hplsqlrc program and execute a procedure.

However, once I've connected to the sandbox, I'm not having any luck in determining how to call the hplsqlrc program to run a program.

Any insights on how I'd go about doing this in the sandbox? Any good general material on HPL SQL via ODBC would be nice too.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How do I call HPLSQL via an ODBC Hive connection?

6 REPLIES 6

Re: How do I call HPLSQL via an ODBC Hive connection?

Highlighted

Re: How do I call HPLSQL via an ODBC Hive connection?

New Contributor

@Mike Cosby Did you ever get this answered? I looked at the example that @Namit Maheshwari pointed out, but it didn't seem to me to answer the question of how to call from an ODBC (or JDBC) connection. I'm looking for this as well, did you find an answer?

Re: How do I call HPLSQL via an ODBC Hive connection?

New Contributor

@Jim Dolan I did not figure this out. We were looking for a way to transition a program over from a MS SQL stored proc system to a Hadoop system in stages. We instead are looking to a parallel approach where we develop the hadoop replacement of the various procs in new tools.

Re: How do I call HPLSQL via an ODBC Hive connection?

New Contributor

@Mike Cosby Bummer. For your new hadoop development, are you using hplsql? If so are you accessing via the command line or did you find a tool that would connect such as Oracle SQL Developer or SQuirrel SQL editor?

Re: How do I call HPLSQL via an ODBC Hive connection?

New Contributor

@Jim Dolan Did you figured out calling HPLSQL form BI / External tools using JDBC/ODBC Drivers ?

Re: How do I call HPLSQL via an ODBC Hive connection?

New Contributor

Functionality asked for by this question, submission of HPL/SQL via JDBC/ODBC (which requires HiveServer2 support for this) is not implemented yet:

https://issues.apache.org/jira/browse/HIVE-17596

Until this is done, submission via the command line is the only option.

Don't have an account?
Coming from Hortonworks? Activate your account here