Unable to find parent table to determine USE_STATS_FOR_PARALLELIZATION

Fri, 07 Aug 2020 02:32:22 -0700 

Hi all,


phoenix version: 5.0.0+cdh6.2.0+1308267


when I query index table in 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

Reply via email to