[ https://issues.apache.org/jira/browse/DRILL-962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-962: --------------------------------- Issue Type: Improvement (was: Bug) > = or <> filter with date against timestamp columns fail > ------------------------------------------------------- > > Key: DRILL-962 > URL: https://issues.apache.org/jira/browse/DRILL-962 > Project: Apache Drill > Issue Type: Improvement > Components: Functions - Drill > Reporter: Krystal > Assignee: Mehant Baid > Fix For: Future > > > git.commit.id.abbrev=27a9c98 > git.build.time=10.06.2014 @ 21\:15\:17 PDT > 0: jdbc:drill:schema=dfs> select cast(name as varchar(30)), cast(create_time > as timestamp) create_time from student where cast(create_time as timestamp) = > date '2014-05-31'; > message: "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 97 to line > 1, column 146 ] < EigenbaseContextException:[ From line 1, column 97 to line > 1, column 146 ] < SqlValidatorException:[ Cannot apply '=' to arguments of > type '<TIMESTAMP(0)> = <DATE>'. Supported form(s): '<COMPARABLE_TYPE> = > <COMPARABLE_TYPE>' ]" > ] > The query run successfully in postgres and oracle. Looks like these 2 rdbms > implicitly convert the date to timestamp. -- This message was sent by Atlassian JIRA (v6.3.4#6332)