1 思路 1.1 查看explain,使用spark引擎的执行计划) 1.2 查看yarn日志 1.3 向量化查询 –开启向量化查询开关 set hive.vectorized.execution.enabled=true; select s_age, max(s_desc) num from student_tb_orc group by s_age; 开启hive.vectorized.execution.enabled操...
1. Load方式,可以从本地或HDFS上导入,本地是copy,HDFS是移动 本地:load data local inpath ‘/root/student.txt’ into table student; HDFS:load data inpath ‘/user/hive/data/student.txt’ into table student; 2. Insert方式ÿ...