[
https://issues.apache.org/jira/browse/HADOOP-4101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12643014#action_12643014
]
Joydeep Sen Sarma commented on HADOOP-4101:
-------------------------------------------
ok - Ashish just walked us through a couple of scenarios:
- BI tool has server side. in this case the approach in this patch might work -
but the concern about setting up classpaths and the suitability of running
hadoop code setting classloaders and stuff on the same JVM as the BI server is
suspect. At the minimum this has significant integration issues for each BI
server.
- BI tool does not have a server side - only a client. I think this is a very
common scenario and something which we should try to cover (since the whole
premise of hadoop/hive is to avoid spending a lot of money - which is what BI
tools with server side will require). In this case - the approach in this patch
will be hard to make work because of firewalling issues that i had mentioned in
the previous post (even if all the technical issues like hive treatment of
windows paths are resolved).
hopefully this captures the issues more accurately.
> 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.
