hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Madhudeep Petwal (JIRA)" <>
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


Madhudeep Petwal commented on HIVE-18373:

Ok I looked up Hive.g grammar file. It looks like hive supports both 
hive> show tables '*abc*';{code}
hive> show tables like '*abc*';{code}
as we can see grammar rule for show tables
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]
KW_SHOW KW_COLUMNS (KW_FROM|KW_IN) tableName ((KW_FROM|KW_IN) db_name=identifier)? (KW_LIKE
 -> ^(TOK_SHOWCOLUMNS tableName $db_name? showStmtIdentifier?){code}

> Make it easier to search for column name in a table
> ---------------------------------------------------
>                 Key: HIVE-18373
>                 URL:
>             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

View raw message