[
https://issues.apache.org/jira/browse/IMPALA-3455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Quanlong Huang updated IMPALA-3455:
-----------------------------------
Epic Link: IMPALA-12887
> Unable to drop AVRO table if schema file is missing
> ---------------------------------------------------
>
> Key: IMPALA-3455
> URL: https://issues.apache.org/jira/browse/IMPALA-3455
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.2.4
> Reporter: Eric Lin
> Priority: Minor
> Labels: newbie
>
> See the test case below:
> {code}
> host-10-17-80-18.coe.cloudera.com:21000] > CREATE external TABLE test STORED
> AS AVRO LOCATION '/tmp/93548/data' TBLPROPERTIES
> ('avro.schema.url'='/tmp/schema.json');
> Query: create external TABLE test STORED AS AVRO LOCATION '/tmp/93548/data'
> TBLPROPERTIES ('avro.schema.url'='/tmp/schema.json')
> WARNINGS: Ignoring column definitions in favor of Avro schema.
> The Avro schema has 2 column(s) but 0 column definition(s) were given.
> Fetched 0 row(s) in 4.08s
> # after renamed the file /tmp/schema.json to /tmp/schema.json.tmp
> [host-10-17-80-18.coe.cloudera.com:21000] > drop table test;
> Query: drop table test
> ERROR: AnalysisException: Failed to load metadata for table: case_93548.test
> CAUSED BY: AnalysisException: Invalid avro.schema.url: /tmp/schema.json. Path
> does not exist.
> CAUSED BY: TableLoadingException: Failed to load metadata for table:
> case_93548.test
> CAUSED BY: AnalysisException: Invalid avro.schema.url: /tmp/schema.json. Path
> does not exist.
> {code}
> Same command will work OK in Hive without problems.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
