You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2018/03/21 19:39:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-19011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

slim bouguerra updated HIVE-19011:
----------------------------------
    Component/s: Druid integration

> Druid Storage Handler returns conflicting results for Qtest druidmini_dynamic_partition.q
> -----------------------------------------------------------------------------------------
>
>                 Key: HIVE-19011
>                 URL: https://issues.apache.org/jira/browse/HIVE-19011
>             Project: Hive
>          Issue Type: Bug
>          Components: Druid integration
>            Reporter: slim bouguerra
>            Priority: Major
>
> This git diff shows the conflicting results
> {code}
> 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
> +1408069801800  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
> +2857395071862  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
> +1408069801800  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
> +1408069801800  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
> +1408069801800  4584782821      10992545287     -1808876374
>  PREHOOK: query: DROP TABLE druid_partitioned_table_0
>  PREHOOK: type: DROPTABLE
>  PREHOOK: Input: default@druid_partitioned_table_0
> {code}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)