[jira] Commented: (HIVE-1010) Implement INFORMATION_SCHEMA in Hive

["Carl Steinbach (JIRA)" <ji...@apache.org>]

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

Carl Steinbach commented on HIVE-1010:
--------------------------------------

MySQL INFORMATION_SCHEMA views: http://dev.mysql.com/doc/refman/5.1/en/information-schema.html

There's been some discussion offline about supporting this using the JDO query language, i.e. expressing HiveQL queries against the INFORMATION_SCHEMA as JDOQL queries against the metastore.

Additionally, supporting an INFORMATION_SCHEMA is probably the biggest missing piece that blocks grafting the PostgreSQL ODBC driver onto Hive (as has been done for LucidDB, H2, etc).



> Implement INFORMATION_SCHEMA in Hive
> ------------------------------------
>
>                 Key: HIVE-1010
>                 URL: https://issues.apache.org/jira/browse/HIVE-1010
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Metastore, Query Processor, Server Infrastructure
>            Reporter: Jeff Hammerbacher
>
> INFORMATION_SCHEMA is part of the SQL92 standard and would be useful to implement using our metastore.

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