You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "sanjiv singh (JIRA)" <ji...@apache.org> on 2015/09/28 10:39:04 UTC
[jira] [Created] (HIVE-11973) IN operator fails when the column
type is DATE
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)