hive - Hadoop best way to pivot -


we have avro file has id, attributename , attributevalue... narrow, deep.

  • 475mm unique id's
  • 20 unique attributename's (avro file partitioned on attributename)

what best technologies , syntax pivot huge file this?**

here example:

enter image description here


Comments