Categories

Jan 12 in Big Data | Hadoop
Q: What is the use of strict mode in Hive?

1 Answer

Jan 12

We use strict mode in Hive to avoid performing full scan of a table in a query. It is very useful when we have a very large table. We can use ‘set hive.mapred.mode=strict’ command to put Hive into strict mode. In this mode, any query that needs full table scan will throw error to user.

Strict mode is a useful option in

 

Hive to improve performance and avoid any unexpected delays  due to full table scan.

 

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Jan 12 in Big Data | Hadoop
Jan 12 in Big Data | Hadoop
Jun 7 in Hive
...