[DRILL-4021] Cannot subract or add between two timestamps

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Execution - Data Types
• Labels: interval
• Assignee: Unassigned
• Reporter: Krystal
• Created: 03/Nov/15 22:58
• Updated: 04/Nov/15 21:33

Description

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>'