Is it possible to sort by a field within an Avro struct? Am I doing
something wrong?
hive> describe logs;
OK
requestheader struct from deserializer
year int
month int
day int
hive> select * from logs where year = 2014 order by requestheader.timestamp;
FAILED: ParseException line 1:68 mismatched
When I run a query in the hive shell for an Avro field it displays it as
json. How can I accomplish then when saving to a file?
Any suggestions on pre-splitting on a uid generated from NGinx? The
look like the following as a base64 encoded cookie... (CgAQS1NhGAE
DATNBBikAg==, CgAQNVNhGZsePgTdBB/KAg==, ...)
http://wiki.nginx.org/HttpUseridModule
http://www.lexa.ru/programs/mod-uid-eng.html
We have a table with user entered queries, their IP. How could we
write a query that will count and order queries by their count having
a unique IP count > X. For example if we had the same IP enter the
same query Y times we wouldnlt want to include this in the final
result unless there have been X
We have a table with user entered queries, their IP. How could we
write a query that will count and order queries by their count having
a unique IP count > X. For example if we had the same IP enter the
same query Y times we wouldnlt want to include this in the final
result unless there have been X
We have a table with user entered queries, their IP. How could we
write a query that will count and order queries by their count having
a unique IP count > X. For example if we had the same IP enter the
same query Y times we wouldnlt want to include this in the final
result unless there have been X
