[jira] [Created] (DRILL-310) Queries with multi level map type causes NPE

["Mehant Baid (JIRA)" <ji...@apache.org>]

Mehant Baid created DRILL-310:
---------------------------------

             Summary: Queries with multi level map type causes NPE
                 Key: DRILL-310
                 URL: https://issues.apache.org/jira/browse/DRILL-310
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Mehant Baid
            Assignee: Mehant Baid


This issue is related to JIRA#: 307, which is the task to get rid of _MAP from drill sql. 

Easy way to reproduce this issue is to use the "donuts" schema and try and select a multi level map type as follows

SELECT BATTERS.BATTER.ID from "/tmp/donuts.json";

Following is the stack trace

org.eigenbase.util.EigenbaseContextException: From line 1, column 31 to line 1, column 48
	at org.eigenbase.resource.EigenbaseResource$_Def12.ex(EigenbaseResource.java:1026)
	at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:739)
	at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:726)
	at org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3849)
	at org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:78)
	at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:90)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:802)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:790)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2795)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3032)
	at org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:69)
	at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:90)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:802)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:790)
	at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:152)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:753)
	at org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:444)
	at org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:445)
	at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:162)
	at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:131)
	at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:256)
	at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:196)
	at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:169)
	at net.hydromatic.optiq.jdbc.OptiqStatement.parseQuery(OptiqStatement.java:402)
	at net.hydromatic.optiq.jdbc.OptiqStatement.execute(OptiqStatement.java:192)
	at sqlline.SqlLine$Commands.execute(SqlLine.java:3825)
	at sqlline.SqlLine$Commands.sql(SqlLine.java:3738)
	at sqlline.SqlLine.dispatch(SqlLine.java:882)
	at sqlline.SqlLine.begin(SqlLine.java:717)
	at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
	at sqlline.SqlLine.main(SqlLine.java:443)
 



--
This message was sent by Atlassian JIRA
(v6.1#6144)