Review Request: Allow Hive to connect to RDBMS

[Maxime Lanciaux <ml...@gmail.com>]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/9875/
-----------------------------------------------------------

Review request for hive.


Description
-------

Allow Hive to connect to RDBMS

I am thinking about something like :

SELECT jdbcload('driver','url','user','password','sql') FROM dual;

BI users will like this function because they are using Hive from Tableau or SAS (or other tools) and they don't want to exit their software and use a command ligne tool to load a little amount of data. (even if sqoop is a great tool)


Diffs
-----


Diff: https://reviews.apache.org/r/9875/diff/


Testing
-------

>add jar /home/hive/developpement/loadfromjdbc.jar;
>add jar /home/hive/developpement/tdgssconfig.jar;
>add jar /home/hive/developpement/terajdbc4.jar;
>create temporary function loadfromjdbc as 'org.apache.hadoop.hive.ql.udf.generic.LoadFromJDBC';
>SELECT result['column_name1'], result['column_name2']
FROM (
 SELECT loadfromjdbc('com.teradata.jdbc.TeraDriver', 
 'jdbc:teradata://ip/CHARSET=UTF16',
 'db_user', 'db_password',
 'SELECT * FROM database_name.table_name') AS (result) FROM dual
) ssreq 


Thanks,

Maxime Lanciaux