普通hql运行速度慢,以及动态分区hql运行报错:
报错内容:
FAILED: SemanticException [Error 10096]: Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict
在hive-site.xml文件中添加如下内容:
<property>
<name>hive.exec.mode.local.auto</name>
<value>true</value>
</property>
在hive-site.xml文件中添加动态分区参数,内容如下:
<property>
<name> hive.exec.dynamic.partition </name>
<value>true</value></property>
<property>
<name> hive.exec.dynamic.partition.mode </name>
<value> nonstrict </value>
</property>