yes we used HDP for this. So it might come from there.
Julien Tane Big Data Engineer [Tel.] +49 721 98993-393 [Fax] +49 721 98993-66 [E-Mail] j...@solute.de<mailto:j...@solute.de> solute GmbH Zeppelinstraße 15 76185 Karlsruhe Germany [Logo Solute] Marken der solute GmbH | brands of solute GmbH [Marken] Geschäftsführer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten Webseite | www.solute.de <http://www.solute.de/> Sitz | Registered Office: Karlsruhe Registergericht | Register Court: Amtsgericht Mannheim Registernummer | Register No.: HRB 110579 USt-ID | VAT ID: DE234663798 Informationen zum Datenschutz | Information about privacy policy https://www.solute.de/ger/datenschutz/grundsaetze-der-datenverarbeitung.php ________________________________ Von: Sungwoo Park <glap...@gmail.com> Gesendet: Dienstag, 28. April 2020 09:17:38 An: user@hive.apache.org Betreff: Re: Count bug in Hive 3.0.0.3.1 I have tested the script with Hive 2.3.6, Hive 3.1.2, and Hive 4.0.0-SNAPSHOT (all with minor modifications), and have not found any problem. So, I guess all the master branches are fine. If Hive 3.0.0.3.1 is the release included in HDP 3.0.0 or HDP 3.0.1, I remember that this Hive-LLAP/Tez release was not stable. So, it could be a problem specific to the release in HDP 3.0.0/3.0.1.<http://3.0.1.> --- Sungwoo On Tue, Apr 28, 2020 at 4:01 PM Peter Vary <pv...@cloudera.com<mailto:pv...@cloudera.com>> wrote: Hi Deepak, If I were you, I would test your repro case on the master branch. * If it is fixed, I think you should try to find the fix which solves the problem and cherry-pick the fix to branch-3 and branch-3.1 so the fix is there in the next release. * If the problem is still present on the master branch, then take a look at this page https://cwiki.apache.org/confluence/display/Hive/HowToContribute This describes the development method for Hive. Thanks, Peter On Apr 28, 2020, at 07:22, Deepak Krishna <hs-d...@solute.de<mailto:hs-d...@solute.de>> wrote: Hi team, We came across a bug related to count function. We are using hive 3.0.0.3.1 with Tez 0.9.0.3.1. PFA the queries to replicate the issue. Please register this as a bug and let us know if we can support in anyway to fix the issue. It would also be helpful to know if there are any other workarounds for this issue. Thanks and Regards, Deepak Krishna Deepak Krishna Big Data Engineer [Tel.] [Fax] +49 721 98993- [E-Mail] hs-d...@solute.de<mailto:hs-d...@solute.de> solute GmbH Zeppelinstraße 15 76185 Karlsruhe Germany [Logo Solute] Marken der solute GmbH | brands of solute GmbH [Marken] Geschäftsführer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten Webseite | www.solute.de <http://www.solute.de/> Sitz | Registered Office: Karlsruhe Registergericht | Register Court: Amtsgericht Mannheim Registernummer | Register No.: HRB 110579 USt-ID | VAT ID: DE234663798 Informationen zum Datenschutz | Information about privacy policy https://www.solute.de/ger/datenschutz/grundsaetze-der-datenverarbeitung.php <count_bug.sql>