hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naveen Gangam (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-12184) DESCRIBE of fully qualified table fails when db and table name match and non-default database is in use
Date Tue, 20 Oct 2015 03:18:27 GMT

     [ https://issues.apache.org/jira/browse/HIVE-12184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Naveen Gangam updated HIVE-12184:
---------------------------------
    Attachment: HIVE-12184.patch

The getAttemptTableName() expects the fully qualified name to be just "table" or "table.column"
or "table column". But it could also be of format "dbname.table" or "dbname.table column".

The fix proposed factors in the fact that the DB name could be part of this qualified name.

> DESCRIBE of fully qualified table fails when db and table name match and non-default
database is in use
> -------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-12184
>                 URL: https://issues.apache.org/jira/browse/HIVE-12184
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.2.1
>            Reporter: Lenni Kuff
>            Assignee: Naveen Gangam
>         Attachments: HIVE-12184.patch
>
>
> DESCRIBE of fully qualified table fails when db and table name match and non-default
database is in use.
> Repro:
> {code}
> : jdbc:hive2://localhost:10000/default> create database foo;
> No rows affected (0.116 seconds)
> 0: jdbc:hive2://localhost:10000/default> create table foo.foo(i int);
> 0: jdbc:hive2://localhost:10000/default> describe foo.foo;
> +-----------+------------+----------+--+
> | col_name  | data_type  | comment  |
> +-----------+------------+----------+--+
> | i         | int        |          |
> +-----------+------------+----------+--+
> 1 row selected (0.049 seconds)
> 0: jdbc:hive2://localhost:10000/default> use foo;
> 0: jdbc:hive2://localhost:10000/default> describe foo.foo;
> Error: Error while processing statement: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. Error in getting fields from serde.Invalid Field foo
(state=08S01,code=1)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message