项目作者: gary0416

项目描述 :
hive jdbc handler for hive 2.3 below
高级语言: Java
项目地址: git://github.com/gary0416/hive-jdbc-handler.git
创建时间: 2019-07-22T06:17:39Z
项目社区:https://github.com/gary0416/hive-jdbc-handler

开源协议:MIT License

下载


hive jdbc storage handler

based on https://github.com/apache/hive/tree/master/jdbc-handler (tag rel/release-2.3.5, HIVE-1555:hive 2.3.0 support JDBC Storage Handler).

works fine with hive 2.1.0(hdp 2.6.3.0-235):

  • modify hive and hadoop version.
  • modify maven shade configuration, add extra jar and mysql driver.
  • fix limit bug (reference part of HIVE-1010).

usage

  1. set role admin;
  2. add jar hdfs:///path/to/hive-jdbc-handler-1.0.0.jar;
  3. CREATE EXTERNAL TABLE mysql_your_table(
  4. id BIGINT,
  5. code STRING
  6. )
  7. STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
  8. TBLPROPERTIES (
  9. "hive.sql.database.type" = "MYSQL",
  10. "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver",
  11. "hive.sql.jdbc.url" = "jdbc:mysql://IP:PORT/db?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&verifyServerCertificate=false&useSSL=false",
  12. "hive.sql.dbcp.username" = "username",
  13. "hive.sql.dbcp.password" = "password",
  14. "hive.sql.query" = "SELECT id,code FROM your_table",
  15. "hive.sql.dbcp.maxActive" = "4"
  16. );