[ https://issues.apache.org/jira/browse/HIVE-18373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16324965#comment-16324965 ]
Prasad Nagaraj Subramanya commented on HIVE-18373: -------------------------------------------------- [~siddhantsaraf], mysql syntax is as below - {code} show fields in <table_name> like '%<search_term>%' {code} We could extend `show columns` in similar format {code} show columns in <table_name> like '%<search_term>%' {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 (v6.4.14#64029)