You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/02/25 02:15:04 UTC

[jira] [Created] (DRILL-2305) Using CTAS with nested structures

Rahul Challapalli created DRILL-2305:
----------------------------------------

             Summary: Using CTAS with nested structures
                 Key: DRILL-2305
                 URL: https://issues.apache.org/jira/browse/DRILL-2305
             Project: Apache Drill
          Issue Type: Improvement
          Components: Storage - Parquet
            Reporter: Rahul Challapalli
            Assignee: Steven Phillips


git.commit.id.abbrev=6676f2d

Drill needs to be able to read from a nested json file, cast individual fields, and still be able to maintain the nested structure.

Data Set :
{code}
{
  "map" : {"col1":12.2, "col2":25.5}
}
{code}

Sample Usage :
{code}
select cast(m1 as map(col1:decimal, col2:double)) from `data.json`;
{code}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)