Reply
Highlighted
Contributor
Posts: 25
Registered: ‎01-07-2016
Accepted Solution

Not possible to use IS NULL / IS NOT NULL operator on structs

It does not seem like the IS NULL / IS NOT NULL operator is supported for struct data types. We are using Impala 2.3.0/CDH5.5.1. This seem like a basic and vital operator to have. Especially when using wide tables. Anybody out there that has a patch or workaround or that actually succeeded to use this operator on structs?

 

I have reported IMPALA-3060 on the topic.

Cloudera Employee
Posts: 307
Registered: ‎10-16-2013

Re: Not possible to use IS NULL / IS NOT NULL operator on structs

Thanks for reporting this issue! I agree that it is an unfortunate limitation.

 

FWIW, this limitation is explained here in the docs here: http://www.cloudera.com/documentation/enterprise/latest/topics/impala_complex_types.html#complex_typ...

 

"Currently, Impala built-in functions and user-defined functions cannot accept complex types as parameters or produce them as function return values"

 

 

 

 

Contributor
Posts: 25
Registered: ‎01-07-2016

Re: Not possible to use IS NULL / IS NOT NULL operator on structs

Thank you for your prompt reply! I will hold my attempts using this operation.

Announcements