[ https://issues.apache.org/jira/browse/PHOENIX-3096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15394506#comment-15394506 ]
Alicia Ying Shu commented on PHOENIX-3096: ------------------------------------------ The codes have been changed. No longer valid. > 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)