严格模式涉及到了一个参数 hive.mapred.mode
想要设置严格模式需要把他的值修改为strict
。
在hive-site.xml中这个配置是这么描述的:
<property>
<name>hive.mapred.mode</name>
<value>strict</value>
<description>
The mode in which the Hive operations are being performed.
In strict mode, some risky queries are not allowed to run.
They include:
<!--笛卡尔积-->
Cartesian Product.
<!--没有条件限制的分区查询-->
No partition being picked up for a query.
<!--bigint和string的比较-->
Comparing bigints and strings.
<!--bigint和doubles的比较-->
Comparing bigints and doubles.
<!--没有限制的limit-->
Orderby without limit.
</description>
</property>
也就是设置严格模式的话,以上5种操作就无法使用。