Sahil Takiar created HIVE-18552:
-----------------------------------

             Summary: Split hive.strict.checks.large.query into two configs, 
enable partition filter check by default
                 Key: HIVE-18552
                 URL: https://issues.apache.org/jira/browse/HIVE-18552
             Project: Hive
          Issue Type: Improvement
          Components: Hive
            Reporter: Sahil Takiar


{{hive.strict.checks.large.query}} controls the strict checks for restricting 
order bys with no limits, and scans of a partitioned table without a filter on 
the partition table.

While both checks prevent "large" queries from being run, they both control 
very different behavior. It would be better if users could control these 
restrictions separately.

Furthermore, many users make the mistake of abusing partitioned tables and 
often end up in a situation where they are running queries that are doing 
full-table scans of partitioned tables. This can lead to lots of issues for 
Hive - e.g. OOM issues because so many partitions are loaded in memory. So it 
would be good if we enabled this restriction by default.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to