[ 
https://issues.apache.org/jira/browse/PHOENIX-6413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17303174#comment-17303174
 ] 

ASF GitHub Bot commented on PHOENIX-6413:
-----------------------------------------

ZhaoBQ commented on pull request #1168:
URL: https://github.com/apache/phoenix/pull/1168#issuecomment-800877492


   I can not run test in local. I use command 'mvn clean package 
-Dtest=GroupByIT', and the error:
   `[INFO] Running org.apache.phoenix.end2end.GroupByIT
   [ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 
42.827 s <<< FAILURE! - in org.apache.phoenix.end2end.GroupByIT
   [ERROR] org.apache.phoenix.end2end.GroupByIT  Time elapsed: 42.818 s  <<< 
ERROR!
   java.lang.RuntimeException: java.io.IOException: Shutting down
           at 
org.apache.phoenix.query.BaseTest.initMiniCluster(BaseTest.java:549)
           at 
org.apache.phoenix.query.BaseTest.setUpTestCluster(BaseTest.java:449)
           at 
org.apache.phoenix.query.BaseTest.checkClusterInitialized(BaseTest.java:435)
           at 
org.apache.phoenix.query.BaseTest.setUpTestDriver(BaseTest.java:517)
           at 
org.apache.phoenix.query.BaseTest.setUpTestDriver(BaseTest.java:512)
           at 
org.apache.phoenix.end2end.ParallelStatsDisabledIT.doSetup(ParallelStatsDisabledIT.java:62)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:498)
           at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
           at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
           at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
           at 
org.junit.internal.runners.statements.RunBefores.invokeMethod(RunBefores.java:33)
           at 
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
           at 
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
           at 
org.apache.phoenix.SystemExitRule$1.evaluate(SystemExitRule.java:40)
           at 
org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54)
           at org.junit.rules.RunRules.evaluate(RunRules.java:20)
           at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
           at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
           at 
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
           at 
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
           at 
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
           at 
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
           at 
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
           at 
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
           at 
org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
           at 
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
   Caused by: java.io.IOException: Shutting down
           at 
org.apache.hadoop.hbase.MiniHBaseCluster.init(MiniHBaseCluster.java:266)
           at 
org.apache.hadoop.hbase.MiniHBaseCluster.<init>(MiniHBaseCluster.java:115)
           at 
org.apache.hadoop.hbase.HBaseTestingUtility.startMiniHBaseCluster(HBaseTestingUtility.java:1177)
           at 
org.apache.hadoop.hbase.HBaseTestingUtility.startMiniCluster(HBaseTestingUtility.java:1140)
           at 
org.apache.hadoop.hbase.HBaseTestingUtility.startMiniCluster(HBaseTestingUtility.java:1094)
           at 
org.apache.phoenix.query.BaseTest.initMiniCluster(BaseTest.java:544)
           ... 28 more
   Caused by: java.lang.RuntimeException: Master not active after 30000ms
           at 
org.apache.hadoop.hbase.util.JVMClusterUtil.waitForEvent(JVMClusterUtil.java:232)
           at 
org.apache.hadoop.hbase.util.JVMClusterUtil.startup(JVMClusterUtil.java:188)
           at 
org.apache.hadoop.hbase.LocalHBaseCluster.startup(LocalHBaseCluster.java:430)
           at 
org.apache.hadoop.hbase.MiniHBaseCluster.init(MiniHBaseCluster.java:259)
           ... 33 more
   `


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


> Having cannot resolve alias
> ---------------------------
>
>                 Key: PHOENIX-6413
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6413
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.14.3
>            Reporter: Baiqiang Zhao
>            Assignee: Baiqiang Zhao
>            Priority: Major
>
> For example:
> {code:java}
> CREATE TABLE test_table (a_string varchar not null, col1 integer CONSTRAINT 
> pk PRIMARY KEY (a_string));
> select a_string, sum(col1) as sumCol1 from test_table group by a_string 
> having sumCol1>20 order by sumCol1;
> {code}
> Error log:
> {code:java}
> Caused by: org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 
> (42703): Undefined column. columnName=TEST_TABLE.SUMCOL1Caused by: 
> org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): 
> Undefined column. columnName=TEST_TABLE.SUMCOL1 at 
> org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.java:828)
>  at 
> org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:477)
>  at 
> org.apache.phoenix.compile.HavingCompiler$HavingClauseVisitor.visit(HavingCompiler.java:173)
>  at 
> org.apache.phoenix.compile.HavingCompiler$HavingClauseVisitor.visit(HavingCompiler.java:104)
>  at org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56) 
> at 
> org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)
>  at 
> org.apache.phoenix.parse.ComparisonParseNode.accept(ComparisonParseNode.java:45)
>  at org.apache.phoenix.compile.HavingCompiler.rewrite(HavingCompiler.java:75) 
> at 
> org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:548)
>  at 
> org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:507)
>  at 
> org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:193)
>  at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:153) 
> at 
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:493)
>  at 
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:459)
>  at 
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:302) at 
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:291) at 
> org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:290)
>  at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:283)
>  at 
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1834) 
> at 
> org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:747) 
> ... 24 more
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to