Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
None
-
None
Description
For example,
explain SELECT value from ( select explode(array(key, value)) as (value) from ( select * FROM src WHERE key > 200 ) A ) B WHERE value > 300 ;
Makes plan like this, removing last predicates
TableScan alias: src Filter Operator predicate: expr: (key > 200.0) type: boolean Select Operator expressions: expr: array(key,value) type: array<string> outputColumnNames: _col0 UDTF Operator function name: explode Select Operator expressions: expr: col type: string outputColumnNames: _col0 File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Attachments
Attachments
Issue Links
- blocks
-
HIVE-4904 A little more CP crossing RS boundaries
- Resolved
- duplicates
-
HIVE-6395 multi-table insert from select transform fails if optimize.ppd enabled
- Resolved
- is blocked by
-
HIVE-4295 Lateral view makes invalid result if CP is disabled
- Closed
-
HIVE-4297 LvJ operator does not have colExprMap for columns from UDTF
- Resolved
- is duplicated by
-
HIVE-5964 Hive missing a filter predicate causing wrong results joining tables after sort by
- Resolved
- is related to
-
HIVE-10841 [WHERE col is not null] does not work sometimes for queries with many JOIN statements
- Closed
- relates to
-
HIVE-4598 Incorrect results when using subquery in multi table insert
- Resolved
- links to