[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman updated DRILL-4021: ------------------------------------ Attachment: Screen Shot 2015-11-04 at 8.12.34 AM.png > Cannot subract or add between two timestamps > -------------------------------------------- > > Key: DRILL-4021 > URL: https://issues.apache.org/jira/browse/DRILL-4021 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Data Types > Reporter: Krystal > Attachments: Screen Shot 2015-11-03 at 3.44.30 PM.png, Screen Shot > 2015-11-04 at 7.35.07 AM.png, Screen Shot 2015-11-04 at 8.12.34 AM.png > > > The following subtraction between 2 now() function works: > select now() - now()from voter_hive limit 1; > +---------+ > | EXPR$0 | > +---------+ > | PT0S | > +---------+ > > However, the following queries fail: > select now() - create_time from voter_hive where voter_id=1; > Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 26: Cannot > apply '-' to arguments of type '<ANY> - <TIMESTAMP(0)>'. Supported form(s): > '<NUMERIC> - <NUMERIC>' > '<DATETIME_INTERVAL> - <DATETIME_INTERVAL>' > '<DATETIME> - <DATETIME_INTERVAL>' > select create_time - cast('1997-02-12 15:18:31.072' as timestamp) from > voter_hive where voter_id=1; > Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 65: Cannot > apply '-' to arguments of type '<TIMESTAMP(0)> - <TIMESTAMP(0)>'. Supported > form(s): '<NUMERIC> - <NUMERIC>' > '<DATETIME_INTERVAL> - <DATETIME_INTERVAL>' > '<DATETIME> - <DATETIME_INTERVAL>' -- This message was sent by Atlassian JIRA (v6.3.4#6332)