Ulrich zink created ZEPPELIN-613:
------------------------------------
Summary: Hive "calculation" semantic exception
Key: ZEPPELIN-613
URL: https://issues.apache.org/jira/browse/ZEPPELIN-613
Project: Zeppelin
Issue Type: Bug
Components: zeppelin-interpreter
Affects Versions: 0.5.5
Environment: Ubuntu 14.04, Hive 1.2.1
Reporter: Ulrich zink
I am running this example to check my build https://goo.gl/l3JO4U
Simple Hive tasks like create table, load data even selecting a particular
column and display it works fine, but when I add count or group by I get a
semantic error.
For instance the following statement works fine:
%hive
select state, spending/1000 SpendinginBillions from health_table
While this one throws an error:
%hive
select state, spending/1000 SpendinginBillions from health_table
group by state
returns:
Error while compiling statement: FAILED: SemanticException [Error 10025]: Line
1:14 Expression not in GROUP BY key '1000'
similarly the following runs fine:
%hive
select year from health_table
while this one crashes:
%hive
select count(year) from health_table
returns:
java.lang.NullPointerException at
org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184)
at
org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204)
at
org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233)
at org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328)
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:302)
at org.apache.zeppelin.scheduler.Job.run(Job.java:171) at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
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)
at java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
