drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3762) NPE : Query nested JSON data
Date Thu, 08 Oct 2015 07:09:26 GMT

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

Khurram Faraaz updated DRILL-3762:
----------------------------------
    Assignee: Jason Altekruse

> NPE : Query nested JSON data
> ----------------------------
>
>                 Key: DRILL-3762
>                 URL: https://issues.apache.org/jira/browse/DRILL-3762
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>    Affects Versions: 1.2.0
>         Environment: 4 node cluster CentOS
>            Reporter: Khurram Faraaz
>            Assignee: Jason Altekruse
>             Fix For: 1.3.0
>
>
> Drill master commit ID : 0686bc23
> I am seeing an NPE when I try to query nested data. Interestingly there are no Exceptions
written to either drillbit.log or drillbit.out, I had to set verbose mode to ON, on sqlline
to see the stack trace.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select * from `repro_data.json`;
> +---------------------------------------------------------------------+
> |                                meta                                 |
> +---------------------------------------------------------------------+
> | {"view":{"columns":[{"cachedCounts":{"smallest":"hello world"}}]}}  |
> +---------------------------------------------------------------------+
> 1 row selected (2.401 seconds)
> 0: jdbc:drill:schema=dfs.tmp> select t.meta.view.columns from `repro_data.json` t;
> +------------------------------------------------+
> |                     EXPR$0                     |
> +------------------------------------------------+
> | [{"cachedCounts":{"smallest":"hello world"}}]  |
> +------------------------------------------------+
> 1 row selected (0.347 seconds)
> 0: jdbc:drill:schema=dfs.tmp> select t.meta.view.columns[1] from `repro_data.json`
t;
> Error: Unexpected RuntimeException: java.lang.NullPointerException (state=,code=0)
> 0: jdbc:drill:schema=dfs.tmp> !verbose true
> verbose: on
> 0: jdbc:drill:schema=dfs.tmp> select t.meta.view.columns[1] from `repro_data.json`
t;
> Error: Unexpected RuntimeException: java.lang.NullPointerException (state=,code=0)
> java.sql.SQLException: Unexpected RuntimeException: java.lang.NullPointerException
> 	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:261)
> 	at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:290)
> 	at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1359)
> 	at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:74)
> 	at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
> 	at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351)
> 	at net.hydromatic.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:338)
> 	at net.hydromatic.avatica.AvaticaStatement.execute(AvaticaStatement.java:69)
> 	at org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:86)
> 	at sqlline.Commands.execute(Commands.java:841)
> 	at sqlline.Commands.sql(Commands.java:751)
> 	at sqlline.SqlLine.dispatch(SqlLine.java:738)
> 	at sqlline.SqlLine.begin(SqlLine.java:612)
> 	at sqlline.SqlLine.start(SqlLine.java:366)
> 	at sqlline.SqlLine.main(SqlLine.java:259)
> Caused by: java.lang.NullPointerException
> 	at org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:99)
> 	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:223)
> 	... 14 more
> {code}
> Data used in the test, repo_data.json
> {code}
> {
> "meta":{
>     "view":{
>         "columns":[{"cachedCounts":{ "smallest":"hello world"}}]
>     }
> }
> }
> {code}



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

Mime
View raw message