[
https://issues.apache.org/jira/browse/PHOENIX-7516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth resolved PHOENIX-7516.
----------------------------------
Fix Version/s: 5.3.0
5.2.2
5.1.2
Resolution: Fixed
Committed to all active branches.
Thanks for the fix [~chaijunjie] .
> TableNotFoundException thrown when not specify schema in CsvBulkloadTool
> ------------------------------------------------------------------------
>
> Key: PHOENIX-7516
> URL: https://issues.apache.org/jira/browse/PHOENIX-7516
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.2.1
> Reporter: chaijunjie
> Assignee: chaijunjie
> Priority: Major
> Fix For: 5.3.0, 5.2.2, 5.1.2
>
>
> when i test CsvBulkloadTool, i find the new version run failed....but old
> version worked fine
> hbase org.apache.phoenix.mapreduce.CsvBulkLoadTool -t MY_SCHEMA.TEST2 -i
> /tmp/data1.csv
> {code:java}
> 2025-01-24T11:57:41,703 INFO [main]
> connectionqueryservice.ConnectionQueryServicesMetricsManager: Created object
> for NoOp Connection query service metrics manager
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
> undefined. tableName=MY_SCHEMA.TEST2
> at
> org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:799)
> at
> org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:448)
> at
> org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:233)
> at
> org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:211)
> at org.apache.phoenix.util.ParseNodeUtil.rewrite(ParseNodeUtil.java:177)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:712)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:685)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:360)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:341)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:341)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:327)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:2227)
> at
> org.apache.phoenix.mapreduce.AbstractBulkLoadTool.loadData(AbstractBulkLoadTool.java:251)
> at
> org.apache.phoenix.mapreduce.AbstractBulkLoadTool.run(AbstractBulkLoadTool.java:187)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:81)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:95)
> at
> org.apache.phoenix.mapreduce.CsvBulkLoadTool.main(CsvBulkLoadTool.java:158)
> {code}
> PHOENIX-6405 add a check wether table is empty for global index, but the
> table name in SQL is wrong when give a tablename include schema...
> for example we use "-t MY_SCHEMA.TEST2", and not specify shema, then
> SchemaUtil.getEscapedTableName will return {*}"MY_SCHEMA.TEST2"{*}, but it
> should return *"MY_SCHEMA"."TEST2"*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
