[
https://issues.apache.org/jira/browse/HIVE-18373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16315681#comment-16315681
]
Madhudeep Petwal edited comment on HIVE-18373 at 1/8/18 5:32 AM:
-----------------------------------------------------------------
Yeah, I was thinking of first implementing for table names regex.
show tables \*abc\*;
show tables '*abc*';
show tables "*abc*";
show tables *ab*c;
where * will not be any letter in table name.
Please tell me your views on this.
was (Author: minions):
Yeah, I was thinking of first implementing for table names regex.
show tables *abc*;
show tables '*abc*';
show tables "*abc*";
show tables *ab*c;
where * will not be any letter in table name.
Please tell me your views on this.
> 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
(v6.4.14#64029)
