利用udf函数将hive数据导入到mysql

hive>add jar /opt/cloudera/parcels/CDH/jars/hive-contrib-1.1.0-cdh5.11.0.jar;
 

 
hive>add jar /usr/share/java/mysql-connector-java.jar;
 

hive>CREATE TEMPORARY FUNCTION dboutput AS 'org.apache.Hadoop.hive.contrib.genericudf.example.GenericUDFDBOutput';

 

hive>select

dboutput(

                'jdbc:mysql://localhost/dbname',

                'root',

'123456',

'insert into tab(col1_name,col2_name) values(?,?)',

clo1_name,col2_name)

from hive_db.hive_tab

limit 10;

#通过上面的语句将hive表数据直接导入到sql数据库

注：需要提前在sql数据库中建好tab表