Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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"
}
Attachments
Attachments
Issue Links
- is duplicated by
-
DRILL-857 localtime function returns incorrect result
- Closed