Hi Kang-sen,
Can you reproduce it with Kylin’s sample cube? Best regards, Ni Chunen / George On 01/9/2020 00:54，Lu, Kang-Sen<[email protected]> wrote： I am running kylin 2.6. I just noticed that when I run the following sql statement again the hive and kylin, the result are different. Did anyone see the same problem? SELECT concat(concat(A_VL_HOURLY_V.THEDATE, A_VL_HOURLY_V.THEHOUR), '00') TIME_KEY, COUNT(*) vl_aggs_model___SUM_EVENT_COUNT FROM A_VL_HOURLY_V WHERE (A_VL_HOURLY_V.THEDATE = '20190511' ) AND (A_VL_HOURLY_V.THEHOUR = '01') GROUP BY A_VL_HOURLY_V.THEDATE, A_VL_HOURLY_V.THEHOUR ; Hive query returns: +---------------+----------------------------------+--+ | time_key | vl_aggs_model___sum_event_count | +---------------+----------------------------------+--+ | 201905110100 | 8968815 | +---------------+----------------------------------+--+ The kylin insight returned: 201905110100 | 8968800 The row count in hive is 15 more than in kylin. Thanks. Kang-sen Notice: This e-mail together with any attachments may contain information of Ribbon Communications Inc. that is confidential and/or proprietary for the sole use of the intended recipient. Any review, disclosure, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please notify the sender immediately and then delete all copies, including any attachments.
