[DRILL-2864] Unable to cast string literal with the valid value in ISO 8601 format to interval

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.9.0
• Fix Version/s: 1.2.0
• Component/s: Execution - Data Types
• Assignee: Daniel Barclay
• Reporter: Victoria Markman
• Created: 23/Apr/15 20:53
• Updated: 02/Sep/15 17:21
• Resolved: 30/Jun/15 20:04

Description

0: jdbc:drill:schema=dfs> select cast('P1D' as interval day) from t1;
Query failed: PARSE ERROR: From line 1, column 8 to line 1, column 34: Cast function cannot convert value of type CHAR(3) to type INTERVAL DAY

[744f1f35-f8c5-46ba-80f9-0efd87036903 on atsqa4-134.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)

Workaround: cast to varchar.

0: jdbc:drill:schema=dfs> select cast(cast('P1D' as varchar(3)) as interval day) from t1;
+------------+
|   EXPR$0   |
+------------+
| P1D        |
| P1D        |
| P1D        |
| P1D        |
| P1D        |
| P1D        |
| P1D        |
| P1D        |
| P1D        |
| P1D        |
+------------+
10 rows selected (0.191 seconds)

Issue Links

• is superceded by: DRILL-3430 CAST to interval type doesn't accept standard-format strings
• is superceded by: DRILL-3431 CHAR not handled same as VARCHAR for cast to INTERVAL
• is superceded by: DRILL-3432 Change or document: CAST to interval type doesn't reject non-standard strings