Multiple queries/statements in single paratgraph - hive interpreter

[Anandha L Ranganathan <an...@gmail.com>]

Hi,
I am using Hive interpreter and upgraded to 0.8 version. We used to run
multiple queries in single paragraph and after upgrade it seems it is
broken. Is it something I am missing  ?

I tried with and without semicolon after each statement and still having
the same problem.


%hive
use default;

show tables;

org.apache.hive.service.cli.HiveSQLException: Error while compiling
statement: FAILED: ParseException line 1:11 missing EOF at ';' near
'default' at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231) at
org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217) at
org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254) at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:719)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:800)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:101)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:602)
at org.apache.zeppelin.scheduler.Job.run(Job.java:182) at
org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:139)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266) at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745) Caused by:
org.apache.hive.service.cli.HiveSQLException: Error while compiling
statement: FAILED: ParseException line 1:11 missing EOF at ';' near
'default' at
org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:323)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:148)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:226)
at org.apache.hive.service.cli.operation.Operation.run(Operation.java:264)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:470)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:457)
at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497) at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
at
org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
at
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
at java.security.AccessController.doPrivileged(Native Method) at
javax.security.auth.Subject.doAs(Subject.java:422) at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
at com.sun.proxy.$Proxy25.executeStatementAsync(Unknown Source) at
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:313)
at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:509)
at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1317)
at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1302)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
... 3 more Caused by: java.lang.RuntimeException:
org.apache.hadoop.hive.ql.parse.ParseException:line 1:11 missing EOF at ';'
near 'default' at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:213) at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166) at
org.apache.hadoop.hive.ql.Driver.compile(Driver.java:438) at
org.apache.hadoop.hive.ql.Driver.compile(Driver.java:321) at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1221) at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1215) at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:146)

Re: Multiple queries/statements in single paratgraph - hive interpreter

[Anandha L Ranganathan <an...@gmail.com>]

Following up on this to find if it is a bug or this features is removed.

Thanks
Anand


On Thu, Dec 7, 2017 at 9:38 AM, Anandha L Ranganathan <analog.sony@gmail.com
> wrote:

> Hi,
> I am using Hive interpreter and upgraded to 0.8 version. We used to run
> multiple queries in single paragraph and after upgrade it seems it is
> broken. Is it something I am missing  ?
>
> I tried with and without semicolon after each statement and still having
> the same problem.
>
>
> %hive
> use default;
>
> show tables;
>
> org.apache.hive.service.cli.HiveSQLException: Error while compiling
> statement: FAILED: ParseException line 1:11 missing EOF at ';' near
> 'default' at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231) at
> org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217) at
> org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254) at
> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
> at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
> at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:719)
> at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:800)
> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:101)
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
> InterpretJob.jobRun(RemoteInterpreterServer.java:602) at
> org.apache.zeppelin.scheduler.Job.run(Job.java:182) at
> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:139)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) at
> java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(
> ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.
> ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745) Caused by:
> org.apache.hive.service.cli.HiveSQLException: Error while compiling
> statement: FAILED: ParseException line 1:11 missing EOF at ';' near
> 'default' at org.apache.hive.service.cli.operation.Operation.
> toSQLException(Operation.java:323) at org.apache.hive.service.cli.
> operation.SQLOperation.prepare(SQLOperation.java:148) at
> org.apache.hive.service.cli.operation.SQLOperation.
> runInternal(SQLOperation.java:226) at org.apache.hive.service.cli.
> operation.Operation.run(Operation.java:264) at
> org.apache.hive.service.cli.session.HiveSessionImpl.
> executeStatementInternal(HiveSessionImpl.java:470) at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:457)
> at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497)
> at org.apache.hive.service.cli.session.HiveSessionProxy.
> invoke(HiveSessionProxy.java:78) at org.apache.hive.service.cli.
> session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) at
> org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
> at java.security.AccessController.doPrivileged(Native Method) at
> javax.security.auth.Subject.doAs(Subject.java:422) at
> org.apache.hadoop.security.UserGroupInformation.doAs(
> UserGroupInformation.java:1866) at org.apache.hive.service.cli.
> session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) at
> com.sun.proxy.$Proxy25.executeStatementAsync(Unknown Source) at
> org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:313)
> at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:509)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$
> ExecuteStatement.getResult(TCLIService.java:1317) at
> org.apache.hive.service.cli.thrift.TCLIService$Processor$
> ExecuteStatement.getResult(TCLIService.java:1302) at org.apache.thrift.
> ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.
> TBaseProcessor.process(TBaseProcessor.java:39) at
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(
> TSetIpAddressProcessor.java:56) at org.apache.thrift.server.
> TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) ... 3
> more Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.parse.ParseException:line
> 1:11 missing EOF at ';' near 'default' at org.apache.hadoop.hive.ql.
> parse.ParseDriver.parse(ParseDriver.java:213) at
> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:438) at
> org.apache.hadoop.hive.ql.Driver.compile(Driver.java:321) at
> org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1221) at
> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1215) at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:146)
>
>
>
>