"keys": [ "2324", "abc"]
This is one of the key of hive JSON. I want to find the length of the "keys" field. i am reading the JSON using get_json_object() method.
This is the way I am doing but getting error:
select count(*) from table_name where json_array_length(get_json_object(node,'$.keys'))=2;
since you are looking into an json array, you could simply do a split and then apply size to get the desired result.
select size(split(get_json_object(data,'$.keys'),',')) from <table name>;