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/08/16 07:26:20 UTC
[jira] [Updated] (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 updated HIVE-14471:
-------------------------------------------
Description:
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}
was:
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}
> 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 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)