[
https://issues.apache.org/jira/browse/LIVY-683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marco Gaido resolved LIVY-683.
------------------------------
Resolution: Duplicate
> Livy SQLInterpreter get empty array when extract date format rows to json
> -------------------------------------------------------------------------
>
> Key: LIVY-683
> URL: https://issues.apache.org/jira/browse/LIVY-683
> Project: Livy
> Issue Type: Bug
> Components: REPL
> Reporter: Zhefeng Wang
> Priority: Major
> Attachments: image-2019-09-17-14-23-31-715.png
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> I submit a sql with select date format:
> {code:java}
> select to_date(update_time) from sec_ods.ods_binlog_task_list_d_whole where
> concat(YEAR, MONTH, DAY )=20190306 limit 10
> {code}
> in livy:
> !image-2019-09-17-14-23-31-715.png|width=429,height=424!
> we can see data is composed by some empty arrays.
> and in spark this sql can get correct result:
> {code:java}
> to_date(sec_ods.ods_binlog_task_list_d_whole.`update_time`)
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> 2019-03-04
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
