[
https://issues.apache.org/jira/browse/HIVE-1010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15991941#comment-15991941
]
Thejas M Nair commented on HIVE-1010:
-------------------------------------
Some questions/comments -
- Does the create table commands work against other databases ?
- If you need to customize queries against other db, how would you detect the
underlying db type
- Version table under sys should not be a mirror of underlying rdbms versions
table. Since upgrade of 'sys' db would be a separate invocation, it won't work
with rdbms schema upgrade. You can create a separate table db_version or so
that mirrors underlying version table.
- upgrade scripts - you can keep that simple by just doing drop and re-create
via new 'init' schema file.
- secure db password being sent to tasks via job.credentials apis
- Looks like this would go into hive 3.0.0, so schema file name would need to
be updated.
> Implement INFORMATION_SCHEMA in Hive
> ------------------------------------
>
> Key: HIVE-1010
> URL: https://issues.apache.org/jira/browse/HIVE-1010
> Project: Hive
> Issue Type: New Feature
> Components: Metastore, Query Processor, Server Infrastructure
> Reporter: Jeff Hammerbacher
> Assignee: Gunther Hagleitner
> Attachments: HIVE-1010.10.patch, HIVE-1010.11.patch,
> HIVE-1010.12.patch, HIVE-1010.7.patch, HIVE-1010.8.patch, HIVE-1010.9.patch
>
>
> INFORMATION_SCHEMA is part of the SQL92 standard and would be useful to
> implement using our metastore.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
