You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Software Dev <st...@gmail.com> on 2014/02/20 20:04:54 UTC

Sort by Avro field

Is it possible to sort by a field within an Avro struct? Am I doing
something wrong?


hive> describe logs;
OK
requestheader struct<timestamp:bigint,servername:string> 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 input 'timestamp' expecting
Identifier near '.' in expression specification