hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joydeep Sen Sarma (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HADOOP-4101) Support JDBC connections for interoperability between Hive and RDBMS
Date Mon, 27 Oct 2008 18:30:47 GMT

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

Joydeep Sen Sarma commented on HADOOP-4101:
-------------------------------------------

how are we planning on picking up the hadoop and hive configuration file? (the cli picks them
up through the classpath). the same concern applies to jar files (there's configuration in
the cli shell script to set it up to include jars in auxlib).

We will need a client-server model. the cli does not, for example, run on cygwin/windows and
there are all manner of pathing issues that we would need to fix to make that work. within
facebook - we won't even be able to access hdfs directly from windows agents that are outside
the secure zone (only http ports are available i believe). i verified from Dhruba that this
is the case in yahoo as well. so - we just can't run queries directly from windows machines
without a server side that is within the secure zone.

> 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