[HIVE-19011] Druid Storage Handler returns conflicting results for Qtest druidmini_dynamic_partition.q

• Type: Sub-task
• Status: Resolved
• Priority: Blocker
• Resolution: Invalid
• Component/s: Druid integration
• Assignee: Slim Bouguerra
• Reporter: Slim Bouguerra
• Created: 21/Mar/18 19:36
• Updated: 07/May/18 19:37
• Resolved: 07/May/18 18:07

Description

This git diff shows the conflicting results

diff --git a/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out b/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out
index 714778ebfc..cea9b7535c 100644
--- a/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out
+++ b/ql/src/test/results/clientpositive/druid/druidmini_dynamic_partition.q.out
@@ -243,7 +243,7 @@ POSTHOOK: query: SELECT  sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@druid_partitioned_table
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-1408069801800  4139540644      10992545287     165393120
[phone]  3272553822      10992545287     -648527473
 PREHOOK: query: SELECT  sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM druid_partitioned_table_0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@druid_partitioned_table_0
@@ -429,7 +429,7 @@ POSTHOOK: query: SELECT sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM d
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@druid_partitioned_table
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-2857395071862  4139540644      -1661313883124  885815256
[phone]  3728054572      -1661313883124  71894663
 PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE druid_partitioned_table
   SELECT cast (`ctimestamp1` as timestamp with local time zone) as `__time`,
     cstring1,
@@ -566,7 +566,7 @@ POSTHOOK: query: SELECT sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM d
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@druid_partitioned_table
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-1408069801800  7115092987      10992545287     1232243564
[phone]  4584782821      10992545287     -1808876374
 PREHOOK: query: SELECT  sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM druid_partitioned_table_0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@druid_partitioned_table_0
@@ -659,7 +659,7 @@ POSTHOOK: query: SELECT sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM d
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@druid_partitioned_table
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-1408069801800  7115092987      10992545287     1232243564
[phone]  4584782821      10992545287     -1808876374
 PREHOOK: query: EXPLAIN SELECT  sum(cint), max(cbigint),  sum(cbigint), max(cint)  FROM druid_max_size_partition
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT  sum(cint), max(cbigint),  sum(cbigint), max(cint)  FROM druid_max_size_partition
@@ -758,7 +758,7 @@ POSTHOOK: query: SELECT sum(cint), max(cbigint),  sum(cbigint), max(cint) FROM d
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@druid_partitioned_table
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-1408069801800  7115092987      10992545287     1232243564
[phone]  4584782821      10992545287     -1808876374
 PREHOOK: query: DROP TABLE druid_partitioned_table_0
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@druid_partitioned_table_0