weixin_44836843的博客

HIVE经验汇总

hive存储过程示例

1 -- 设置hive的计算引擎为spark 2 set hive.execution.engine=spark; 3 4 -- 修复分区 5 set hive.msck.path.validation=ignore; 6 msck repair table sub_ladm_app_click_day_cnt; 7 8 -- 打印表头 9 set hive.cli.print.header=true;10 set hive.cli.print.row.to.vertical=true

代码实例一、创建hive连接,查询、关闭package com.zh.jg.hive;import java.sql.*;import java.util.Properties;public class HiveDB { private Connection con; private Statement stmt; static String driverClassName; static String url; static String username;