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. --- Sungwoo On Tue, Apr 28, 2020 at 4:01 PM Peter Vary <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> 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 > > [image: Tel.] > [image: Fax] +49 721 98993- > [image: E-Mail] hs-d...@solute.de > > > solute GmbH > Zeppelinstraße 15 > 76185 Karlsruhe > Germany > > [image: Logo Solute] > > Marken der solute GmbH | brands of solute GmbH > [image: 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> > > >