What is Hive Strict Mode ?

Hive Strict Mode ( hive.mapred.mode=strict) enables hive to restrict certain performance intensive operations. Such as –

• It restricts queries of partitioned tables without a WHERE clause.

hive> set hive.mapred.mode=strict;
hive> SELECT s.name, s.class FROM students s LIMIT 100;
FAILED: Error in semantic analysis: No partition predicate found for
Alias "s" Table "students"
hive> set hive.mapred.mode=nonstrict;
hive> SELECT s.name, s.class FROM students s LIMIT 100;

• It restricts ORDER BY operation without a LIMIT clause ( since it uses a single reducer which can choke your processing if not handled properly

Also for dynamic partitons –

hive.exec.dynamic.partition.mode=strict

This is a default setting and prevents all partitions to be dynamic and requires at least one static partition.

You may also like –

• Top 20 Hadoop Big Data Books
• Hive : SORTY BY , DISTRIBUTE BY, CLUSTER BY