[jira] [Commented] (HIVE-5912) Show partition command doesn't support db.table

[Lefty Leverenz (JIRA)]

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

Lefty Leverenz commented on HIVE-5912:
--------------------------------------

This should be documented in the wiki in [Show 
Partitions|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowPartitions].

For example: 

{quote}
SHOW PARTITIONS \[db_name.]table_name
{quote}

and: 

{quote}
SHOW PARTITIONS \[db_name.]table_name PARTITION(ds='2010-03-03');
SHOW PARTITIONS \[db_name.]table_name PARTITION(hr='12');
SHOW PARTITIONS \[db_name.]table_name PARTITION(ds='2010-03-03', hr='12');
{quote}

I'll add \[db_name.] to the wiki examples if you okay the changes here.

Also, does similar syntax work for SHOW TBLPROPERTIES, or does it have an "IN | 
FROM db_name" clause?  (See [Show Table 
Properties|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowTableProperties].)
  All other SHOW statements have some way to specify the database.

> Show partition command doesn't support db.table
> -----------------------------------------------
>
>                 Key: HIVE-5912
>                 URL: https://issues.apache.org/jira/browse/HIVE-5912
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.12.0
>            Reporter: Yu Zhao
>             Fix For: 0.13.0
>
>         Attachments: HIVE-5912.2.patch, HIVE-5912.patch
>
>
> {code}
> hive (default)> show partitions log.history;
> FAILED: ParseException line 1:19 missing EOF at '.' near 'log'
> {code}
> This command doesn't work when we use db.tablename as tablename in its 
> parameter.



--
This message was sent by Atlassian JIRA
(v6.1#6144)