You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Gelesh (JIRA)" <ji...@apache.org> on 2013/06/27 17:25:21 UTC

[jira] [Commented] (HIVE-4793) Show Colunms Table_Name;

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

Gelesh commented on HIVE-4793:
------------------------------

Query TBLS with TbleName you could get SD_ID,
Query COLUMNS_V2 (or COLUNMS if hive version is less than 0.9) with SD_ID you could fetch out

1) COMMENT VARCHAR(256) PARAM_KEY VARCHAR(256)
/// could be null
2) COLUMN_NAME VARCHAR(128)
/// Name of the co;unm
3)TYPE_NAME VARCHAR(4000)
/// TYPE_NAME
4)INTEGER_IDX INT(11)
/// the zero based index of the feild in the file, which hive reffers

# this schema is as per hive-0.9 meta store, COLUMNS_V2 table, 
                
> Show Colunms Table_Name;
> ------------------------
>
>                 Key: HIVE-4793
>                 URL: https://issues.apache.org/jira/browse/HIVE-4793
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Gelesh
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira