[jira] [Commented] (DRILL-1608) Unable to use flatten without limit

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-1608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14199519#comment-14199519 ] 

Rahul Challapalli commented on DRILL-1608:
------------------------------------------

Looks like the no of records in the json document matters. This error did not happen when my json file has odd no of records

Neeraja, 
Can you check if you have an even no of records? If so add one more record and run the query without the limit.

- Rahul

> Unable to use flatten without limit 
> ------------------------------------
>
>                 Key: DRILL-1608
>                 URL: https://issues.apache.org/jira/browse/DRILL-1608
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Neeraja
>            Assignee: Jason Altekruse
>             Fix For: 0.7.0
>
>
> Unable to use flatten without limit.
> 0: jdbc:drill:zk=local> select flatten(children) as f from dfs.`/Users/nrentachintala/Downloads/drillreleases/apache-drill-0.7.0-incubating-SNAPSHOT/sample-data/test.json`;
> +------------+------------+
> |     f      |     f      |
> +------------+------------+
> java.lang.RuntimeException: java.sql.SQLException: invalid column ordinal: 2
> 	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> 	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> 	at sqlline.SqlLine.print(SqlLine.java:1809)
> 	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> 	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> 	at sqlline.SqlLine.dispatch(SqlLine.java:889)
> 	at sqlline.SqlLine.begin(SqlLine.java:763)
> 	at sqlline.SqlLine.start(SqlLine.java:498)
> 	at sqlline.SqlLine.main(SqlLine.java:460)
> Applying explicit limit works fine as well as including it as part of a subquery works fine.
> 0: jdbc:drill:zk=local> select flatten(children) as f from dfs.`/Users/nrentachintala/Downloads/drillreleases/apache-drill-0.7.0-incubating-SNAPSHOT/sample-data/test.json` limit 6;
> +------------+
> |     f      |
> +------------+
> | {"name":"Jane","gender":"Female","age":"6"} |
> | {"name":"John","gender":"Male","age":"15"} |
> | {"name":"Earl","gender":"Male","age":"10"} |
> | {"name":"Sam","gender":"Male","age":"6"} |
> | {"name":"Kit","gender":"Male","age":"8"} |
> +------------+
> 0: jdbc:drill:zk=local> select c.f.name, c.f.gender,c.f.age from 
> . . . . . . . . . . . > (select flatten(children) as f from dfs.`/Users/nrentachintala/Downloads/drillreleases/apache-drill-0.7.0-incubating-SNAPSHOT/sample-data/test.json`) c;
> +------------+------------+------------+
> |   EXPR$0   |   EXPR$1   |   EXPR$2   |
> +------------+------------+------------+
> | Jane       | Female     | 6          |
> | John       | Male       | 15         |
> | Earl       | Male       | 10         |
> | Sam        | Male       | 6          |
> | Kit        | Male       | 8          |
> +------------+------------+------------+



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