question Re: How to enforce a user to query a hive table using a partition clause in Support Questions

question Re: How to enforce a user to query a hive table using a partition clause in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-enforce-a-user-to-query-a-hive-table-using-a/m-p/290133#M214697 <P>you can set hive.mapred.mode = strict; Quoting from doc: <A href="https://blog.cloudera.com/improving-query-performance-using-partitioning-in-apache-hive/" target="_blank">https://blog.cloudera.com/improving-query-performance-using-partitioning-in-apache-hive/</A></P><LI-CODE lang="markup">If your partitioned table is very large, you could block any full table scan queries by putting Hive into strict mode using the set hive.mapred.mode=strict command. In this mode, when users submit a query that would result in a full table scan (i.e. queries without any partitioned columns) an error is issued.</LI-CODE><P> </P> Thu, 20 Feb 2020 05:56:01 GMT venkatsambath 2020-02-20T05:56:01Z