[jira] [Commented] (HIVE-15409) Add support for GROUPING function with grouping sets

2016-12-21 Thread Prasanth Jayachandran (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-15409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15766520#comment-15766520
 ] 

Prasanth Jayachandran commented on HIVE-15409:
--

This patch is causing PerfCliDriver failures in master. Not sure why it didn't 
show up in last run. Created HIVE-15484

> Add support for GROUPING function with grouping sets
> 
>
> Key: HIVE-15409
> URL: https://issues.apache.org/jira/browse/HIVE-15409
> Project: Hive
>  Issue Type: New Feature
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>  Labels: TODOC2.2
> Fix For: 2.2.0
>
> Attachments: HIVE-15409.01.patch, HIVE-15409.02.addendum.patch, 
> HIVE-15409.02.patch, HIVE-15409.patch
>
>
> The _grouping(col_expr)_ function indicates whether a given column is 
> aggregated in each row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-15409) Add support for GROUPING function with grouping sets

2016-12-16 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-15409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15753764#comment-15753764
 ] 

Lefty Leverenz commented on HIVE-15409:
---

Doc note:  This should be documented in the wiki.

* [Enhanced Aggregation, Cube, Grouping and Rollup | 
https://cwiki.apache.org/confluence/display/Hive/Enhanced+Aggregation%2C+Cube%2C+Grouping+and+Rollup]

> Add support for GROUPING function with grouping sets
> 
>
> Key: HIVE-15409
> URL: https://issues.apache.org/jira/browse/HIVE-15409
> Project: Hive
>  Issue Type: New Feature
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>  Labels: TODOC2.2
> Fix For: 2.2.0
>
> Attachments: HIVE-15409.01.patch, HIVE-15409.02.patch, 
> HIVE-15409.patch
>
>
> The _grouping(col_expr)_ function indicates whether a given column is 
> aggregated in each row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-15409) Add support for GROUPING function with grouping sets

2016-12-15 Thread Ashutosh Chauhan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-15409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15751966#comment-15751966
 ] 

Ashutosh Chauhan commented on HIVE-15409:
-

+1

> Add support for GROUPING function with grouping sets
> 
>
> Key: HIVE-15409
> URL: https://issues.apache.org/jira/browse/HIVE-15409
> Project: Hive
>  Issue Type: New Feature
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-15409.01.patch, HIVE-15409.02.patch, 
> HIVE-15409.patch
>
>
> The _grouping(col_expr)_ function indicates whether a given column is 
> aggregated in each row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-15409) Add support for GROUPING function with grouping sets

2016-12-15 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-15409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15751307#comment-15751307
 ] 

Hive QA commented on HIVE-15409:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12843382/HIVE-15409.02.patch

{color:green}SUCCESS:{color} +1 due to 7 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 10818 tests 
executed
*Failed tests:*
{noformat}
TestVectorizedColumnReaderBase - did not produce a TEST-*.xml file (likely 
timed out) (batchId=251)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample2] (batchId=5)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample4] (batchId=15)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample6] (batchId=61)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample7] (batchId=60)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample9] (batchId=38)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr2] 
(batchId=135)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[metadataonly1]
 (batchId=150)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[stats_based_fetch_decision]
 (batchId=151)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/2587/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/2587/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-2587/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 9 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12843382 - PreCommit-HIVE-Build

> Add support for GROUPING function with grouping sets
> 
>
> Key: HIVE-15409
> URL: https://issues.apache.org/jira/browse/HIVE-15409
> Project: Hive
>  Issue Type: New Feature
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-15409.01.patch, HIVE-15409.02.patch, 
> HIVE-15409.patch
>
>
> The _grouping(col_expr)_ function indicates whether a given column is 
> aggregated in each row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-15409) Add support for GROUPING function with grouping sets

2016-12-15 Thread Jesus Camacho Rodriguez (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-15409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15750883#comment-15750883
 ] 

Jesus Camacho Rodriguez commented on HIVE-15409:


[~ashutoshc], could you review it? Thanks

> Add support for GROUPING function with grouping sets
> 
>
> Key: HIVE-15409
> URL: https://issues.apache.org/jira/browse/HIVE-15409
> Project: Hive
>  Issue Type: New Feature
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-15409.01.patch, HIVE-15409.02.patch, 
> HIVE-15409.patch
>
>
> The _grouping(col_expr)_ function indicates whether a given column is 
> aggregated in each row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-15409) Add support for GROUPING function with grouping sets

2016-12-14 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-15409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15749182#comment-15749182
 ] 

Hive QA commented on HIVE-15409:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12843265/HIVE-15409.01.patch

{color:green}SUCCESS:{color} +1 due to 7 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 33 failed/errored test(s), 10816 tests 
executed
*Failed tests:*
{noformat}
TestVectorizedColumnReaderBase - did not produce a TEST-*.xml file (likely 
timed out) (batchId=251)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[annotate_stats_groupby2] 
(batchId=43)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[annotate_stats_groupby] 
(batchId=44)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_cube1] 
(batchId=4)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_cube_multi_gby] 
(batchId=11)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets2] 
(batchId=23)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets3] 
(batchId=1)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets4] 
(batchId=29)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets5] 
(batchId=44)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets6] 
(batchId=64)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets_limit]
 (batchId=16)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_window] 
(batchId=29)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_rollup1] 
(batchId=30)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[infer_bucket_sort_grouping_operators]
 (batchId=50)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_pushdown2] 
(batchId=15)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample2] (batchId=5)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample4] (batchId=15)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample6] (batchId=61)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample7] (batchId=60)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample9] (batchId=38)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[show_functions] 
(batchId=66)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_grouping_sets] 
(batchId=75)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr2] 
(batchId=135)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[metadataonly1]
 (batchId=150)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[stats_based_fetch_decision]
 (batchId=151)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_grouping_sets]
 (batchId=153)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] 
(batchId=93)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[multi_count_distinct]
 (batchId=92)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query18] 
(batchId=222)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query80] 
(batchId=222)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_cube1] 
(batchId=95)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_rollup1] 
(batchId=108)
org.apache.hive.hcatalog.api.TestHCatClientNotification.createTable 
(batchId=220)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/2576/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/2576/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-2576/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 33 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12843265 - PreCommit-HIVE-Build

> Add support for GROUPING function with grouping sets
> 
>
> Key: HIVE-15409
> URL: https://issues.apache.org/jira/browse/HIVE-15409
> Project: Hive
>  Issue Type: New Feature
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-15409.01.patch, HIVE-15409.patch
>
>
> The _grouping(col_expr)_ function indicates whether a given column is 
> aggregated in each row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)