Re: [VOTE] Mark Hive 2.x EOL

[Aman Sinha]

+1 (non-binding)

On Fri, May 10, 2024 at 7:57 AM Mahesh Raju Somalaraju
 wrote:

> +1(non-binding)
>
> Thanks
> Mahesh Raju S
>
> On Fri, 10 May 2024, 06:15 Ayush Saxena,  wrote:
>
>> Hi All,
>> Following the discussion at [1]. Starting the official vote thread to
>> mark Hive 2.x release line as EOL.
>>
>> Marking a release lines as EOL means there won't be any further
>> release made for that release line
>>
>> I will start with my +1
>>
>> -Ayush
>>
>>
>> [1] https://lists.apache.org/thread/91wk3oy1qo953md7941ojg2q97ofsl2d
>>
>

Re: Re: [ANNOUNCE] New Committer: Simhadri Govindappa

[Aman Sinha]

Congrats Simhadri !

On Thu, Apr 18, 2024 at 12:25 PM Naveen Gangam 
wrote:

> Congrats Simhadri. Looking forward to many more contributions in the
> future.
>
> On Thu, Apr 18, 2024 at 12:25 PM Sai Hemanth Gantasala
>  wrote:
>
>> Congratulations Simhadri  well deserved
>>
>> On Thu, Apr 18, 2024 at 8:41 AM Pau Tallada  wrote:
>>
>>> Congratulations
>>>
>>> Missatge de Alessandro Solimando  del
>>> dia dj., 18 d’abr. 2024 a les 17:40:
>>>
 Great news, Simhadri, very well deserved!

 On Thu, 18 Apr 2024 at 15:07, Simhadri G  wrote:

> Thanks everyone!
> I really appreciate it, it means a lot to me :)
> The Apache Hive project and its community have truly inspired me . I'm
> grateful for the chance to contribute to such a remarkable project.
>
> Thanks!
> Simhadri Govindappa
>
> On Thu, Apr 18, 2024 at 6:18 PM Sankar Hariappan
>  wrote:
>
>> Congrats Simhadri!
>>
>>
>>
>> -Sankar
>>
>>
>>
>> *From:* Butao Zhang 
>> *Sent:* Thursday, April 18, 2024 5:39 PM
>> *To:* u...@hive.apache.org; dev 
>> *Subject:* [EXTERNAL] Re: [ANNOUNCE] New Committer: Simhadri
>> Govindappa
>>
>>
>>
>> You don't often get email from butaozha...@163.com. Learn why this
>> is important 
>>
>> Congratulations Simhadri !!!
>>
>>
>>
>> Thanks.
>>
>>
>> --
>>
>> *发件人**:* user-return-28075-butaozhang1=163@hive.apache.org <
>> user-return-28075-butaozhang1=163@hive.apache.org> 代表 Ayush
>> Saxena 
>> *发送时间**:* 星期四, 四月 18, 2024 7:50 下午
>> *收件人**:* dev ; u...@hive.apache.org <
>> u...@hive.apache.org>
>> *主题**:* [ANNOUNCE] New Committer: Simhadri Govindappa
>>
>>
>>
>> Hi All,
>>
>> Apache Hive's Project Management Committee (PMC) has invited Simhadri
>> Govindappa to become a committer, and we are pleased to announce that he
>> has accepted.
>>
>>
>>
>> Please join me in congratulating him, Congratulations Simhadri,
>> Welcome aboard!!!
>>
>>
>>
>> -Ayush Saxena
>>
>> (On behalf of Apache Hive PMC)
>>
>
>>>
>>> --
>>> --
>>> Pau Tallada Crespí
>>> Departament de Serveis
>>> Port d'Informació Científica (PIC)
>>> Tel: +34 93 170 2729
>>> --
>>>
>>>

[jira] [Created] (HIVE-26534) GROUPING() function errors out due to case-sensitivity of function name

[Aman Sinha (Jira)]

Aman Sinha created HIVE-26534:
-

 Summary: GROUPING() function errors out due to case-sensitivity of 
function name
 Key: HIVE-26534
 URL: https://issues.apache.org/jira/browse/HIVE-26534
 Project: Hive
  Issue Type: Bug
  Components: Hive, Logical Optimizer
Reporter: Aman Sinha


The following errors out:
{noformat}
explain cbo select GROUPING(l_suppkey) from lineitem group by l_suppkey with 
rollup;
Error: Error while compiling statement: FAILED: SemanticException [Error 
10015]: Line 1:19 Arguments length mismatch 'l_suppkey': grouping() requires at 
least 2 argument, got 1 (state=21000,code=10015)
{noformat}

Lowercase grouping() succeeds:
{noformat}
explain cbo select grouping(l_suppkey) from lineitem group by l_suppkey with 
rollup;

++
|  Explain   |
++
| CBO PLAN:  |
| HiveProject(_o__c0=[grouping($1, 0:BIGINT)])   |
|   HiveAggregate(group=[{0}], groups=[[{0}, {}]], 
GROUPING__ID=[GROUPING__ID()]) |
| HiveProject(l_suppkey=[$2])|
|   HiveTableScan(table=[[tpch, lineitem]], table:alias=[lineitem]) |
||
++
{noformat}

This is likely due to the SemanticAnalyzer doing a case-sensitive compare here:
{noformat}
 @Override
  public Object post(Object t) {
 
  if (func.getText().equals("grouping") && func.getChildCount() == 0) {
{noformat}

We should fix this to make it case-insensitive comparison.  There might be 
other places to examine too for grouping function.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (HIVE-24465) RuntimeException Invalid Stats number of null > no of tuples when fetch column stats is enabled

[Aman Sinha (Jira)]

Aman Sinha created HIVE-24465:
-

 Summary: RuntimeException Invalid Stats number of null > no of 
tuples when fetch column stats is enabled
 Key: HIVE-24465
 URL: https://issues.apache.org/jira/browse/HIVE-24465
 Project: Hive
  Issue Type: Bug
  Components: Query Planning
Reporter: Aman Sinha
Assignee: Aman Sinha



Seen in a downstream build. To reproduce, set hive.stats.fetch.column.stats to 
true and execute TPC-DS q8.  The FilterSelectivityEstimator.java hits the 
following error:
{noformat}
RuntimeException: Invalid Stats number of null > no of tuples
{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)