[jira] [Created] (DRILL-3762) NPE : Query nested JSON data

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

Khurram Faraaz created DRILL-3762:
-------------------------------------

             Summary: 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: Daniel Barclay (Drill)
             Fix For: 1.2.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)