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)
