Tugdual Grall created DRILL-3444:
------------------------------------
Summary: Implement Is Not Null/Is Null on List of object -
[isnotnull(MAP-REPEATED)] error
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)
Query:
{code}
select *
from dfs.`/working/json_array/*.json` p
where p.tags IS NOT NULL
{code}
Document:
{code}
{
"name" : "PPRODUCT_002",
"price" : 200.00,
"tags" : [ { "type" : "sports" } , { "type" : "ocean" }]
}
{code}
Error:
{code}
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 192.168.99.13:31010]
{code}
Workaround:
By using a sub element it is working, for example:
{code}
select *
from dfs.`/Users/tgrall/working/json_array/*.json` p
where p.tags.type IS NULL
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
