Use size instead of count. Count is for counting rows, while size is for
determining the size of a collection.
For the second question, I think you'll need to call explode on the array,
turning it into records first. Google for hive's "lateral view" to see the
correct syntax for exploding and al
I'm building up a set of classes (objectinspectors and serdes) to allow
hive queries over some data files I have. While I'm making it work, I don't
fully grok all the concepts involved.
Right now I've got 2 questions.
I'm able to make queries like this (this is the first syntax I tried to
query in
