drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1151) JSON nested data returns empty for all rows except the first when using selections
Date Mon, 21 Jul 2014 03:35:38 GMT

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

Jacques Nadeau updated DRILL-1151:
----------------------------------

    Assignee: Jinfeng Ni
    Priority: Critical  (was: Major)

> 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
>            Assignee: Jinfeng Ni
>            Priority: Critical
>
> 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