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: 399
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.
Announcements