Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Mon, 21 Jul 2014 23:02:38 +0000 (UTC)
From: "Krystal (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12728728.1405983683345.14655.1405983758718@arcas>
In-Reply-To: <JIRA.12728728.1405983683345@arcas>
References: <JIRA.12728728.1405983683345@arcas>
Subject: [jira] [Created] (DRILL-1165) Cast a varchar timestamp into date
 fails
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Krystal created DRILL-1165:
------------------------------

             Summary: Cast a varchar timestamp into date fails 
                 Key: DRILL-1165
                 URL: https://issues.apache.org/jira/browse/DRILL-1165
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


git.commit.id.abbrev=e5c2da0

I have the following varchar data casted as timestamp:
0: jdbc:drill:schema=dfs> select cast(create_time as timestamp) from student where student_id=15;
+------------+
|   EXPR$0   |
+------------+
| 2014-11-12 12:38:15.0 |

I can cast the varchar data to a date:
0: jdbc:drill:schema=dfs> select cast(create_time as date) from student where student_id=15;
+------------+
|   EXPR$0   |
+------------+
| 2014-11-12 |
+------------+

However, it fails when I tried to cast it to a time:
0: jdbc:drill:schema=dfs> select cast(create_time as time) from student where student_id=15;
message: "Failure while running fragment. < IllegalArgumentException:[ Invalid format: "2014-11-12 12:38:15" is malformed at "14-11-12 12:38:15" ]"

If it works for date, it should work for time.  This query returned the time portion of the string when executed from postgres.


--
This message was sent by Atlassian JIRA
(v6.2#6252)