[
https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17598213#comment-17598213
]
Jacques commented on HIVE-17342:
--------------------------------
Can you please confirm in which Hive version this is resolved?
I tested with HIVE3.1.3 included in CDP7.1.7 SP1 and am still getting:
explain
SELECT * FROM sch.tb1 where 1 = 0;
|1|Plan optimized by CBO.|
|2| |
|3|Stage-0|
|4| Fetch Operator|
|5| limit:-1|
|6| Select Operator [SEL_2]|
|7| Output:["_col0","_col1","_col2","_col3","_col4"]|
|8| Filter Operator [FIL_4]|
|9| predicate:false|
|10| TableScan [TS_0]|
|11| Output:["_col0","_col1","_col2","_col3","_col4"]|
|12|
(select from a view = majority of my use cases)
explain
SELECT * FROM sch.vw1 where 1 = 0;
| | |
|Plan optimized by CBO.| |
|2| |
|3|Stage-0|
|4| Fetch Operator|
|5| limit:-1|
|6| Select Operator [SEL_3]|
|7| Output:["_col0"]|
|8| Filter Operator [FIL_2]|
|9| predicate:false|
|10| Select Operator [SEL_1]|
|11| TableScan [TS_0]|
|12| properties:\{"insideView":"TRUE"}|
|13| |
| | |
> Where condition with 1=0 should be treated similar to limit 0
> -------------------------------------------------------------
>
> Key: HIVE-17342
> URL: https://issues.apache.org/jira/browse/HIVE-17342
> Project: Hive
> Issue Type: Improvement
> Reporter: Rajesh Balamohan
> Assignee: Krisztian Kasa
> Priority: Minor
>
> In some cases, queries may get executed with where condition mentioning to
> "1=0" to get schema. E.g
> {noformat}
> SELECT * FROM (select avg(d_year) as y from date_dim where d_year>1999) q
> WHERE 1=0
> {noformat}
> Currently hive executes the query; it would be good to consider this similar
> to "limit 0" which does not execute the query.
> {code}
> hive> explain SELECT * FROM (select avg(d_year) as y from date_dim where
> d_year>1999) q WHERE 1=0;
> OK
> Plan optimized by CBO.
> Vertex dependency in root stage
> Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
> Stage-0
> Fetch Operator
> limit:-1
> Stage-1
> Reducer 2 vectorized, llap
> File Output Operator [FS_13]
> Group By Operator [GBY_12] (rows=1 width=76)
> Output:["_col0"],aggregations:["avg(VALUE._col0)"]
> <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
> PARTITION_ONLY_SHUFFLE [RS_11]
> Group By Operator [GBY_10] (rows=1 width=76)
> Output:["_col0"],aggregations:["avg(d_year)"]
> Filter Operator [FIL_9] (rows=1 width=0)
> predicate:false
> TableScan [TS_0] (rows=1 width=0)
>
> default@date_dim,date_dim,Tbl:PARTIAL,Col:NONE,Output:["d_year"]
> {code}
> It does generate 0 splits, but does send a DAG plan to the AM and receive 0
> rows as output.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
