If using the map type in a Hive table, how can I test for a null entry (key exists, but value is null)? With table: test1 (id string, m map<string, string>) I have a few entries that look like this: id1 {"b":"B","c":null} id2 {"b":"B"} If I run the query: select * from test1 where m["c"] is null; I will get both rows back since expression evaluates true each time. How can I test between key exists
![Hive: How to test and find for null map entries?](https://cdn-ak-scissors.b.st-hatena.com/image/square/98d6f053a97a87156775f60757c60865d0f2c47d/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fstackoverflow%2FImg%2Fapple-touch-icon%402.png%3Fv%3D73d79a89bded)