phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhou Zach" <is...@foxmail.com>
Subject Unable to find parent table to determine USE_STATS_FOR_PARALLELIZATION
Date Fri, 07 Aug 2020 09:32:00 GMT
Hi all,


phoenix version:&nbsp;5.0.0+cdh6.2.0+1308267


when I query index table in&nbsp;phoenix-sqlline cli, I got error:


20/08/07 17:14:22 WARN iterate.BaseResultIterators: Unable to find parent table "ODS.USER_FLINK7"
of table "ODS.USER_FLINK7_CTIME_IDX" to determine USE_STATS_FOR_PARALLELIZATION org.apache.phoenix.schema.TableNotFoundException:
ERROR 1012 (42M03): Table undefined. tableName=ODS.USER_FLINK7 	at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:71)
	at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.java:583) 	at org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil.getStatsForParallelizationProp(PhoenixConfigurationUtil.java:648)
	at org.apache.phoenix.iterate.BaseResultIterators.<init&gt;(BaseResultIterators.java:504)
	at org.apache.phoenix.iterate.ParallelIterators.<init&gt;(ParallelIterators.java:62)
	at org.apache.phoenix.execute.ScanPlan.newIterator(ScanPlan.java:274) 	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:364)
	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:217) 	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:212)
	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:207) 	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:312)
	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:1830) 	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732) 	at sqlline.SqlLine.dispatch(SqlLine.java:813)
	at sqlline.SqlLine.begin(SqlLine.java:686) 	at sqlline.SqlLine.start(SqlLine.java:398) 	at
sqlline.SqlLine.main(SqlLine.java:291) 20/08/07 17:14:22 WARN iterate.BaseResultIterators:
Unable to find parent table "ODS.USER_FLINK7" of table "ODS.USER_FLINK7_CTIME_IDX" to determine
USE_STATS_FOR_PARALLELIZATION org.apache.phoenix.schema.TableNotFoundException: ERROR 1012
(42M03): Table undefined. tableName=ODS.USER_FLINK7 	at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:71)
	at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.java:583) 	at org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil.getStatsForParallelizationProp(PhoenixConfigurationUtil.java:648)
	at org.apache.phoenix.iterate.BaseResultIterators.<init&gt;(BaseResultIterators.java:504)
	at org.apache.phoenix.iterate.ParallelIterators.<init&gt;(ParallelIterators.java:62)
	at org.apache.phoenix.execute.ScanPlan.newIterator(ScanPlan.java:274) 	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:364)
	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:217) 	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:212)
	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:207) 	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:312)
	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:1830) 	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732) 	at sqlline.SqlLine.dispatch(SqlLine.java:813)
	at sqlline.SqlLine.begin(SqlLine.java:686) 	at sqlline.SqlLine.start(SqlLine.java:398) 	at
sqlline.SqlLine.main(SqlLine.java:291)
Please give me some adviceļ¼ŒThanks
Mime
View raw message