Prevent Inserting NULL while using Hive Regex Serde

Question

RegexSerDe uses regular expression (regex) to deserialize data. It doesn't support data serialization. It can deserialize the data using regex and extracts groups as columns. In deserialization stage, if a row does not match the regex, then all columns in the row will be NULL. If a row matches the regex but has less than expected groups, the missing groups will be NULL. If a row matches the regex but has more than expected groups, the additional groups are just ignored.

How can I prevent insertion of NULL when there is a mismatch in the row and raise an exception?

Answer 1

select  *

from    mytable

where   assert_true
        (
            mycol1 is not null
        or  mycol2 is not null
        or  mycol3 is not null
        ...
        )