hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Madhudeep Petwal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18373) Make it easier to search for column name in a table
Date Fri, 19 Jan 2018 06:06:00 GMT

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

Madhudeep Petwal commented on HIVE-18373:
-----------------------------------------

Ok I looked up Hive.g grammar file. It looks like hive supports both 
{code:java}
hive> show tables '*abc*';{code}
{code:java}
hive> show tables like '*abc*';{code}
as we can see grammar rule for show tables
{code:java}
KW_SHOW KW_TABLES ((KW_FROM|KW_IN) db_name=identifier)? (KW_LIKE showStmtIdentifier|showStmtIdentifier)? 
-> ^(TOK_SHOWTABLES (TOK_FROM $db_name)? showStmtIdentifier?){code}
I will keep the syntax similar to show tables then.

This is my proposed grammar rule for show columns. Please review [~thejas]
{code:java}
KW_SHOW KW_COLUMNS (KW_FROM|KW_IN) tableName ((KW_FROM|KW_IN) db_name=identifier)? (KW_LIKE
showStmtIdentifier|showStmtIdentifier)?
 -> ^(TOK_SHOWCOLUMNS tableName $db_name? showStmtIdentifier?){code}

> Make it easier to search for column name in a table
> ---------------------------------------------------
>
>                 Key: HIVE-18373
>                 URL: https://issues.apache.org/jira/browse/HIVE-18373
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Siddhant Saraf
>            Assignee: Madhudeep Petwal
>            Priority: Minor
>
> Within a database, to filter for tables with the string 'abc' in its name, I can use
something like:
> {code:java}
> hive> use my_database;
> hive> show tables '*abc*';
> {code}
> It would be great if I can do something similar to search within the list of columns
in a table.
> I have a table with around 3200 columns. Searching for the column of interest is an onerous
task after doing a {{describe}} on it.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message