Khurram Faraaz created DRILL-4913: ------------------------------------- Summary: need a better error message when explicit cast DATE value to TIME Key: DRILL-4913 URL: https://issues.apache.org/jira/browse/DRILL-4913 Project: Apache Drill Issue Type: Bug Components: Execution - Flow Affects Versions: 1.9.0 Reporter: Khurram Faraaz Priority: Minor
We need a better error message when explicit cast DATE value to TIME Drill 1.9.0 git commit ID: f3c26e34 {noformat} 0: jdbc:drill:schema=dfs.tmp> select cast(columns[0] as time) from `date_data.csv`; Error: SYSTEM ERROR: IllegalArgumentException: Invalid format: "2009-08-22" is malformed at "09-08-22" Fragment 0:0 [Error Id: f87f265f-fc98-49a3-9ef7-a9f95d1d0dff on centos-01.qa.lab:31010] (state=,code=0) {noformat} {noformat} Data used in the test, values are date strings in CSV file. [test@centos-ab datetime_data]# head date_data.csv 2009-08-22 1986-12-23 1969-07-11 2013-02-11 1977-07-24 1998-09-01 2013-11-25 1999-02-07 1959-04-12 2002-07-27 {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)