Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.3.0, 2.0.0
-
None
Description
Hive today does not support tuple IN() clauses today, but provides a way to rewrite (a,b) IN (...) using complex types.
select * from table where STRUCT(a,b) IN (STRUCT(1,2), STRUCT(2,3) ...);
This would be fine, except it is massively slower due to ObjectConvertors and Struct constructor not being constant folded.
Attachments
Attachments
Issue Links
- is depended upon by
-
HIVE-11468 Vectorize: Struct IN() clauses
- Closed
- is part of
-
HIVE-11315 Compilation performance issues for large queries
- Resolved
- is required by
-
HIVE-11462 GenericUDFStruct should constant fold at compile time
- Closed