You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2016/11/23 16:15:58 UTC

[jira] [Created] (HIVE-15274) wrong results on the column __time

slim bouguerra created HIVE-15274:
-------------------------------------

             Summary: wrong results on the column __time
                 Key: HIVE-15274
                 URL: https://issues.apache.org/jira/browse/HIVE-15274
             Project: Hive
          Issue Type: Bug
          Components: Druid integration
            Reporter: slim bouguerra
            Assignee: Jesus Camacho Rodriguez
            Priority: Minor


issuing select * from table will return wrong time column.
expected results
 ─────────────────────────────────────────┬────────────┬─────────┐
│ __time                                  │ dimension1 │ metric1 │
├─────────────────────────────────────────┼────────────┼─────────┤
│ Wed Dec 31 2014 16:00:00 GMT-0800 (PST) │ value1     │ 1       │
│ Wed Dec 31 2014 16:00:00 GMT-0800 (PST) │ value1.1   │ 1       │
│ Sun May 31 2015 19:00:00 GMT-0700 (PDT) │ value2     │ 20.5    │
│ Sun May 31 2015 19:00:00 GMT-0700 (PDT) │ value2.1   │ 32      │
└─────────────────────────────────────────┴────────────┴─────────┘

returned result

2014-12-31 19:00:00	value1	1.0
2014-12-31 19:00:00	value1.1	1.0
2014-12-31 19:00:00	value2	20.5
2014-12-31 19:00:00	value2.1	32.0





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