[jira] [Created] (IMPALA-5803) Database prefix does not always work properly if table with has same name

["Jason Phelps (JIRA)" <ji...@apache.org>]

Jason Phelps created IMPALA-5803:
------------------------------------

             Summary: Database prefix does not always work properly if table with has same name
                 Key: IMPALA-5803
                 URL: https://issues.apache.org/jira/browse/IMPALA-5803
             Project: IMPALA
          Issue Type: Bug
            Reporter: Jason Phelps


In the case where a table with an unsupported Hive SerDe shares a name with it's database, any operations on any table in the database will fail when using the qualified name (database.table), possibility with an ambiguity between database.table and table.column paths

Reproduction steps:

In Hive:
{code}
create database test1;
use test1;
add jar hdfs://nameservice1/tmp/hive-hcatalog-core-1.1.0-cdh5.11.0.jar;
CREATE TABLE test1 (a string )   ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe';
create table test2 (b string) stored as parquet;
{code}

In Impala:
{code:java}
[host:21000] > invalidate metadata;
[host:21000] > use test1;
[host:21000] > show tables;
+-------+
| name  |
+-------+
| test1 |
| test2 |
+-------+

[host:21000] > desc test2;
Query: describe test2
+------+--------+---------+
| name | type   | comment |
+------+--------+---------+
| b    | string |         |
+------+--------+---------+

[host:21000] > desc test1;
ERROR: AnalysisException: Failed to load metadata for table: test1
CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hive.hcatalog.data.JsonSerDe' is not supported.
CAUSED BY: TableLoadingException: Failed to load metadata for table: test1
CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hive.hcatalog.data.JsonSerDe' is not supported.

[host:21000] > desc test1.test2;
Query: describe test1.test2
ERROR: AnalysisException: Failed to load metadata for table: test1
CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hive.hcatalog.data.JsonSerDe' is not supported.
CAUSED BY: TableLoadingException: Failed to load metadata for table: test1
CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hive.hcatalog.data.JsonSerDe' is not supported.
{code}





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)