hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Sprague <sprag...@gmail.com>
Subject group by + two nulls in a row = bug?
Date Wed, 28 Jun 2017 04:55:12 GMT
i'm running hive version 2.1.0 and found this interesting. i've broken it
down into a trivial test case below.

i run this:

         select a.date_key,
                a.property_id,
                cast(NULL as bigint) as malone_id,
                cast(NULL as bigint) as zpid,
                sum(coalesce(a.sum_365,0)) as sum_365
         from
                (select 20170626 as date_key, 123 as property_id, 10 as
sum_365 ) a

         group by
                1
                ,2
                ,3
                ,4

and i get:

+----------+-------------+-----------+--------+---------+
| date_key | property_id | malone_id | zpid   | sum_365 |
+----------+-------------+-----------+--------+---------+
| 20170626 | 123         | [NULL]    | [NULL] | *[NULL]*  |
+----------+-------------+-----------+--------+---------+

why do you suppose sum_365 is null?


then i run this:

         select a.date_key,
                a.property_id,
                cast(NULL as bigint) as malone_id,
                sum(coalesce(a.sum_365,0)) as sum_365
         from
                (select 20170626 as date_key, 123 as property_id, 10 as
sum_365 ) a

         group by
                1
                ,2
                ,3

and i get:


+----------+-------------+-----------+---------+
| date_key | property_id | malone_id | sum_365 |
+----------+-------------+-----------+---------+
| 20170626 | 123         | [NULL]    | *10 *     |
+----------+-------------+-----------+---------+


what do you think? is it me? or is it hive?    (looks to me grouping by two
NULL's in a row causes a problem.)

Mime
View raw message