[jira] [Updated] (DRILL-1060) Support ComplexToJson for Array Data Type

["Xiao Meng (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xiao Meng updated DRILL-1060:
-----------------------------

    Attachment: Time_Table.csv

Attached test file.

The test query is:
{code}
select * from dfs.`/root/InternalTest/Time_Table.csv`
{code}

And Drill Physical plan indeed has complex to json operator:
{code}
Drill Physical :
00-00    Screen: rowcount = 1.0, cumulative cost = {1.1 rows, 1.1 cpu, 0.0 io, 0.0 network}, id = 48
 00-01      ComplexToJson: rowcount = 1.0, cumulative cost = {1.0 rows, 1.0 cpu, 0.0 io, 0.0 network}, id = 47
 00-02        Scan(groupscan=[EasyGroupScan [selectionRoot=/root/InternalTest/Time_Table.csv, columns = null]]): rowcount = 1.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 46
 {code}

> Support ComplexToJson for Array Data Type
> -----------------------------------------
>
>                 Key: DRILL-1060
>                 URL: https://issues.apache.org/jira/browse/DRILL-1060
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - C++
>            Reporter: Xiao Meng
>            Assignee: Aditya Kishore
>         Attachments: Time_Table.csv
>
>
> When queries csv files from C++ client, the drillbit returns array (REPEATED VARCHAR if all elements are VARCHAR) instead of json.
> When support_complex_types is false, it should return a json string (REQUIRED VARCHAR).



--
This message was sent by Atlassian JIRA
(v6.2#6252)