在公司人员技术水平层次不齐的时候,很有必要开启严格模式!
情况有三:
但是,再生成动态分区的时候,会失败,所以必须将其单独设置为非严格模式!!! 设置方式:
<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.
Comparing bigints and strings.
Comparing bigints and doubles.
Orderby without limit.
</description>
</property>