drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4021) Cannot subract or add between two timestamps
Date Tue, 03 Nov 2015 22:58:28 GMT
Krystal created DRILL-4021:
------------------------------

             Summary: 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


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)

Mime
View raw message