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] [Commented] (HIVE-12184) DESCRIBE of fully qualified table fails when db and table name match and non-default database is in use
Date Mon, 07 Dec 2015 14:42:10 GMT

    [ https://issues.apache.org/jira/browse/HIVE-12184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15045023#comment-15045023
] 

Naveen Gangam commented on HIVE-12184:
--------------------------------------

Thank you [~leftylev]. The added references to the new syntax in the old docs section looks
great. TODOC2.0 can be removed, I think.

Regarding the missing column info in the Describe Partition section, I noticed it too. I wasnt
sure if we missed documenting it or if it is a side-effect of the describe table partition
feature added later. But there are tests that specifically test for this syntax with a column
name and a partition spec. And I havent seen anything in the grammer and code that specifically
prohibit this syntax so I assumed it was supposed to work.
 
https://github.com/apache/hive/blob/branch-1.2/ql/src/test/queries/clientpositive/alter_partition_update_status.q#L8
https://github.com/apache/hive/blob/branch-1.2/ql/src/test/queries/clientpositive/alter_table_invalidate_column_stats.q#L38
https://github.com/apache/hive/blob/branch-1.2/ql/src/test/queries/clientpositive/analyze_tbl_part.q#L13
https://github.com/apache/hive/blob/branch-1.2/ql/src/test/queries/clientpositive/columnstats_part_coltype.q#L15
...

There are about half a dozen more test files that contain this syntax.


> 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
>              Labels: TODOC2.0
>             Fix For: 2.0.0
>
>         Attachments: HIVE-12184.10.patch, HIVE-12184.10.patch, HIVE-12184.2.patch, HIVE-12184.3.patch,
HIVE-12184.4.patch, HIVE-12184.5.patch, HIVE-12184.6.patch, HIVE-12184.7.patch, HIVE-12184.8.patch,
HIVE-12184.9.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)

Mime
View raw message