02-23-2016 05:16 AM
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.
02-23-2016 08:28 AM
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"
02-21-2019 02:38 PM
Is there a solution to this yet ?
I am running into the same issue. I am using a IS NOT NULL clause in the Where condition and it is being ignored and rows with null values in that column are being retured by the query.
02-22-2019 12:27 AM
name complex1 complex2 complex3 complex1 content NULL NULL complex3 NULL NULL content
SELECT complex1.* FROM myTable WHERE name = 'complex1'