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.s...@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) > > > >