當前位置:編程學習大全網 - 網站源碼 - 如何在hadoop下連接hive

如何在hadoop下連接hive

通過JDBC連接

或是

HiveConf conf = new HiveConf();

conf.addResource(new Path("file:///usr/local/apache-hive-0.13.1-bin/conf/hive-site.xml"));

conf.addResource(new Path("file:///usr/local/apache-hive-0.13.1-bin/conf/hive-default.xml.template"));

conf.set("javax.jdo.option.ConnectionURL",

"jdbc:mysql://127.0.0.1:3306/hive?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8");

conf.set("hive.metastore.local", "true");

conf.set("javax.jdo.option.ConnectionDriverName","com.mysql.jdbc.Driver");

conf.set("javax.jdo.option.ConnectionUserName", "hive");

conf.set("javax.jdo.option.ConnectionPassword", "hive");

conf.set("hive.stats.dbclass", "jdbc:mysql");

conf.set("hive.stats.jdbcdriver", "com.mysql.jdbc.Driver");

conf.set("hive.exec.dynamic.partition.mode", "nonstrict");

set進去妳所想加入或是想設置的hive參數

  • 上一篇:蘋果手機越獄了怎麽安裝叉叉助手
  • 下一篇:向上突破指標源代碼
  • copyright 2024編程學習大全網