[LIVY-683] Livy SQLInterpreter get empty array when extract date format rows to json

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: REPL
• Assignee: Unassigned
• Reporter: Zhefeng Wang
• Created: 17/Sep/19 06:29
• Updated: 21/Sep/19 17:07
• Resolved: 21/Sep/19 17:07

Description

I submit a sql with select date format: 

select to_date(update_time) from sec_ods.ods_binlog_task_list_d_whole where concat(YEAR, MONTH, DAY )=20190306 limit 10

in livy:

we can see data is composed by some empty arrays.

and in spark this sql can get correct result:

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

Issue Links

• duplicates: LIVY-613 Livy can't handle the java.sql.Date type correctly
• links to: GitHub Pull Request #234