You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2015/11/06 21:26:10 UTC
[jira] [Updated] (HIVE-12184) DESCRIBE of fully qualified table
fails when db and table name match and non-default database is in use
[ 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.4.patch
I am attaching a patch that proposes a change to the hive grammar for "DESCRIBE TABLE".
The following is the new syntax
DESCRIBE TABLE [DB.]TABLE [ COLUMN]
where DB is the database identifier (DOT ends the name of the database)
TABLE is table identifier
COLUMN is either
column name
column.$elem$ // references the list for list datatypes
column.$elem$.<listMember> // references the member of the list
column.$key$ // references the key for map datatypes
column.$value$ // references the value for the map data types.
Please review the change and let me know.
> 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.2.patch, HIVE-12184.3.patch, HIVE-12184.4.patch, 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)