You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2016/09/08 09:13:20 UTC
[jira] [Resolved] (HIVE-14471) Read results for Druid GroupBy query
[ https://issues.apache.org/jira/browse/HIVE-14471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez resolved HIVE-14471.
--------------------------------------------
Resolution: Fixed
Fix Version/s: 2.2.0
Pushed in HIVE-14217.
> 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
> Fix For: 2.2.0
>
>
> 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 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) ]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)