hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maxime Lanciaux" <>
Subject Review Request: Allow Hive to connect to RDBMS
Date Tue, 12 Mar 2013 11:00:51 GMT

This is an automatically generated e-mail. To reply, visit:

Review request for hive.


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)




>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']
 SELECT loadfromjdbc('com.teradata.jdbc.TeraDriver', 
 'db_user', 'db_password',
 'SELECT * FROM database_name.table_name') AS (result) FROM dual
) ssreq 


Maxime Lanciaux

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message