Thanks for sharing the problem. Could you provide your build command and configuration if possible?
Tutorial notebook supposed to work with default configuration. Thanks! moon On 2015년 10월 7일 (수) at 오전 11:22 Luis Pigueiras <luis.piguei...@cern.ch> wrote: > Hello, > > I am using the latest version of Zeppelin taken directly from Github and I > am having some problems with the SQL queries in the example notebook. > > The full stacktrace is: > > org.apache.zeppelin.interpreter.InterpreterException: > java.lang.reflect.InvocationTargetException > at > org.apache.zeppelin.spark.SparkSqlInterpreter.interpret(SparkSqlInterpreter.java:139) > at > org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57) > at > org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93) > ... > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.zeppelin.spark.SparkSqlInterpreter.interpret(SparkSqlInterpreter.java:136) > ... 12 more > Caused by: org.apache.spark.sql.AnalysisException: > Unsupported language features in query: select age, count(1) value > from bank > where age < 35 > group by age > order by age > TOK_QUERY 2, 0,38, 5 > TOK_FROM 2, 13,15, 5 > TOK_TABREF 2, 15,15, 5 > TOK_TABNAME 2, 15,15, 5 > bank 2, 15,15, 5 > TOK_INSERT 0, -1,38, 0 > TOK_DESTINATION 0, -1,-1, 0 > TOK_DIR 0, -1,-1, 0 > TOK_TMP_FILE 0, -1,-1, 0 > TOK_SELECT 1, 0,10, 7 > TOK_SELEXPR 1, 2,2, 7 > TOK_TABLE_OR_COL 1, 2,2, 7 > age 1, 2,2, 7 > TOK_SELEXPR 1, 5,10, 12 > TOK_FUNCTION 1, 5,8, 12 > count 1, 5,5, 12 > 1 1, 7,7, 18 > value 1, 10,10, 21 > TOK_WHERE 3, 18,24, 10 > < 3, 20,24, 10 > TOK_TABLE_OR_COL 3, 20,20, 6 > age 3, 20,20, 6 > 35 3, 24,24, 12 > TOK_GROUPBY 4, 27,31, 9 > TOK_TABLE_OR_COL 4, 31,31, 9 > age 4, 31,31, 9 > TOK_ORDERBY 5, 34,38, 9 > TOK_TABSORTCOLNAMEASC 5, 38,38, 9 > TOK_TABLE_OR_COL 5, 38,38, 9 > age 5, 38,38, 9 > > scala.NotImplementedError: No parse rules for ASTNode type: 287, text: 35 : > 35 3, 24,24, 12 > " + > > org.apache.spark.sql.hive.HiveQl$.nodeToExpr(HiveQl.scala:1262) > ; > at org.apache.spark.sql.hive.HiveQl$.createPlan(HiveQl.scala:262) > at > org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:41) > at > org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:40) > ... > > Did this happen to anyone already? Any hint on how to solve it? > > Cheers, > Luis. >
