Gopal V created HIVE-11428:
------------------------------
Summary: Performance: Struct IN() clauses are extremely slow (~10x
slower)
Key: HIVE-11428
URL: https://issues.apache.org/jira/browse/HIVE-11428
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 1.3.0, 2.0.0
Reporter: Gopal V
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
