drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2305) Using CTAS with nested structures
Date Wed, 25 Feb 2015 01:15:04 GMT
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)

Mime
View raw message