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

[Zhefeng Wang (Jira)]

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)