Zhefeng Wang created LIVY-683: --------------------------------- Summary: 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 Assignee: Zhefeng Wang Attachments: image-2019-09-17-14-23-31-715.png
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.2#803003)