Reply
New Contributor
Posts: 1
Registered: ‎09-10-2018

Hive JDBC drivers support to execute multiple SQL Statements

Hi,

 

I have written a java program to execute SQL statements on hive using Cloudera hive JDBC driver. When I try to execute multiple SQL statements separated by a semicolon, driver throwing an error - Error while compiling statement: FAILED: ParseException line 1:36 cannot recognize input near ';' '<EOF>' '<EOF>' in table source. Is it possible to execute multiple SQL statements using Hive JDBC driver.

Highlighted
Cloudera Employee
Posts: 761
Registered: ‎03-23-2015

Re: Hive JDBC drivers support to execute multiple SQL Statements

This is not supported, you just need to call execute() for each query.
New Contributor
Posts: 2
Registered: ‎01-21-2019

Re: Hive JDBC drivers support to execute multiple SQL Statements

Hi EricL,

 

Is there any plan in feature to support this feature?

Cloudera Employee
Posts: 761
Registered: ‎03-23-2015

Re: Hive JDBC drivers support to execute multiple SQL Statements

Sorry, I am not aware of this.

Is there any particular use case that you need to rely on this feature?
New Contributor
Posts: 2
Registered: ‎01-21-2019

Re: Hive JDBC drivers support to execute multiple SQL Statements

We have a client interface to interact with hadoop hive through hive jdbc drivers. Through client interface, it is possible to connect to dirrerent databases like db2, teradata, hadoop and aster. In interface, customer can run multiple queries seperated by "," when it is connected to db2 or teradata but unable to run multiple queries when it is connected to hadoop hive. The customer wants this feature in our client interface.

Cloudera Employee
Posts: 761
Registered: ‎03-23-2015

Re: Hive JDBC drivers support to execute multiple SQL Statements

Let me check this internally for you. Will get back to you later on this.