HIVE-3963 : Hive & RDBMS example !

>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 'mlanciau.dev.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 

We can now do join with Hadoop and database data directly from Hive.

SQL inside SQL ! Browse HIVE-3963.