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)