AW: Count bug in Hive 3.0.0.3.1

2020-04-28 Thread Julien Tane 
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 
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 
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 
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

Re: Count bug in Hive 3.0.0.3.1

2020-04-28 Thread Tim Havens 
Unsubscribe

On Tue, Apr 28, 2020, 1:23 AM Deepak Krishna  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
> 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
>
>
>
>

Re: Count bug in Hive 3.0.0.3.1

2020-04-28 Thread Sungwoo Park 
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  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  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  
> 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
>
>
> 
>
>
>

Re: Count bug in Hive 3.0.0.3.1

2020-04-28 Thread Peter Vary 
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  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
>  
>   
>   +49 721 98993-
>   hs-d...@solute.de 
>  
> solute GmbH
> Zeppelinstraße 15
> 76185 Karlsruhe
> Germany
>  
> 
>  
> Marken der solute GmbH | brands of solute GmbH
> 
> Geschäftsführer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten
> Webseite | 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 in Hive 3.0.0.3.1

2020-04-27 Thread Deepak Krishna 
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


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 
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
Description: count_bug.sql