drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tugdual Grall (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3444) Implement Is Not Null/Is Null on List of object - [isnotnull(MAP-REPEATED)] error
Date Wed, 01 Jul 2015 09:44:04 GMT
Tugdual Grall created DRILL-3444:

             Summary: Implement Is Not Null/Is Null on List of object -  [isnotnull(MAP-REPEATED)]
                 Key: DRILL-3444
                 URL: https://issues.apache.org/jira/browse/DRILL-3444
             Project: Apache Drill
          Issue Type: Improvement
          Components: Execution - Data Types, Functions - Drill
         Environment: Drill 1.0
            Reporter: Tugdual Grall
            Assignee: Daniel Barclay (Drill)
            Priority: Critical

It is not possble to use the IS NULL / IS NOT NULL operator on an attribuite that contains
a list of "object". (it is working with a list of scalar types)

select *
from dfs.`/working/json_array/*.json` p
where p.tags IS NOT NULL

  "name" : "PPRODUCT_002",
  "price" : 200.00,
  "tags" : [ { "type" : "sports" } , { "type" : "ocean" }]

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException:
Failure while trying to materialize incoming schema. Errors: Error in expression at index
-1. Error: Missing function implementation: [isnotnull(MAP-REPEATED)]. Full expression: --UNKNOWN
EXPRESSION--.. Fragment 0:0 [Error Id: 384e6b86-ce17-4eb9-b5eb-27870a341c90 on]

By using a sub element it is working, for example:

select *
from dfs.`/Users/tgrall/working/json_array/*.json` p
where p.tags.type IS NULL

This message was sent by Atlassian JIRA

View raw message