Alicia Ying Shu created PHOENIX-3096: ----------------------------------------
Summary: Explain command is raising an ArithmeticException Key: PHOENIX-3096 URL: https://issues.apache.org/jira/browse/PHOENIX-3096 Project: Phoenix Issue Type: Bug Reporter: Alicia Ying Shu Assignee: Alicia Ying Shu EXPLAIN SELECT ID FROM GRAMMAR_TABLE FETCH NEXT 10 ROWS ONLY; 2016-07-18 10:26:11,058|beaver.machine|INFO|22814|140039552661248|MainThread|java.lang.ArithmeticException: / by zero 2016-07-18 10:26:11,058|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.execute.ScanPlan.isSerial(ScanPlan.java:135) 2016-07-18 10:26:11,058|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.execute.ScanPlan.buildResultIteratorFactory(ScanPlan.java:154) 2016-07-18 10:26:11,058|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.execute.ScanPlan.<init>(ScanPlan.java:89) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.execute.ScanPlan.<init>(ScanPlan.java:85) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:586) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:510) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:205) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:160) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:404) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:378) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExplainStatement.compilePlan(PhoenixStatement.java:463) 2016-07-18 10:26:11,059|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExplainStatement.compilePlan(PhoenixStatement.java:443) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:271) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:266) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:265) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1444) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.Commands.execute(Commands.java:822) 2016-07-18 10:26:11,060|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.Commands.sql(Commands.java:732) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.dispatch(SqlLine.java:808) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.runCommands(SqlLine.java:1711) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.Commands.run(Commands.java:1285) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2016-07-18 10:26:11,061|beaver.machine|INFO|22814|140039552661248|MainThread|at java.lang.reflect.Method.invoke(Method.java:498) 2016-07-18 10:26:11,063|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) 2016-07-18 10:26:11,063|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.dispatch(SqlLine.java:804) 2016-07-18 10:26:11,063|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.initArgs(SqlLine.java:613) 2016-07-18 10:26:11,063|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.begin(SqlLine.java:656) 2016-07-18 10:26:11,064|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.start(SqlLine.java:398) 2016-07-18 10:26:11,064|beaver.machine|INFO|22814|140039552661248|MainThread|at sqlline.SqlLine.main(SqlLine.java:292) 2016-07-18 10:26:11,064|beaver.machine|INFO|22814|140039552661248|MainThread|[1;31mAborting command set because "force" is false and command failed: "EXPLAIN SELECT ID FROM GRAMMAR_TABLE FETCH NEXT 10 ROWS ONLY;"[m 2016-07-18 10:26:11,064|beaver.machine|INFO|22814|140039552661248|MainThread|Closing: org.apache.phoenix.jdbc.PhoenixConnection 2016-07-18 10:26:11,508|main|INFO|22814|140039552661248|MainThread|testCaseAnnotationList = [u'hdp_2_5_0_0'] 2016-07-18 10:26:11,508|main|INFO|22814|140039552661248|MainThread|testCaseMarkerList = ['NEW_TESTS'] 2016-07-18 10:26:11,509|main|INFO|22814|140039552661248|MainThread|TEST "test_VerifyOffsetFetchClause[NEXT]" FAILED in 6.00 seconds -- This message was sent by Atlassian JIRA (v6.3.4#6332)