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.
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.
executing a file with multiple queries in it should work. But each statement is executed individually and is non-atomic (they are not executed within a single transaction). Please post exceptions or errors if this has not worked for you.