sanjiv singh created HIVE-11973: ----------------------------------- Summary: IN operator fails when the column type is DATE Key: HIVE-11973 URL: https://issues.apache.org/jira/browse/HIVE-11973 Project: Hive Issue Type: Bug Components: Parser, Query Processor Affects Versions: 1.0.0 Reporter: sanjiv singh
Test DLL : CREATE TABLE `date_dim`( `d_date_sk` int, `d_date_id` string, `d_date` date, `d_current_week` string, `d_current_month` string, `d_current_quarter` string, `d_current_year` string) ; Hive query : SELECT * FROM date_dim WHERE d_date IN ('2000-03-22','2001-03-22') ; In 1.0.0 , the above query fails with: FAILED: SemanticException [Error 10014]: Line 1:180 Wrong arguments ''2001-03-22'': The arguments for IN should be the same type! Types are: {date IN (string, string)} I saw below bug which is related to IN operator for partition column. HIVE-8099 : IN operator for partition column fails when the partition column type is DATE. Raising bug for the same ....as same error but for un-partitioned column. -- This message was sent by Atlassian JIRA (v6.3.4#6332)