You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Cliff Buchanan (JIRA)" <ji...@apache.org> on 2014/06/11 20:22:04 UTC
[jira] [Assigned] (DRILL-585) timestamp and time data not showing
up correctly in sqlline
[ https://issues.apache.org/jira/browse/DRILL-585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Cliff Buchanan reassigned DRILL-585:
------------------------------------
Assignee: Cliff Buchanan
> timestamp and time data not showing up correctly in sqlline
> -----------------------------------------------------------
>
> Key: DRILL-585
> URL: https://issues.apache.org/jira/browse/DRILL-585
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - CLI
> Reporter: Parth Chandra
> Assignee: Cliff Buchanan
> Fix For: 1.0.0-BETA1
>
>
> Executing the following query -
> select first, last, age, sex, salary, registered, cast(join_date as timestamp) TIMEST, cast(join_date as date) DT, cast(join_time as TIME) TM from dfs.`testTypes.json`
> returned the following results in sqlline-
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> | first | last | age | sex | salary | registered | TIMEST | DT | TM |
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> | Jimmy | James | 29 | M | 6300.1 | false | 2011-11-30 | 2011-11-30 | 00:00:00 |
> | anderson | carr | null | M | 6300.1 | false | null | null | null |
> | John | James | 29 | M | 6300.1 | true | 2011-11-30 | 2011-11-30 | 00:00:00 |
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> The timestamp column does not have time, and the time column has incorrect values.
> Data file contains the following data -
> {
> "first": "Jimmy",
> "last": "James",
> "age": 29,
> "sex": "M",
> "salary": 6300.10,
> "registered": false,
> "join_date": "2011-11-30",
> "join_time": "9:11:10.000"
> }
> {
> "first": "anderson",
> "last": "carr",
> "sex": "M",
> "salary": 6300.10,
> "registered": false
> }
> {
> "first": "John",
> "last": "James",
> "age": 29,
> "sex": "M",
> "salary": 6300.10,
> "registered": true,
> "join_date": "2011-11-30",
> "join_time": "8:59:32.000"
> }
--
This message was sent by Atlassian JIRA
(v6.2#6252)