Get the App
SLTechnology News&Howtos  ›  Development  › 

How to start strict Mode in Hive

Shulou Source: shulou.com Published: 2022-06-01 06:15:03 10月02日 Update

This article mainly shows you "how to start strict mode in Hive". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to start strict mode in Hive".

Start strict mode

If you are querying a partitioned Hive table without providing a partitioning predicate (partitioning column condition), in this case, a query will be issued against all partitions of the table, which can be time-consuming and resource-intensive. Therefore, we define the following property as strict to indicate that the compiler will throw an error if the partition predicate is not provided on the partition table.

SET hive.partition.pruning=strict above is all the content of the article "how to start strict Mode in Hive". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Tags: Patterns content articles situations predicates learning help queries attributes instructions understandable more conditions organization knowledge editing compilers industries resources information Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Linux macOS Microsoft OPPO Reno