Import hive data to MySQL

Import hiveDataMySQL

1. UDF

UseUDFConvenient,CodeInHttp://svn.apache.org/repos/asf/hive/trunk/contrib/src/java/org/apache/hadoop/hive/contrib/genericudf/example/GenericUDFDBOutput.java

Create temporary function dboutput as 'hive. UDF. genericudfdboutput ';

Usage: Select dboutput ('jdbc: mysql: // ebpptest01: 3306/db', 'root', '123', 'insert ignore into mysql_table (merabbr, merchantcm) values (?,?) ', Merabbr, merchantcm) from hive_table

2. sqoop-hcatalog

Install sqoop,HIve-0.11.0 version integrated with hcatalog

Usage sqoop export -- connect JDBC: mysql: // ebpptest01: 3306/DB -- username root -- password 111111 -- hive-partition-key statdate -- hive-partition-value 2013-08-12-Table mysql_table -- hcatalog-Table hive_mysql

3. sqoop

Usage:Sqoop export -- connect JDBC: mysql: // ebpptest01: 3306/DB -- username root -- password 111111 -- table mysql_table -- export-DIR/user/hive/warehouse/hive_table/dt = 2013-08-14