[
https://issues.apache.org/jira/browse/DRILL-585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cliff Buchanan updated DRILL-585:
---------------------------------
Assignee: Mehant Baid (was: 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: Mehant Baid
> Fix For: 1.0.0-BETA1
>
> Attachments: DRILL-585.patch
>
>
> 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)
