[HIVE-14471] Read results for Druid GroupBy query

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: Druid integration
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 08/Aug/16 11:53
• Updated: 27/Feb/24 22:24
• Resolved: 08/Sep/16 09:13

Description

Format of results for Druid GroupBy queries is as follows:

[ 
  {
    "version" : "v1",
    "timestamp" : "2012-01-01T00:00:00.000Z",
    "event" : {
      "country" : "India",
      "device" : "phone",
      "total_usage" : 88,
      "data_transfer" : 29.91233453,
      "avg_usage" : 60.32
    }
  }, 
  {
    "version" : "v1",
    "timestamp" : "2012-01-01T00:00:12.000Z",
    "event" : {
      "country" : "Spain",
      "device" : "pc",
      "total_usage" : 16,
      "data_transfer" : 172.93494959,
      "avg_usage" : 6.333333
    }
  }
]

Out of this query results, we will generate Hive records with the following format:

[ new TimestampWritable(new Timestamp(1325376000000L)), new Text("India"), new Text("phone"), new LongWritable(88), new FloatWritable(29.91233453F), new FloatWritable(60.32F) ]
[ new TimestampWritable(new Timestamp(1325376012000L)), new Text("Spain"), new Text("pc"), new LongWritable(16), new FloatWritable(172.93494959F), new FloatWritable(6.333333F) ]

Issue Links

• is part of: HIVE-14217 Druid integration