[jira] [Created] (HIVE-14471) Read results for Druid GroupBy query

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-14471:
----------------------------------------------

             Summary: Read results for Druid GroupBy query
                 Key: HIVE-14471
                 URL: https://issues.apache.org/jira/browse/HIVE-14471
             Project: Hive
          Issue Type: Sub-task
          Components: Druid integration
    Affects Versions: 2.2.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


Format of results for Druid GroupBy queries is as follows:

{code}
[ 
  {
    "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
    }
  }
]
{code}

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

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)