hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasad Chakka (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HADOOP-4101) Support JDBC connections for interoperability between Hive and RDBMS
Date Mon, 03 Nov 2008 22:32:44 GMT

    [ https://issues.apache.org/jira/browse/HADOOP-4101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12644835#action_12644835
] 

Prasad Chakka commented on HADOOP-4101:
---------------------------------------

Regarding unused files in metastore, these are the files that got carried over hive prototype
which used file based metastore. We left them there in case some one wants to use file based
metastore. So in a sense they are useful and there are tests.

I think we should combine the servers now. It will be difficult and time consuming to merge
them later. Advanced users can still have two installations of the same server but direct
metadata calls to one server and data calls to another server. But the default case, there
will be only one server and easier for maintenance.

Only issue I see is that metastore code is independent of ql/cli code. So it might be better
to build JDBC server on top of metastore server (ie extend metastore server) and import metastore
thrift IDL into service thrift IDL. So the JDBC service would be a superset of metastore functionality.

What do you guys think?

> Support JDBC connections for interoperability between Hive and RDBMS
> --------------------------------------------------------------------
>
>                 Key: HADOOP-4101
>                 URL: https://issues.apache.org/jira/browse/HADOOP-4101
>             Project: Hadoop Core
>          Issue Type: Improvement
>          Components: contrib/hive
>            Reporter: YoungWoo Kim
>            Priority: Minor
>         Attachments: hadoop-4101.1.patch
>
>
> In many DW and BI systems, the data are stored in RDBMS for now such as oracle, mysql,
postgresql ... for reporting, charting and etc.
> It would be useful to be able to import data from RDBMS and export data to RDBMS using
JDBC connections.
> If Hive support JDBC connections, It wll be much easier to use 3rd party DW/BI tools.

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


Mime
View raw message