Prasad Wagle created ZEPPELIN-594:
-------------------------------------
Summary: Error running query with HiveInterpreter
Key: ZEPPELIN-594
URL: https://issues.apache.org/jira/browse/ZEPPELIN-594
Project: Zeppelin
Issue Type: Bug
Components: Interpreters
Reporter: Prasad Wagle
Priority: Minor
I got the error below running a Vertica query with HiveInterpreter. Restarting
the server fixed the problem.
ERROR [2016-01-12 00:13:58,625] ({pool-2-thread-25}
HiveInterpreter.java[executeSql]:301) - Cannot run select *
from analytics_prod.statuses
where created_date = '2015-11-01'
limit 15
java.sql.SQLException: [Vertica][VJDBC](100161) The connection is closed.
at com.vertica.io.ProtocolStream.ensureOpen(Unknown Source)
at com.vertica.io.ProtocolStream.sendMessage(Unknown Source)
at com.vertica.core.VConnection.handleError(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source)
at com.vertica.jdbc.SStatement.execute(Unknown Source)
at
org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:255)
at
org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:335)
at
org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:300)
at org.apache.zeppelin.scheduler.Job.run(Job.java:169)
at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:157)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
Caused by: com.vertica.support.exceptions.GeneralException:
[Vertica][VJDBC](100161) The connection is closed.
... 21 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
