Support Questions
Find answers, ask questions, and share your expertise

Is it possible to execute multiple SQL statements separated by comma using Hive JDBC drivers?

Is it possible to execute multiple SQL statements separated by comma using Hive JDBC drivers?

New Contributor

When we try to run multiple SQL statements separated with comma, HIVE JDBC drivers are giving error as

"Executed as Single statement. Failed [40000 : 42000] Error while compiling statement: FAILED: ParseException line 1:41 extraneous input ';' expecting EOF near '<EOF>' ". Is there any feature plan from hartonworks to support to run multiple SQL statetements seperated by comma.

2 REPLIES 2

Re: Is it possible to execute multiple SQL statements separated by comma using Hive JDBC drivers?

Explorer

Any news on this?  Any way through Hive JDBC/ODBC driver - support to execute multiple SQL Statements.

Re: Is it possible to execute multiple SQL statements separated by comma using Hive JDBC drivers?

Rising Star

There are 2 things forground thread and background thread.

 

Foreground thread is used for parsing/complilation.The hive.server2.async.exec.threads determine how many concurrent threads can Hiveserver2 handle,it defaults to 500.

 

Background thread comes after compliation/parsing phase,where it runs Tez jobs. This depends on number of Tez AM .