You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Zhou Zach <is...@foxmail.com> on 2020/08/07 09:32:00 UTC
Unable to find parent table to determine USE_STATS_FOR_PARALLELIZATION
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>(BaseResultIterators.java:504) at org.apache.phoenix.iterate.ParallelIterators.<init>(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>(BaseResultIterators.java:504) at org.apache.phoenix.iterate.ParallelIterators.<init>(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
Re: Unable to find parent table to determine USE_STATS_FOR_PARALLELIZATION
Posted by Istvan Toth <st...@apache.org>.
Hi!
The version you are using is delivered by Cloudera.
The Apache Community cannot support a vendor delivered version, as they do
not have access to the source code.
Please contact Cloudera support.
regrards
Istvan
On Fri, Aug 7, 2020 at 11:32 AM Zhou Zach <is...@foxmail.com> wrote:
> 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>(BaseResultIterators.java:504)
> at org.apache.phoenix.iterate.ParallelIterators.<init>(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>(BaseResultIterators.java:504)
> at org.apache.phoenix.iterate.ParallelIterators.<init>(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
>
>
>