Hive 运行模式：严格模式

在实际的项目集群环境中，hive的运行模式肯定是严格模式

配置方式：

Hive CLi 临时
hive-site.xml 全局

配置

hive.mapred.mode strict //默认是nonstrict 不严格 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.笛卡尔积，join 没有on No partition being picked up for a query.没有分区信息的查询：分区表必须指定分区字段 Comparing bigints and strings. Comparing bigints and doubles. Orderby without limit. order by 没有limit