drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Norris Lee (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1151) JSON nested data returns empty for all rows except the first when using selections
Date Wed, 16 Jul 2014 23:31:05 GMT
Norris Lee created DRILL-1151:
---------------------------------

             Summary: JSON nested data returns empty for all rows except the first when using
selections
                 Key: DRILL-1151
                 URL: https://issues.apache.org/jira/browse/DRILL-1151
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Norris Lee


Without the limit clause, everything gets returned:
{code}
0: jdbc:drill:zk=localhost:5181> SELECT * FROM `dfs`.`optdrill`.`./raw-files/donuts/moredonuts.json`;
+------------+------------+------------+------------+------------+------------+------------+------------+
|     id     |    type    |    name    |    ppu     |   sales    |  batters   |  topping 
 |  filling   |
+------------+------------+------------+------------+------------+------------+------------+------------+
| 0001       | donut      | Cake       | 0.55       | 35         | {"batter":[{"id":"1001","type":"Regular"},{"id":"1002","type":"Chocolate"},{"id":"100
|
| 0002       | donut      | Raised     | 0.69       | 145        | {"batter":[{"id":"1001","type":"Regular"}]}
| [{"id":"5001","type":"None"},{"id":"500 |
| 0003       | donut      | Old Fashioned | 0.55       | 300        | {"batter":[{"id":"1001","type":"Regular"},{"id":"1002","type":"Chocolate"}]}
| [{" |
| 0004       | donut      | Filled     | 0.69       | 14         | {"batter":[{"id":"1001","type":"Regular"},{"id":"1002","type":"Chocolate"},{"id":"100
|
| 0005       | donut      | Apple Fritter | 1.0        | 700        | {"batter":[{"id":"1001","type":"Regular"}]}
| [{"id":"5002","type":"Glazed"}] | [] |
+------------+------------+------------+------------+------------+------------+------------+------------+
5 rows selected (0.785 seconds)

{code}

Using the limit clause, the batters column returns [] for rows 2-5:
{code}
dbc:drill:zk=localhost:5181> SELECT * FROM `dfs`.`optdrill`.`./raw-files/donuts/moredonuts.json`
LIMIT 100;
+------------+------------+------------+------------+------------+------------+------------+------------+
|     id     |    type    |    name    |    ppu     |   sales    |  batters   |  topping 
 |  filling   |
+------------+------------+------------+------------+------------+------------+------------+------------+
| 0001       | donut      | Cake       | 0.55       | 35         | {"batter":[{"id":"1001","type":"Regular"},{"id":"1002","type":"Chocolate"},{"id":"100
|
| 0002       | donut      | Raised     | 0.69       | 145        | {"batter":[]} | []    
    | []         |
| 0003       | donut      | Old Fashioned | 0.55       | 300        | {"batter":[]} | [] 
       | []         |
| 0004       | donut      | Filled     | 0.69       | 14         | {"batter":[]} | []    
    | []         |
| 0005       | donut      | Apple Fritter | 1.0        | 700        | {"batter":[]} | [] 
       | []         |
+------------+------------+------------+------------+------------+------------+------------+------------+
5 rows selected (0.543 seconds)

{code}





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

Mime
View raw message