[jira] Updated: (HIVE-132) Show table and describe results should be read via FetchTask

["Raghotham Murthy (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Raghotham Murthy updated HIVE-132:
----------------------------------

    Attachment: hive-132.1.patch

Changed show tables and describe table to return results via FetchTask. 'extended' option results in bypassing the FetchTask for the extra information.

For JDBC we need to potentially add to the syntax of show tables and describe tables to return more columns (albeit with dummy values). We need the following columns:

For show tables:
NAME_SPACE
TAB_NAME

For describe (on a set of table names):
NAME_SPACE
TAB_NAME
COL_NAME
DATA_TYPE
DATA_LEN
DATA_PREC
DATA_SCALE 

> Show table and describe results should be read via FetchTask
> ------------------------------------------------------------
>
>                 Key: HIVE-132
>                 URL: https://issues.apache.org/jira/browse/HIVE-132
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Raghotham Murthy
>            Assignee: Raghotham Murthy
>            Priority: Minor
>             Fix For: 0.2.0
>
>         Attachments: hive-132.1.patch
>
>
> Right now there is a different code path in the Driver for show tables/describe etc. By adding the FetchTask the code paths will be merged. In addition, the results of these statements will be readable via JDBC.
> Going forward, we should provide SQL access to our metastore similar to access provided by Oracle or mysql to their catalog tables. In this jira, I will just add schema information to show tables and describe queries.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.