[jira] [Commented] (HIVE-20615) CachedStore: Background refresh thread bug fixes

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-20615:


| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
39s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  0m 
11s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
11s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
27s{color} | {color:blue} storage-api in master has 48 extant Findbugs 
warnings. {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
10s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  0m 
11s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  0m 
10s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  0m 
10s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
13s{color} | {color:red} storage-api: The patch generated 63 new + 44 unchanged 
- 1 fixed = 107 total (was 45) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  0m 
28s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
10s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
13s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 11m 31s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16997/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.1 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16997/yetus/diff-checkstyle-storage-api.txt
 |
| modules | C: storage-api U: storage-api |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16997/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> CachedStore: Background refresh thread bug fixes
> 
>
> Key: HIVE-20615
> URL: https://issues.apache.org/jira/browse/HIVE-20615
> Project: Hive
>  Issue Type: Sub-task
>  Components: Metastore
>Affects Versions: 3.1.0
>Reporter: Vaibhav Gumashta
>Assignee: Daniel Dai
>Priority: Major
> Attachments: HIVE-20615.1.patch, HIVE-20615.1.patch, 
> HIVE-20615.1.patch, HIVE-20615.1.patch, HIVE-20615.1.patch, 
> HIVE-20615.1.patch, HIVE-21625.2.patch
>
>
> Regression introduced in HIVE-18264. Fixes background thread starting and 
> refreshing of the table cache.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21621) Update Kafka Clients to recent release 2.2.0

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21621:




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

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:green}SUCCESS:{color} +1 due to 15957 tests passed

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12966431 - PreCommit-HIVE-Build

> Update Kafka Clients to recent release 2.2.0
> 
>
> Key: HIVE-21621
> URL: https://issues.apache.org/jira/browse/HIVE-21621
> Project: Hive
>  Issue Type: Task
>  Components: kafka integration
>Reporter: slim bouguerra
>Assignee: slim bouguerra
>Priority: Trivial
>  Labels: pull-request-available
> Attachments: HIVE-21621.2.patch, HIVE-21621.3.patch, 
> HIVE-21621.3.patch, HIVE-21621.4.patch, HIVE-21621.5.patch, HIVE-21621.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> all in the title update Kafka Storage Handler to the most recent clients 
> library.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21621) Update Kafka Clients to recent release 2.2.0

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21621:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  1m 
53s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
18s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
3s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
32s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
20s{color} | {color:blue} itests/qtest-druid in master has 7 extant Findbugs 
warnings. {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
40s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  0m 
25s{color} | {color:blue} Maven dependency ordering for patch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
40s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
4s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
4s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
33s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} xml {color} | {color:green}  0m  
2s{color} | {color:green} The patch has no ill-formed XML file. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  1m  
1s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
41s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
15s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 18m 36s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  xml  compile  findbugs  
checkstyle  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16996/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: kafka-handler itests/qtest itests/qtest-druid U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16996/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Update Kafka Clients to recent release 2.2.0
> 
>
> Key: HIVE-21621
> URL: https://issues.apache.org/jira/browse/HIVE-21621
> Project: Hive
>  Issue Type: Task
>  Components: kafka integration
>Reporter: slim bouguerra
>Assignee: slim bouguerra
>Priority: Trivial
>  Labels: pull-request-available
> Attachments: HIVE-21621.2.patch, HIVE-21621.3.patch, 
> HIVE-21621.3.patch, HIVE-21621.4.patch, HIVE-21621.5.patch, HIVE-21621.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> all in the title update Kafka Storage Handler to the most recent clients 
> library.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21633:




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

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:green}SUCCESS:{color} +1 due to 15957 tests passed

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12966426 - PreCommit-HIVE-Build

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch, HIVE-21633.03.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-20615) CachedStore: Background refresh thread bug fixes

2019-04-18 Thread Daniel Dai (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-20615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Daniel Dai updated HIVE-20615:
--
Attachment: HIVE-21625.2.patch

> CachedStore: Background refresh thread bug fixes
> 
>
> Key: HIVE-20615
> URL: https://issues.apache.org/jira/browse/HIVE-20615
> Project: Hive
>  Issue Type: Sub-task
>  Components: Metastore
>Affects Versions: 3.1.0
>Reporter: Vaibhav Gumashta
>Assignee: Daniel Dai
>Priority: Major
> Attachments: HIVE-20615.1.patch, HIVE-20615.1.patch, 
> HIVE-20615.1.patch, HIVE-20615.1.patch, HIVE-20615.1.patch, 
> HIVE-20615.1.patch, HIVE-21625.2.patch
>
>
> Regression introduced in HIVE-18264. Fixes background thread starting and 
> refreshing of the table cache.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (HIVE-20615) CachedStore: Background refresh thread bug fixes

2019-04-18 Thread Daniel Dai (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-20615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Daniel Dai reassigned HIVE-20615:
-

Assignee: Daniel Dai  (was: Vaibhav Gumashta)

> CachedStore: Background refresh thread bug fixes
> 
>
> Key: HIVE-20615
> URL: https://issues.apache.org/jira/browse/HIVE-20615
> Project: Hive
>  Issue Type: Sub-task
>  Components: Metastore
>Affects Versions: 3.1.0
>Reporter: Vaibhav Gumashta
>Assignee: Daniel Dai
>Priority: Major
> Attachments: HIVE-20615.1.patch, HIVE-20615.1.patch, 
> HIVE-20615.1.patch, HIVE-20615.1.patch, HIVE-20615.1.patch, 
> HIVE-20615.1.patch, HIVE-21625.2.patch
>
>
> Regression introduced in HIVE-18264. Fixes background thread starting and 
> refreshing of the table cache.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21633:


| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
48s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m 
14s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
59s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
29s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
41s{color} | {color:red} ql: The patch generated 1 new + 27 unchanged - 0 fixed 
= 28 total (was 27) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
26s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
59s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 14s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16995/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16995/yetus/diff-checkstyle-ql.txt
 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16995/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch, HIVE-21633.03.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21634:




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

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

{color:green}SUCCESS:{color} +1 due to 15958 tests passed

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12966425 - PreCommit-HIVE-Build

> Materialized view rewriting over aggregate operators containing with grouping 
> sets
> --
>
> Key: HIVE-21634
> URL: https://issues.apache.org/jira/browse/HIVE-21634
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21634.patch
>
>
> A possible approach to support rewriting queries with an aggregate with 
> grouping sets is implementing a rule that splits the aggregate in the query 
> into an aggregate without grouping sets (bottom) and an aggregate with 
> grouping sets (top). Then the materialized view rewriting rule will trigger 
> on the former.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21621) Update Kafka Clients to recent release 2.2.0

2019-04-18 Thread slim bouguerra (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

slim bouguerra updated HIVE-21621:
--
Attachment: HIVE-21621.5.patch

> Update Kafka Clients to recent release 2.2.0
> 
>
> Key: HIVE-21621
> URL: https://issues.apache.org/jira/browse/HIVE-21621
> Project: Hive
>  Issue Type: Task
>  Components: kafka integration
>Reporter: slim bouguerra
>Assignee: slim bouguerra
>Priority: Trivial
>  Labels: pull-request-available
> Attachments: HIVE-21621.2.patch, HIVE-21621.3.patch, 
> HIVE-21621.3.patch, HIVE-21621.4.patch, HIVE-21621.5.patch, HIVE-21621.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> all in the title update Kafka Storage Handler to the most recent clients 
> library.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21634:


| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  1m 
52s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
 5s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
5s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
42s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
4s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
57s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  0m 
28s{color} | {color:blue} Maven dependency ordering for patch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
31s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
8s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
8s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
42s{color} | {color:red} ql: The patch generated 2 new + 147 unchanged - 0 
fixed = 149 total (was 147) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
22s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
0s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 40s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16994/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16994/yetus/diff-checkstyle-ql.txt
 |
| modules | C: ql itests U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16994/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Materialized view rewriting over aggregate operators containing with grouping 
> sets
> --
>
> Key: HIVE-21634
> URL: https://issues.apache.org/jira/browse/HIVE-21634
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21634.patch
>
>
> A possible approach to support rewriting queries with an aggregate with 
> grouping sets is implementing a rule that splits the aggregate in the query 
> into an aggregate without grouping sets (bottom) and an aggregate with 
> grouping sets (top). Then the materialized view rewriting rule will trigger 
> on the former.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21621) Update Kafka Clients to recent release 2.2.0

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21621:




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

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

{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 15921 tests 
executed
*Failed tests:*
{noformat}
TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely 
timed out) (batchId=256)
TestReplicationScenariosAcidTables - did not produce a TEST-*.xml file (likely 
timed out) (batchId=258)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] 
(batchId=170)
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12966419 - PreCommit-HIVE-Build

> Update Kafka Clients to recent release 2.2.0
> 
>
> Key: HIVE-21621
> URL: https://issues.apache.org/jira/browse/HIVE-21621
> Project: Hive
>  Issue Type: Task
>  Components: kafka integration
>Reporter: slim bouguerra
>Assignee: slim bouguerra
>Priority: Trivial
>  Labels: pull-request-available
> Attachments: HIVE-21621.2.patch, HIVE-21621.3.patch, 
> HIVE-21621.3.patch, HIVE-21621.4.patch, HIVE-21621.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> all in the title update Kafka Storage Handler to the most recent clients 
> library.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21621) Update Kafka Clients to recent release 2.2.0

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21621:


| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:red}-1{color} | {color:red} @author {color} | {color:red}  0m  
0s{color} | {color:red} The patch appears to contain 5 @author tags which the 
community has agreed to not allow in code contributions. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  1m 
59s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
 8s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  2m 
33s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  1m 
30s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
3s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
29s{color} | {color:blue} jdbc in master has 16 extant Findbugs warnings. 
{color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
20s{color} | {color:blue} itests/qtest-druid in master has 7 extant Findbugs 
warnings. {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
50s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  0m 
29s{color} | {color:blue} Maven dependency ordering for patch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  3m 
50s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  2m 
31s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  2m 
31s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
46s{color} | {color:red} ql: The patch generated 43 new + 433 unchanged - 2 
fixed = 476 total (was 435) {color} |
| {color:red}-1{color} | {color:red} whitespace {color} | {color:red}  0m  
0s{color} | {color:red} The patch has 11 line(s) that end in whitespace. Use 
git apply --whitespace=fix <>. Refer 
https://git-scm.com/docs/git-apply {color} |
| {color:green}+1{color} | {color:green} xml {color} | {color:green}  0m  
4s{color} | {color:green} The patch has no ill-formed XML file. {color} |
| {color:red}-1{color} | {color:red} findbugs {color} | {color:red}  4m 
20s{color} | {color:red} ql generated 9 new + 2256 unchanged - 0 fixed = 2265 
total (was 2256) {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
52s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 38m 13s{color} | 
{color:black} {color} |
\\
\\
|| Reason || Tests ||
| FindBugs | module:ql |
|  |  org.apache.hadoop.hive.ql.exec.DDLTask.writeToFile(String, String) may 
fail to close stream  At DDLTask.java:close stream  At DDLTask.java:[line 2328] 
|
|  |  Class org.apache.hadoop.hive.ql.exec.DDLTask defines non-transient 
non-serializable instance field defaultAuthorizationTranslator  In 
DDLTask.java:instance field defaultAuthorizationTranslator  In DDLTask.java |
|  |  
org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationTranslator
 stored into non-transient field DDLTask.defaultAuthorizationTranslator  At 
DDLTask.java:DDLTask.defaultAuthorizationTranslator  At DDLTask.java:[line 234] 
|
|  |  Dead store to hiveConf in 
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeAlterTableSkewedLocation(ASTNode,
 String, HashMap)  At 
DDLSemanticAnalyzer.java:org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeAlterTableSkewedLocation(ASTNode,
 String, HashMap)  At DDLSemanticAnalyzer.java:[line 4258] |
|  |  Dead store to hiveConf in 
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeAltertableSkewedby(String[],
 ASTNode)  At 
DDLSemanticAnalyzer.java:org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeAltertableSkewedby(String[],
 ASTNode)  At DDLSemanticAnalyzer.java:[line 4114] |
|  |  Class org.apache.hadoop.hive.ql.plan.DDLWork defin

[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: HIVE-21633.03.patch

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch, HIVE-21633.03.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21596) HiveMetastoreClient should be able to connect to older metastore servers

2019-04-18 Thread Vihang Karajgaonkar (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vihang Karajgaonkar updated HIVE-21596:
---
Description: 
{{HiveMetastoreClient}} currently depends on the fact that both the client and 
server versions are the same. Additionally, since the server APIs are backwards 
compatible, it is possible for a older client (eg. 2.1.0 client version) to 
connect to a newer server (eg. 3.1.0 server version) without any issues. This 
is useful in setups where HMS is deployed in a remote mode and clients connect 
to it remotely.

It would be a good improvement if a newer version {{HiveMetastoreClient }} can 
connect to the a older server version. When a newer client is talking to a 
older server following things can happen:

1. Client invokes a RPC to the older server which doesn't exist.
 In such a case, thrift will throw {{Invalid method name}} exception which 
should be automatically be handled by the clients since each API already throws 
TException.

2. Client invokes a RPC using thrift objects which has new fields added.
 When a new field is added to a thrift object, the server does not deserialize 
the field in the first place since it does not know about that field id. So the 
wire-compatibility exists already. However, the client side application should 
understand the implications of such a behavior. In such cases, it would be 
better for the client to throw exception by checking the server version which 
was added in HIVE-21484

3. If the newer client has re-implemented a certain API, for example, using 
newer thrift API the client will start seeing exception {{Invalid method name}} 
since the older server does not have such a method.
 This can be handled on the client side by making sure that the newer 
implementation is conditional to the server version. Which means client should 
check the server version and invoke the new implementation only if the server 
version supports the newer API. (On a side note, it would be great if metastore 
also gives information of which APIs are supported for a given version)

4. In such cases the API itself is binary compatible (method signature is same) 
but it is semantically different than previous versions. For example, in Hive-3 
the {{getAllDatabases()}} API appends the default catalog name to the request 
which a older server will interpret as a pattern for the dbName and will return 
nothing.

In such case, the client should make sure that the server is at the newer 
version or else fall-back to the older semantically equivalent call. In this 
example, it should fallback to the old {{get_all_databases}} API call.

One of the real world use-case of such a feature is in Impala which wants to 
have capability to talk to both HMS 2.x and HMS 3.x. But other applications 
like Spark (or third party applications which want to support multiple HMS 
versions) may also find this useful.

Also, this patch will do a best effort to fix all such cases between Hive 2.3.0 
and newer versions of HMS. It should be a on-going effort to be exhaustive. We 
will also need to add support for this in our test infrastructure to spin up 
older HMS server versions and test using newer clients APIs. I will create a 
separate sub-task for that since it may need more plumbing in ptest.

  was:
{{HiveMetastoreClient}} currently depends on the fact that both the client and 
server versions are the same. Additionally, since the server APIs are backwards 
compatible, it is possible for a older client (eg. 2.1.0 client version) to 
connect to a newer server (eg. 3.1.0 server version) without any issues. This 
is useful in setups where HMS is deployed in a remote mode and clients connect 
to it remotely.

It would be a good improvement if a newer version {{HiveMetastoreClient }} can 
connect to the a older server version. When a newer client is talking to a 
older server following things can happen:

1. Client invokes a RPC to the older server which doesn't exist.
In such a case, thrift will throw {{Invalid method name}} exception which 
should be automatically be handled by the clients since each API already throws 
TException.

2. Client invokes a RPC using thrift objects which has new fields added.
When a new field is added to a thrift object, the server does not deserialize 
the field in the first place since it does not know about that field id. So the 
wire-compatibility exists already. However, the client side application should 
understand the implications of such a behavior. In such cases, it would be 
better for the client to throw exception by checking the server version which 
was added in HIVE-21484

3. If the newer client has re-implemented a certain API, for example, using 
newer thrift API the client will start seeing exception {{Invalid method name}} 
since the older server does not have such a method.
This can be handled on the client side by making sure that the new

[jira] [Commented] (HIVE-21529) Hive support bootstrap of ACID/MM tables on an existing policy.

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


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

Jesus Camacho Rodriguez commented on HIVE-21529:


[~ashutosh.bapat], [~sankarh], {{TestReplicationScenariosAcidTables}} seems to 
be timing out repeatedly recently, e.g., 
https://issues.apache.org/jira/browse/HIVE-21633?focusedCommentId=16821576&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-16821576.
 I am wondering whether it may be related to this patch?

> Hive support bootstrap of ACID/MM tables on an existing policy.
> ---
>
> Key: HIVE-21529
> URL: https://issues.apache.org/jira/browse/HIVE-21529
> Project: Hive
>  Issue Type: Sub-task
>  Components: repl, Transactions
>Affects Versions: 4.0.0
>Reporter: Sankar Hariappan
>Assignee: Ashutosh Bapat
>Priority: Major
>  Labels: DR, pull-request-available, replication
> Fix For: 4.0.0
>
> Attachments: HIVE-21529.01.patch, HIVE-21529.02.patch, 
> HIVE-21529.03.patch, HIVE-21529.04.patch, HIVE-21529.05.patch, 
> HIVE-21529.06.patch, HIVE-21529.07.patch
>
>  Time Spent: 6h 50m
>  Remaining Estimate: 0h
>
> If ACID/MM tables to be enabled (hive.repl.dump.include.acid.tables) on an 
> existing repl policy, then need to combine bootstrap dump of these tables 
> along with the ongoing incremental dump. 
>  Shall add a one time config "hive.repl.bootstrap.acid.tables" to include 
> bootstrap in the given dump.
> The support for hive.repl.bootstrap.cleanup.type for ACID tables to clean-up 
> partially bootstrapped tables in case of retry is already in place, thanks to 
> the work done during external tables. Need to test that it actually works.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21633:




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

{color:red}ERROR:{color} -1 due to build exiting with an error

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Tests exited with: Exception: Patch URL 
https://issues.apache.org/jira/secure/attachment/12966415/HIVE-21633.02.patch 
was found in seen patch url's cache and a test was probably run already on it. 
Aborting...
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12966415 - PreCommit-HIVE-Build

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21633:




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

{color:red}ERROR:{color} -1 due to build exiting with an error

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Tests exited with: Exception: Patch URL 
https://issues.apache.org/jira/secure/attachment/12966415/HIVE-21633.02.patch 
was found in seen patch url's cache and a test was probably run already on it. 
Aborting...
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12966415 - PreCommit-HIVE-Build

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21633:




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

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 15939 tests 
executed
*Failed tests:*
{noformat}
TestReplicationScenariosAcidTables - did not produce a TEST-*.xml file (likely 
timed out) (batchId=258)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_window] 
(batchId=35)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_scalar]
 (batchId=171)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_select]
 (batchId=171)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_groupby_grouping_window]
 (batchId=183)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[acid_vectorization_original_tez]
 (batchId=111)
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12966415 - PreCommit-HIVE-Build

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21634:
---
Attachment: HIVE-21634.patch

> Materialized view rewriting over aggregate operators containing with grouping 
> sets
> --
>
> Key: HIVE-21634
> URL: https://issues.apache.org/jira/browse/HIVE-21634
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21634.patch
>
>
> A possible approach to support rewriting queries with an aggregate with 
> grouping sets is implementing a rule that splits the aggregate in the query 
> into an aggregate without grouping sets (bottom) and an aggregate with 
> grouping sets (top). Then the materialized view rewriting rule will trigger 
> on the former.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Work started] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Work on HIVE-21634 started by Jesus Camacho Rodriguez.
--
> Materialized view rewriting over aggregate operators containing with grouping 
> sets
> --
>
> Key: HIVE-21634
> URL: https://issues.apache.org/jira/browse/HIVE-21634
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> A possible approach to support rewriting queries with an aggregate with 
> grouping sets is implementing a rule that splits the aggregate in the query 
> into an aggregate without grouping sets (bottom) and an aggregate with 
> grouping sets (top). Then the materialized view rewriting rule will trigger 
> on the former.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21634:
---
Status: Patch Available  (was: In Progress)

> Materialized view rewriting over aggregate operators containing with grouping 
> sets
> --
>
> Key: HIVE-21634
> URL: https://issues.apache.org/jira/browse/HIVE-21634
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> A possible approach to support rewriting queries with an aggregate with 
> grouping sets is implementing a rule that splits the aggregate in the query 
> into an aggregate without grouping sets (bottom) and an aggregate with 
> grouping sets (top). Then the materialized view rewriting rule will trigger 
> on the former.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez reassigned HIVE-21634:
--


> Materialized view rewriting over aggregate operators containing with grouping 
> sets
> --
>
> Key: HIVE-21634
> URL: https://issues.apache.org/jira/browse/HIVE-21634
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> A possible approach to support rewriting queries with an aggregate with 
> grouping sets is implementing a rule that splits the aggregate in the query 
> into an aggregate without grouping sets (bottom) and an aggregate with 
> grouping sets (top). Then the materialized view rewriting rule will trigger 
> on the former.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21621) Update Kafka Clients to recent release 2.2.0

2019-04-18 Thread slim bouguerra (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

slim bouguerra updated HIVE-21621:
--
Attachment: HIVE-21621.4.patch

> Update Kafka Clients to recent release 2.2.0
> 
>
> Key: HIVE-21621
> URL: https://issues.apache.org/jira/browse/HIVE-21621
> Project: Hive
>  Issue Type: Task
>  Components: kafka integration
>Reporter: slim bouguerra
>Assignee: slim bouguerra
>Priority: Trivial
>  Labels: pull-request-available
> Attachments: HIVE-21621.2.patch, HIVE-21621.3.patch, 
> HIVE-21621.3.patch, HIVE-21621.4.patch, HIVE-21621.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> all in the title update Kafka Storage Handler to the most recent clients 
> library.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21633:


| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  9m 
 6s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
9s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
5s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
5s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
30s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
9s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
9s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
40s{color} | {color:red} ql: The patch generated 1 new + 27 unchanged - 0 fixed 
= 28 total (was 27) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
25s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
59s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 32s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16990/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16990/yetus/diff-checkstyle-ql.txt
 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16990/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21619) Print timestamp type without precision in SQL explain extended

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


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

Jesus Camacho Rodriguez commented on HIVE-21619:


TestReplicationScenariosAcidTables seems to always timeout... Not sure how this 
patch could be related, but will take a look.

> Print timestamp type without precision in SQL explain extended
> --
>
> Key: HIVE-21619
> URL: https://issues.apache.org/jira/browse/HIVE-21619
> Project: Hive
>  Issue Type: Bug
>  Components: CBO
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.01.patch, HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.patch
>
>
> Hive dialect should print timestamp type without precision in generated SQL, 
> since currently Hive does not support user-defined precision.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21619) Print timestamp type without precision in SQL explain extended

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21619:




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

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

{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15939 tests 
executed
*Failed tests:*
{noformat}
TestReplicationScenariosAcidTables - did not produce a TEST-*.xml file (likely 
timed out) (batchId=258)
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12966410 - PreCommit-HIVE-Build

> Print timestamp type without precision in SQL explain extended
> --
>
> Key: HIVE-21619
> URL: https://issues.apache.org/jira/browse/HIVE-21619
> Project: Hive
>  Issue Type: Bug
>  Components: CBO
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.01.patch, HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.patch
>
>
> Hive dialect should print timestamp type without precision in generated SQL, 
> since currently Hive does not support user-defined precision.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21619) Print timestamp type without precision in SQL explain extended

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21619:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
39s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m 
12s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
0s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
28s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
8s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
8s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
43s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
15s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
58s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 24m 51s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16989/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16989/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Print timestamp type without precision in SQL explain extended
> --
>
> Key: HIVE-21619
> URL: https://issues.apache.org/jira/browse/HIVE-21619
> Project: Hive
>  Issue Type: Bug
>  Components: CBO
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.01.patch, HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.patch
>
>
> Hive dialect should print timestamp type without precision in generated SQL, 
> since currently Hive does not support user-defined precision.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: HIVE-21633.02.patch

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: (was: HIVE-21633.01.patch)

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.02.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: (was: HIVE-21633.01.patch)

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.01.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: HIVE-21633.01.patch

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.01.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: HIVE-21633.01.patch

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.01.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: (was: HIVE-21633.patch)

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.01.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21619) Print timestamp type without precision in SQL explain extended

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21619:
---
Attachment: HIVE-21619.01.patch

> Print timestamp type without precision in SQL explain extended
> --
>
> Key: HIVE-21619
> URL: https://issues.apache.org/jira/browse/HIVE-21619
> Project: Hive
>  Issue Type: Bug
>  Components: CBO
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.01.patch, HIVE-21619.01.patch, HIVE-21619.01.patch, 
> HIVE-21619.patch
>
>
> Hive dialect should print timestamp type without precision in generated SQL, 
> since currently Hive does not support user-defined precision.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Status: Patch Available  (was: In Progress)

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Issue Type: Improvement  (was: Bug)

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Work started] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Work on HIVE-21633 started by Jesus Camacho Rodriguez.
--
> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez reassigned HIVE-21633:
--


> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Bug
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21633) Estimate range for value generated by aggregate function in statistics annotation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21633:
---
Attachment: HIVE-21633.patch

> Estimate range for value generated by aggregate function in statistics 
> annotation
> -
>
> Key: HIVE-21633
> URL: https://issues.apache.org/jira/browse/HIVE-21633
> Project: Hive
>  Issue Type: Improvement
>  Components: Statistics
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Attachments: HIVE-21633.patch
>
>
> In some cases, we can infer the estimate of the range for a value generated 
> by an aggregate function during statistics annotation. For instance, we can 
> estimate the min of the sum of a column with positive min value as that same 
> min value.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Comment Edited] (HIVE-21631) Enhance metastore API to allow bulk-loading materialized views

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


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

Jesus Camacho Rodriguez edited comment on HIVE-21631 at 4/18/19 8:45 PM:
-

No need to have this as a sub-task under the umbrella for materialized views 
enhancements that was already closed, I've converted it to issue.


was (Author: jcamachorodriguez):
No need to have this as a sub-task under the umbrella for materialized views 
enhancements that was already closed, I've moved it to issue.

> Enhance metastore API to allow bulk-loading materialized views
> --
>
> Key: HIVE-21631
> URL: https://issues.apache.org/jira/browse/HIVE-21631
> Project: Hive
>  Issue Type: Bug
>  Components: Materialized views, Metastore
>Affects Versions: 3.2.0, 3.1.1
>Reporter: Craig Condit
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to 
> retrieve all materialized views. This causes severe performance degradation 
> on multi-tenant clusters with thousands of databases (very similar to how the 
> old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view 
> definitions at once (for all DBs) so that we don't have to make thousands of 
> metastore calls per query.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21631) Enhance metastore API to allow bulk-loading materialized views

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


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

Jesus Camacho Rodriguez commented on HIVE-21631:


No need to have this as a sub-task under the umbrella for materialized views 
enhancements that was already closed, I've moved it to issue.

> Enhance metastore API to allow bulk-loading materialized views
> --
>
> Key: HIVE-21631
> URL: https://issues.apache.org/jira/browse/HIVE-21631
> Project: Hive
>  Issue Type: Bug
>  Components: Materialized views, Metastore
>Affects Versions: 3.2.0, 3.1.1
>Reporter: Craig Condit
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to 
> retrieve all materialized views. This causes severe performance degradation 
> on multi-tenant clusters with thousands of databases (very similar to how the 
> old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view 
> definitions at once (for all DBs) so that we don't have to make thousands of 
> metastore calls per query.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21631) Enhance metastore API to allow bulk-loading materialized views

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-21631:
---
Issue Type: Bug  (was: Sub-task)
Parent: (was: HIVE-14484)

> Enhance metastore API to allow bulk-loading materialized views
> --
>
> Key: HIVE-21631
> URL: https://issues.apache.org/jira/browse/HIVE-21631
> Project: Hive
>  Issue Type: Bug
>  Components: Materialized views, Metastore
>Affects Versions: 3.2.0, 3.1.1
>Reporter: Craig Condit
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to 
> retrieve all materialized views. This causes severe performance degradation 
> on multi-tenant clusters with thousands of databases (very similar to how the 
> old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view 
> definitions at once (for all DBs) so that we don't have to make thousands of 
> metastore calls per query.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Resolved] (HIVE-14484) Extensions for initial materialized views implementation

2019-04-18 Thread Jesus Camacho Rodriguez (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-14484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez resolved HIVE-14484.

Resolution: Fixed

> Extensions for initial materialized views implementation
> 
>
> Key: HIVE-14484
> URL: https://issues.apache.org/jira/browse/HIVE-14484
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Fix For: 3.2.0
>
>
> Follow-up of HIVE-14249.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (HIVE-21631) Enhance metastore API to allow bulk-loading materialized views

2019-04-18 Thread Craig Condit (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Craig Condit reassigned HIVE-21631:
---

Assignee: Jesus Camacho Rodriguez

> Enhance metastore API to allow bulk-loading materialized views
> --
>
> Key: HIVE-21631
> URL: https://issues.apache.org/jira/browse/HIVE-21631
> Project: Hive
>  Issue Type: Sub-task
>  Components: Materialized views, Metastore
>Affects Versions: 3.2.0, 3.1.1
>Reporter: Craig Condit
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to 
> retrieve all materialized views. This causes severe performance degradation 
> on multi-tenant clusters with thousands of databases (very similar to how the 
> old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view 
> definitions at once (for all DBs) so that we don't have to make thousands of 
> metastore calls per query.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21631) Enhance metastore API to allow bulk-loading materialized views

2019-04-18 Thread Craig Condit (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Craig Condit updated HIVE-21631:

Issue Type: Sub-task  (was: Improvement)
Parent: HIVE-14484

> Enhance metastore API to allow bulk-loading materialized views
> --
>
> Key: HIVE-21631
> URL: https://issues.apache.org/jira/browse/HIVE-21631
> Project: Hive
>  Issue Type: Sub-task
>  Components: Materialized views, Metastore
>Affects Versions: 3.2.0, 3.1.1
>Reporter: Craig Condit
>Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to 
> retrieve all materialized views. This causes severe performance degradation 
> on multi-tenant clusters with thousands of databases (very similar to how the 
> old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view 
> definitions at once (for all DBs) so that we don't have to make thousands of 
> metastore calls per query.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Reopened] (HIVE-14484) Extensions for initial materialized views implementation

2019-04-18 Thread Craig Condit (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-14484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Craig Condit reopened HIVE-14484:
-

> Extensions for initial materialized views implementation
> 
>
> Key: HIVE-14484
> URL: https://issues.apache.org/jira/browse/HIVE-14484
> Project: Hive
>  Issue Type: Improvement
>  Components: Materialized views
>Affects Versions: 2.2.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
> Fix For: 3.2.0
>
>
> Follow-up of HIVE-14249.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21584) Java 11 preparation: system class loader is not URLClassLoader

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21584:




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

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

{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15945 tests 
executed
*Failed tests:*
{noformat}
TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely 
timed out) (batchId=256)
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12966380 - PreCommit-HIVE-Build

> Java 11 preparation: system class loader is not URLClassLoader
> --
>
> Key: HIVE-21584
> URL: https://issues.apache.org/jira/browse/HIVE-21584
> Project: Hive
>  Issue Type: Task
>  Components: Hive
>Affects Versions: 4.0.0
>Reporter: Zoltan Matyus
>Assignee: Zoltan Matyus
>Priority: Major
> Attachments: HIVE-21584.01.patch, HIVE-21584.02.patch, 
> HIVE-21584.03.patch, HIVE-21584.04.patch, HIVE-21584.05.patch, 
> HIVE-21584.06.patch
>
>
> Currently, Hive assumes that the system class loader is instance of 
> {{URLClassLoader}}. In Java 11 this is not the case. There are a few 
> (unresolved) JIRAs about specific occurrences of {{URLClassLoader}} (e.g. 
> [HIVE-21237|https://issues.apache.org/jira/browse/HIVE-21237], 
> [HIVE-17909|https://issues.apache.org/jira/browse/HIVE-17909]), but no 
> _"remove all occurrences"_. Also I couldn't find umbrella "Java 11 upgrade" 
> JIRA.
> This ticket is to remove all unconditional casts of any random class loader 
> to {{URLClassLoader}}.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21584) Java 11 preparation: system class loader is not URLClassLoader

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21584:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  1m 
47s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
23s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  2m 
57s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  1m 
42s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  2m 
43s{color} | {color:blue} standalone-metastore/metastore-common in master has 
29 extant Findbugs warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
33s{color} | {color:blue} common in master has 63 extant Findbugs warnings. 
{color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
28s{color} | {color:blue} spark-client in master has 10 extant Findbugs 
warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
7s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
45s{color} | {color:blue} llap-server in master has 81 extant Findbugs 
warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
31s{color} | {color:blue} beeline in master has 44 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  2m 
52s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  0m 
28s{color} | {color:blue} Maven dependency ordering for patch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  3m 
22s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  2m 
55s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  2m 
55s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
11s{color} | {color:green} standalone-metastore/metastore-common: The patch 
generated 0 new + 22 unchanged - 2 fixed = 22 total (was 24) {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
13s{color} | {color:green} common: The patch generated 0 new + 1 unchanged - 1 
fixed = 1 total (was 2) {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
10s{color} | {color:green} The patch spark-client passed checkstyle {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
43s{color} | {color:green} ql: The patch generated 0 new + 194 unchanged - 3 
fixed = 194 total (was 197) {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
14s{color} | {color:green} llap-server: The patch generated 0 new + 8 unchanged 
- 1 fixed = 8 total (was 9) {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
12s{color} | {color:green} The patch beeline passed checkstyle {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  2m 
48s{color} | {color:green} metastore-common in the patch passed. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  0m 
42s{color} | {color:green} common generated 0 new + 62 unchanged - 1 fixed = 62 
total (was 63) {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  0m 
33s{color} | {color:green} spark-client in the patch passed. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
21s{color} | {color:green} ql generated 0 new + 2252 unchanged - 4 fixed = 2252 
total (was 2256) {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  0m 
54s{color} | {color:green} llap-server in the patch passed. {color} |
| {co

[jira] [Updated] (HIVE-21632) Hive should not push partition columns to the Parquet predicate, even if the data file contains the partition column

2019-04-18 Thread Marta Kuczora (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Marta Kuczora updated HIVE-21632:
-
Description: 
If there is a partitioned Parquet table in Hive, and the data file in one of 
the partitions (not correctly) contains the partition column as well, filtering 
on the partition column will return no rows if the Parquet predicate pushdown 
is enabled. If the PPD is disabled, the rows will return correctly.
The reason why it doesn't work is that, if the PPD is switched on, Hive will 
send the predicate 'partition_column= ...' to parquet and a requested schema 
which doesn't contain the partition column. When the data is read from parquet, 
this column will be skipped, because the requested schema doesn't contain it, 
but it still tries to apply the filter predicate, so it will return an empty 
result set.
I think if the rows are returned correctly without PPD, they should be returned 
with PPD as well. Hive should omit the partition column from the Parquet 
predicate.

> Hive should not push partition columns to the Parquet predicate, even if the 
> data file contains the partition column
> 
>
> Key: HIVE-21632
> URL: https://issues.apache.org/jira/browse/HIVE-21632
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 4.0.0
>Reporter: Marta Kuczora
>Priority: Minor
>
> If there is a partitioned Parquet table in Hive, and the data file in one of 
> the partitions (not correctly) contains the partition column as well, 
> filtering on the partition column will return no rows if the Parquet 
> predicate pushdown is enabled. If the PPD is disabled, the rows will return 
> correctly.
> The reason why it doesn't work is that, if the PPD is switched on, Hive will 
> send the predicate 'partition_column= ...' to parquet and a requested schema 
> which doesn't contain the partition column. When the data is read from 
> parquet, this column will be skipped, because the requested schema doesn't 
> contain it, but it still tries to apply the filter predicate, so it will 
> return an empty result set.
> I think if the rows are returned correctly without PPD, they should be 
> returned with PPD as well. Hive should omit the partition column from the 
> Parquet predicate.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21632) Hive should not push partition columns to the Parquet predicate, even if the data file contains the partition column

2019-04-18 Thread Marta Kuczora (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Marta Kuczora updated HIVE-21632:
-
Summary: Hive should not push partition columns to the Parquet predicate, 
even if the data file contains the partition column  (was: Hive should not push 
partition columns to the Parquet predicate, even if the data file contains a 
column with the same name as the partition column)

> Hive should not push partition columns to the Parquet predicate, even if the 
> data file contains the partition column
> 
>
> Key: HIVE-21632
> URL: https://issues.apache.org/jira/browse/HIVE-21632
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 4.0.0
>Reporter: Marta Kuczora
>Priority: Minor
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21612) Upgrade druid to 0.14.0-incubating

2019-04-18 Thread slim bouguerra (JIRA)


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

slim bouguerra commented on HIVE-21612:
---

+1 pending on tests.


> Upgrade druid to 0.14.0-incubating
> --
>
> Key: HIVE-21612
> URL: https://issues.apache.org/jira/browse/HIVE-21612
> Project: Hive
>  Issue Type: Task
>Reporter: Nishant Bangarwa
>Assignee: Nishant Bangarwa
>Priority: Major
>  Labels: pull-request-available
> Attachments: HIVE-21612.patch
>
>  Time Spent: 20m
>  Remaining Estimate: 0h
>
> Druid 0.14.0-incubating is released. 
> This task is to upgrade hive to use 0.14.0-incubating version of druid. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Work logged] (HIVE-21612) Upgrade druid to 0.14.0-incubating

2019-04-18 Thread ASF GitHub Bot (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21612?focusedWorklogId=229818&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-229818
 ]

ASF GitHub Bot logged work on HIVE-21612:
-

Author: ASF GitHub Bot
Created on: 18/Apr/19 17:09
Start Date: 18/Apr/19 17:09
Worklog Time Spent: 10m 
  Work Description: b-slim commented on issue #596: HIVE-21612: Upgrade to 
druid 0.14.0-incubating
URL: https://github.com/apache/hive/pull/596#issuecomment-484595457
 
 
   LGTM
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 229818)
Time Spent: 20m  (was: 10m)

> Upgrade druid to 0.14.0-incubating
> --
>
> Key: HIVE-21612
> URL: https://issues.apache.org/jira/browse/HIVE-21612
> Project: Hive
>  Issue Type: Task
>Reporter: Nishant Bangarwa
>Assignee: Nishant Bangarwa
>Priority: Major
>  Labels: pull-request-available
> Attachments: HIVE-21612.patch
>
>  Time Spent: 20m
>  Remaining Estimate: 0h
>
> Druid 0.14.0-incubating is released. 
> This task is to upgrade hive to use 0.14.0-incubating version of druid. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21291) Restore historical way of handling timestamps in Avro while keeping the new semantics at the same time

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21291:




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

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

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 15960 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_2] 
(batchId=87)
org.apache.hadoop.hive.serde2.avro.TestAvroDeserializer.canDeserializeTimestamps
 (batchId=341)
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12966377 - PreCommit-HIVE-Build

> Restore historical way of handling timestamps in Avro while keeping the new 
> semantics at the same time
> --
>
> Key: HIVE-21291
> URL: https://issues.apache.org/jira/browse/HIVE-21291
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Zoltan Ivanfi
>Assignee: Karen Coppage
>Priority: Major
> Attachments: HIVE-21291.1.patch, HIVE-21291.2.patch, 
> HIVE-21291.3.patch, HIVE-21291.4.patch, HIVE-21291.4.patch, HIVE-21291.5.patch
>
>
> This sub-task is for implementing the Avro-specific parts of the following 
> plan:
> h1. Problem
> Historically, the semantics of the TIMESTAMP type in Hive depended on the 
> file format. Timestamps in Avro, Parquet and RCFiles with a binary SerDe had 
> _Instant_ semantics, while timestamps in ORC, textfiles and RCFiles with a 
> text SerDe had _LocalDateTime_ semantics.
> The Hive community wanted to get rid of this inconsistency and have 
> _LocalDateTime_ semantics in Avro, Parquet and RCFiles with a binary SerDe as 
> well. *Hive 3.1 turned off normalization to UTC* to achieve this. While this 
> leads to the desired new semantics, it also leads to incorrect results when 
> new Hive versions read timestamps written by old Hive versions or when old 
> Hive versions or any other component not aware of this change (including 
> legacy Impala and Spark versions) read timestamps written by new Hive 
> versions.
> h1. Solution
> To work around this issue, Hive *should restore the practice of normalizing 
> to UTC* when writing timestamps to Avro, Parquet and RCFiles with a binary 
> SerDe. In itself, this would restore the historical _Instant_ semantics, 
> which is undesirable. In order to achieve the desired _LocalDateTime_ 
> semantics in spite of normalizing to UTC, newer Hive versions should record 
> the session-local local time zone in the file metadata fields serving 
> arbitrary key-value storage purposes.
> When reading back files with this time zone metadata, newer Hive versions (or 
> any other new component aware of this extra metadata) can achieve 
> _LocalDateTime_ semantics by *converting from UTC to the saved time zone 
> (instead of to the local time zone)*. Legacy components that are unaware of 
> the new metadata can read the files without any problem and the timestamps 
> will show the historical Instant behaviour to them.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21291) Restore historical way of handling timestamps in Avro while keeping the new semantics at the same time

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21291:


| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  1m 
12s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
42s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  8m 
22s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  3m 
25s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
35s{color} | {color:blue} common in master has 63 extant Findbugs warnings. 
{color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  0m 
43s{color} | {color:blue} serde in master has 197 extant Findbugs warnings. 
{color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m 
15s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  8m 
23s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  0m 
27s{color} | {color:blue} Maven dependency ordering for patch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  9m 
10s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  8m  
8s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  8m  
8s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
15s{color} | {color:red} serde: The patch generated 2 new + 131 unchanged - 0 
fixed = 133 total (was 131) {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  2m  
6s{color} | {color:red} root: The patch generated 2 new + 588 unchanged - 0 
fixed = 590 total (was 588) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  5m 
41s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  8m 
12s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 70m 40s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16986/dev-support/hive-personality.sh
 |
| git revision | master / bb71ce5 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16986/yetus/diff-checkstyle-serde.txt
 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16986/yetus/diff-checkstyle-root.txt
 |
| modules | C: common serde ql . U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16986/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Restore historical way of handling timestamps in Avro while keeping the new 
> semantics at the same time
> --
>
> Key: HIVE-21291
> URL: https://issues.apache.org/jira/browse/HIVE-21291
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Zoltan Ivanfi
>Assignee: Karen Coppage
>Priority: Major
> Attachments: HIVE-21291.1.patch, HIVE-21291.2.patch, 
> HIVE-21291.3.patch, HIVE-21291.4.patch, HIVE-21291.4.patch, HIVE-21291

[jira] [Commented] (HIVE-21630) Refactor database object reference access

2019-04-18 Thread David Lavati (JIRA)


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

David Lavati commented on HIVE-21630:
-

Thanks [~alangates], I discovered it and utilized it while I was working on the 
original issue HIVE-21198.

I turned that into a subtask of this umbrella, as introducing all the possible 
changes in 1 ticket would be too much: There are some non-trivial state changes 
around a couple of places, where doing the right thing in 1 commit would be too 
convoluted.

> Refactor database object reference access
> -
>
> Key: HIVE-21630
> URL: https://issues.apache.org/jira/browse/HIVE-21630
> Project: Hive
>  Issue Type: Improvement
>Reporter: David Lavati
>Assignee: David Lavati
>Priority: Major
>  Labels: refactor
>
> There are many places in which "
> {databasename}
> .
> {tablename}
> " is passed as a single string; there are some places where the they travel 
> as 2 separate arguments or as a {{String[]}}.
> Idea would be to introduce a simple immutable class with 2 fields ; and pass 
> these informations together. Making this better is required if we would want 
> to enable dot in tablenames: HIVE-16907, HIVE-21151
> The refactor requires large rework especially in the ql module: this ticket 
> serves as an umbrella for these steps.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21584) Java 11 preparation: system class loader is not URLClassLoader

2019-04-18 Thread Zoltan Matyus (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zoltan Matyus updated HIVE-21584:
-
Attachment: HIVE-21584.06.patch

> Java 11 preparation: system class loader is not URLClassLoader
> --
>
> Key: HIVE-21584
> URL: https://issues.apache.org/jira/browse/HIVE-21584
> Project: Hive
>  Issue Type: Task
>  Components: Hive
>Affects Versions: 4.0.0
>Reporter: Zoltan Matyus
>Assignee: Zoltan Matyus
>Priority: Major
> Attachments: HIVE-21584.01.patch, HIVE-21584.02.patch, 
> HIVE-21584.03.patch, HIVE-21584.04.patch, HIVE-21584.05.patch, 
> HIVE-21584.06.patch
>
>
> Currently, Hive assumes that the system class loader is instance of 
> {{URLClassLoader}}. In Java 11 this is not the case. There are a few 
> (unresolved) JIRAs about specific occurrences of {{URLClassLoader}} (e.g. 
> [HIVE-21237|https://issues.apache.org/jira/browse/HIVE-21237], 
> [HIVE-17909|https://issues.apache.org/jira/browse/HIVE-17909]), but no 
> _"remove all occurrences"_. Also I couldn't find umbrella "Java 11 upgrade" 
> JIRA.
> This ticket is to remove all unconditional casts of any random class loader 
> to {{URLClassLoader}}.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21630) Refactor database object reference access

2019-04-18 Thread Alan Gates (JIRA)


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

Alan Gates commented on HIVE-21630:
---

A class for table name already exists:  
storage-api/src/org/apache/hadoop/hive/common/TableName.java

You should use that rather than create a new one.

> Refactor database object reference access
> -
>
> Key: HIVE-21630
> URL: https://issues.apache.org/jira/browse/HIVE-21630
> Project: Hive
>  Issue Type: Improvement
>Reporter: David Lavati
>Assignee: David Lavati
>Priority: Major
>  Labels: refactor
>
> There are many places in which "
> {databasename}
> .
> {tablename}
> " is passed as a single string; there are some places where the they travel 
> as 2 separate arguments or as a {{String[]}}.
> Idea would be to introduce a simple immutable class with 2 fields ; and pass 
> these informations together. Making this better is required if we would want 
> to enable dot in tablenames: HIVE-16907, HIVE-21151
> The refactor requires large rework especially in the ql module: this ticket 
> serves as an umbrella for these steps.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21291) Restore historical way of handling timestamps in Avro while keeping the new semantics at the same time

2019-04-18 Thread Karen Coppage (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Karen Coppage updated HIVE-21291:
-
Status: Open  (was: Patch Available)

> Restore historical way of handling timestamps in Avro while keeping the new 
> semantics at the same time
> --
>
> Key: HIVE-21291
> URL: https://issues.apache.org/jira/browse/HIVE-21291
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Zoltan Ivanfi
>Assignee: Karen Coppage
>Priority: Major
> Attachments: HIVE-21291.1.patch, HIVE-21291.2.patch, 
> HIVE-21291.3.patch, HIVE-21291.4.patch, HIVE-21291.4.patch, HIVE-21291.5.patch
>
>
> This sub-task is for implementing the Avro-specific parts of the following 
> plan:
> h1. Problem
> Historically, the semantics of the TIMESTAMP type in Hive depended on the 
> file format. Timestamps in Avro, Parquet and RCFiles with a binary SerDe had 
> _Instant_ semantics, while timestamps in ORC, textfiles and RCFiles with a 
> text SerDe had _LocalDateTime_ semantics.
> The Hive community wanted to get rid of this inconsistency and have 
> _LocalDateTime_ semantics in Avro, Parquet and RCFiles with a binary SerDe as 
> well. *Hive 3.1 turned off normalization to UTC* to achieve this. While this 
> leads to the desired new semantics, it also leads to incorrect results when 
> new Hive versions read timestamps written by old Hive versions or when old 
> Hive versions or any other component not aware of this change (including 
> legacy Impala and Spark versions) read timestamps written by new Hive 
> versions.
> h1. Solution
> To work around this issue, Hive *should restore the practice of normalizing 
> to UTC* when writing timestamps to Avro, Parquet and RCFiles with a binary 
> SerDe. In itself, this would restore the historical _Instant_ semantics, 
> which is undesirable. In order to achieve the desired _LocalDateTime_ 
> semantics in spite of normalizing to UTC, newer Hive versions should record 
> the session-local local time zone in the file metadata fields serving 
> arbitrary key-value storage purposes.
> When reading back files with this time zone metadata, newer Hive versions (or 
> any other new component aware of this extra metadata) can achieve 
> _LocalDateTime_ semantics by *converting from UTC to the saved time zone 
> (instead of to the local time zone)*. Legacy components that are unaware of 
> the new metadata can read the files without any problem and the timestamps 
> will show the historical Instant behaviour to them.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21291) Restore historical way of handling timestamps in Avro while keeping the new semantics at the same time

2019-04-18 Thread Karen Coppage (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Karen Coppage updated HIVE-21291:
-
Attachment: HIVE-21291.5.patch
Status: Patch Available  (was: Open)

> Restore historical way of handling timestamps in Avro while keeping the new 
> semantics at the same time
> --
>
> Key: HIVE-21291
> URL: https://issues.apache.org/jira/browse/HIVE-21291
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Zoltan Ivanfi
>Assignee: Karen Coppage
>Priority: Major
> Attachments: HIVE-21291.1.patch, HIVE-21291.2.patch, 
> HIVE-21291.3.patch, HIVE-21291.4.patch, HIVE-21291.4.patch, HIVE-21291.5.patch
>
>
> This sub-task is for implementing the Avro-specific parts of the following 
> plan:
> h1. Problem
> Historically, the semantics of the TIMESTAMP type in Hive depended on the 
> file format. Timestamps in Avro, Parquet and RCFiles with a binary SerDe had 
> _Instant_ semantics, while timestamps in ORC, textfiles and RCFiles with a 
> text SerDe had _LocalDateTime_ semantics.
> The Hive community wanted to get rid of this inconsistency and have 
> _LocalDateTime_ semantics in Avro, Parquet and RCFiles with a binary SerDe as 
> well. *Hive 3.1 turned off normalization to UTC* to achieve this. While this 
> leads to the desired new semantics, it also leads to incorrect results when 
> new Hive versions read timestamps written by old Hive versions or when old 
> Hive versions or any other component not aware of this change (including 
> legacy Impala and Spark versions) read timestamps written by new Hive 
> versions.
> h1. Solution
> To work around this issue, Hive *should restore the practice of normalizing 
> to UTC* when writing timestamps to Avro, Parquet and RCFiles with a binary 
> SerDe. In itself, this would restore the historical _Instant_ semantics, 
> which is undesirable. In order to achieve the desired _LocalDateTime_ 
> semantics in spite of normalizing to UTC, newer Hive versions should record 
> the session-local local time zone in the file metadata fields serving 
> arbitrary key-value storage purposes.
> When reading back files with this time zone metadata, newer Hive versions (or 
> any other new component aware of this extra metadata) can achieve 
> _LocalDateTime_ semantics by *converting from UTC to the saved time zone 
> (instead of to the local time zone)*. Legacy components that are unaware of 
> the new metadata can read the files without any problem and the timestamps 
> will show the historical Instant behaviour to them.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21593) Break up DDLTask - extract Privilege related operations

2019-04-18 Thread Zoltan Haindrich (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zoltan Haindrich updated HIVE-21593:

Resolution: Fixed
Status: Resolved  (was: Patch Available)

pushed to master. Thank you [~mgergely]!

> Break up DDLTask - extract Privilege related operations
> ---
>
> Key: HIVE-21593
> URL: https://issues.apache.org/jira/browse/HIVE-21593
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Miklos Gergely
>Assignee: Miklos Gergely
>Priority: Major
>  Labels: refactor-ddl
> Fix For: 4.0.0
>
> Attachments: HIVE-21593.01.patch, HIVE-21593.02.patch, 
> HIVE-21593.03.patch
>
>
> DDLTask is a huge class, more than 5000 lines long. The related DDLWork is 
> also a huge class, which has a field for each DDL operation it supports. The 
> goal is to refactor these in order to have everything cut into more 
> handleable classes under the package  org.apache.hadoop.hive.ql.exec.ddl:
>  * have a separate class for each operation
>  * have a package for each operation group (database ddl, table ddl, etc), so 
> the amount of classes under a package is more manageable
>  * make all the requests (DDLDesc subclasses) immutable
>  * DDLTask should be agnostic to the actual operations
>  * right now let's ignore the issue of having some operations handled by 
> DDLTask which are not actual DDL operations (lock, unlock, desc...)
> In the interim time when there are two DDLTask and DDLWork classes in the 
> code base the new ones in the new package are called DDLTask2 and DDLWork2 
> thus avoiding the usage of fully qualified class names where both the old and 
> the new classes are in use.
> Step #5: extract all the privilege related operations from the old DDLTask, 
> and move them under the new package.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Work logged] (HIVE-21198) Introduce a database object reference class

2019-04-18 Thread ASF GitHub Bot (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21198?focusedWorklogId=229686&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-229686
 ]

ASF GitHub Bot logged work on HIVE-21198:
-

Author: ASF GitHub Bot
Created on: 18/Apr/19 13:48
Start Date: 18/Apr/19 13:48
Worklog Time Spent: 10m 
  Work Description: dlavati-hw commented on issue #550: HIVE-21198 
Introduce a database object reference class
URL: https://github.com/apache/hive/pull/550#issuecomment-484516822
 
 
   The amount of possible refactors is a lot bigger then comfortable in 1 
issue, so I'm reducing the scope for this and opened HIVE-21630 as an umbrella 
ticket.
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 229686)
Time Spent: 2h 10m  (was: 2h)

> Introduce a database object reference class
> ---
>
> Key: HIVE-21198
> URL: https://issues.apache.org/jira/browse/HIVE-21198
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Zoltan Haindrich
>Assignee: David Lavati
>Priority: Major
>  Labels: pull-request-available
> Attachments: HIVE-21198.1.patch, HIVE-21198.2.patch, 
> HIVE-21198.3.patch, HIVE-21198.4.patch, HIVE-21198.5.patch
>
>  Time Spent: 2h 10m
>  Remaining Estimate: 0h
>
> There are many places in which "{databasename}.{tablename}" is passed as a 
> single string; there are some places where the they travel as 2 separate 
> arguments.
> Idea would be to introduce a simple immutable class with 2 fields ; and pass 
> these informations together. Making this better is required if we would be 
> wanting to enable dot in tablenames 
> HIVE-16907, HIVE-21151



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Work started] (HIVE-21630) Refactor database object reference access

2019-04-18 Thread David Lavati (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Work on HIVE-21630 started by David Lavati.
---
> Refactor database object reference access
> -
>
> Key: HIVE-21630
> URL: https://issues.apache.org/jira/browse/HIVE-21630
> Project: Hive
>  Issue Type: Improvement
>Reporter: David Lavati
>Assignee: David Lavati
>Priority: Major
>  Labels: refactor
>
> There are many places in which "
> {databasename}
> .
> {tablename}
> " is passed as a single string; there are some places where the they travel 
> as 2 separate arguments or as a {{String[]}}.
> Idea would be to introduce a simple immutable class with 2 fields ; and pass 
> these informations together. Making this better is required if we would want 
> to enable dot in tablenames: HIVE-16907, HIVE-21151
> The refactor requires large rework especially in the ql module: this ticket 
> serves as an umbrella for these steps.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21198) Introduce a database object reference class

2019-04-18 Thread David Lavati (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Lavati updated HIVE-21198:

Issue Type: Sub-task  (was: Improvement)
Parent: HIVE-21630

> Introduce a database object reference class
> ---
>
> Key: HIVE-21198
> URL: https://issues.apache.org/jira/browse/HIVE-21198
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Zoltan Haindrich
>Assignee: David Lavati
>Priority: Major
>  Labels: pull-request-available
> Attachments: HIVE-21198.1.patch, HIVE-21198.2.patch, 
> HIVE-21198.3.patch, HIVE-21198.4.patch, HIVE-21198.5.patch
>
>  Time Spent: 2h
>  Remaining Estimate: 0h
>
> There are many places in which "{databasename}.{tablename}" is passed as a 
> single string; there are some places where the they travel as 2 separate 
> arguments.
> Idea would be to introduce a simple immutable class with 2 fields ; and pass 
> these informations together. Making this better is required if we would be 
> wanting to enable dot in tablenames 
> HIVE-16907, HIVE-21151



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (HIVE-21630) Refactor database object reference access

2019-04-18 Thread David Lavati (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Lavati reassigned HIVE-21630:
---


> Refactor database object reference access
> -
>
> Key: HIVE-21630
> URL: https://issues.apache.org/jira/browse/HIVE-21630
> Project: Hive
>  Issue Type: Improvement
>Reporter: David Lavati
>Assignee: David Lavati
>Priority: Major
>  Labels: refactor
>
> There are many places in which "
> {databasename}
> .
> {tablename}
> " is passed as a single string; there are some places where the they travel 
> as 2 separate arguments or as a {{String[]}}.
> Idea would be to introduce a simple immutable class with 2 fields ; and pass 
> these informations together. Making this better is required if we would want 
> to enable dot in tablenames: HIVE-16907, HIVE-21151
> The refactor requires large rework especially in the ql module: this ticket 
> serves as an umbrella for these steps.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21629) Monitor qtest progress realtime on console

2019-04-18 Thread Laszlo Bodor (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Laszlo Bodor updated HIVE-21629:

Description: 
While running a qtest, or running multiple qtests with the same driver, 
user/dev can only see top level message for a long time:
{code}
[INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
{code}

It would be helpful to introduce a cli argument to enable some realtime 
monitoring. The challenge basically is that the tests run in separate surefire 
JVMs, which basically log into surefire report files, and everything which is 
logged with System.out can be found in that file:
{code}
itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
{code}
so, I would expect the same or similar behavior that I would get if I tailed 
this file in a separate terminal (tail -f ...)

  was:
While running a qtest, or running multiple qtests with the same driver, 
user/dev can only see top level message for a long time:
{code}
[INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
{code}

It would be helpful to introduce a cli argument to enable some realtime 
monitoring. The challenge basically is that the tests run in separate surefire 
JVMs, which basically log into surefire report files, and everything which is 
logged with System.out can be found in that file:
{code}
itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
{code}
so, I would expect the same or similar behavior that I would get if I tailed 
this file in a separate terminal


> Monitor qtest progress realtime on console
> --
>
> Key: HIVE-21629
> URL: https://issues.apache.org/jira/browse/HIVE-21629
> Project: Hive
>  Issue Type: Bug
>Reporter: Laszlo Bodor
>Priority: Major
>
> While running a qtest, or running multiple qtests with the same driver, 
> user/dev can only see top level message for a long time:
> {code}
> [INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
> {code}
> It would be helpful to introduce a cli argument to enable some realtime 
> monitoring. The challenge basically is that the tests run in separate 
> surefire JVMs, which basically log into surefire report files, and everything 
> which is logged with System.out can be found in that file:
> {code}
> itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
> {code}
> so, I would expect the same or similar behavior that I would get if I tailed 
> this file in a separate terminal (tail -f ...)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21629) Monitor qtest progress realtime on console

2019-04-18 Thread Laszlo Bodor (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Laszlo Bodor updated HIVE-21629:

Description: 
While running a qtest, or running multiple qtests with the same driver, 
user/dev can only see top level message for a long time:
{code}
[INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
{code}

It would be helpful to introduce a cli argument to enable some realtime 
monitoring. The challenge basically is that the tests run in separate surefire 
JVMs, which basically log into surefire report files, and everything which is 
logged with System.out can be found in that file:
{code}
itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
{code}
so, I would expect the same or similar behavior that I would get if I tailed 
this file in a separate terminal

  was:
While running a qtest, or running multiple qtests with the same driver, 
user/dev can only see top level message for a long time:
{code}
[INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
{code}

It would be helpful to introduce a cli argument to enable some realtime 
monitoring. The challenge basically is that the tests run in separate surefire 
JVMs, which basically log into surefire report files, and everything which is 
logged with System.out can be found in that file:
{code}
itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
{code}

so, I would expect the same or similar behavior as with tailing that file in a 
separate terminal


> Monitor qtest progress realtime on console
> --
>
> Key: HIVE-21629
> URL: https://issues.apache.org/jira/browse/HIVE-21629
> Project: Hive
>  Issue Type: Bug
>Reporter: Laszlo Bodor
>Priority: Major
>
> While running a qtest, or running multiple qtests with the same driver, 
> user/dev can only see top level message for a long time:
> {code}
> [INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
> {code}
> It would be helpful to introduce a cli argument to enable some realtime 
> monitoring. The challenge basically is that the tests run in separate 
> surefire JVMs, which basically log into surefire report files, and everything 
> which is logged with System.out can be found in that file:
> {code}
> itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
> {code}
> so, I would expect the same or similar behavior that I would get if I tailed 
> this file in a separate terminal



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21629) Monitor qtest progress realtime on console

2019-04-18 Thread Laszlo Bodor (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Laszlo Bodor updated HIVE-21629:

Description: 
While running a qtest, or running multiple qtests with the same driver, 
user/dev can only see top level message for a long time:
{code}
[INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
{code}

It would be helpful to introduce a cli argument to enable some realtime 
monitoring. The challenge basically is that the tests run in separate surefire 
JVMs, which basically log into surefire report files, and everything which is 
logged with System.out can be found in that file:
{code}
itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
{code}

so, I would expect the same or similar behavior as with tailing that file in a 
separate terminal

> Monitor qtest progress realtime on console
> --
>
> Key: HIVE-21629
> URL: https://issues.apache.org/jira/browse/HIVE-21629
> Project: Hive
>  Issue Type: Bug
>Reporter: Laszlo Bodor
>Priority: Major
>
> While running a qtest, or running multiple qtests with the same driver, 
> user/dev can only see top level message for a long time:
> {code}
> [INFO] Running org.apache.hadoop.hive.cli.TestCliDriver
> {code}
> It would be helpful to introduce a cli argument to enable some realtime 
> monitoring. The challenge basically is that the tests run in separate 
> surefire JVMs, which basically log into surefire report files, and everything 
> which is logged with System.out can be found in that file:
> {code}
> itests/qtest/target/surefire-reports/org.apache.hadoop.hive.cli.TestCliDriver-output.txt
> {code}
> so, I would expect the same or similar behavior as with tailing that file in 
> a separate terminal



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21366) Inconsistent behavior of ROUND() with integer in string as argument

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21366:




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

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

{color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 15914 tests 
executed
*Failed tests:*
{noformat}
TestConcurrentJobRequests - did not produce a TEST-*.xml file (likely timed 
out) (batchId=206)
TestConcurrentJobRequestsThreads - did not produce a TEST-*.xml file (likely 
timed out) (batchId=206)
TestConcurrentJobRequestsThreadsAndTimeout - did not produce a TEST-*.xml file 
(likely timed out) (batchId=206)
TestDesc - did not produce a TEST-*.xml file (likely timed out) (batchId=206)
TestJobIDParser - did not produce a TEST-*.xml file (likely timed out) 
(batchId=206)
TestServer - did not produce a TEST-*.xml file (likely timed out) (batchId=206)
TestTempletonUtils - did not produce a TEST-*.xml file (likely timed out) 
(batchId=206)
TestTrivialExecService - did not produce a TEST-*.xml file (likely timed out) 
(batchId=206)
TestWebHCatE2e - did not produce a TEST-*.xml file (likely timed out) 
(batchId=206)
{noformat}

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
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: 12966348 - PreCommit-HIVE-Build

> Inconsistent behavior of ROUND() with integer in string as argument
> ---
>
> Key: HIVE-21366
> URL: https://issues.apache.org/jira/browse/HIVE-21366
> Project: Hive
>  Issue Type: Bug
>Reporter: Sergey Yavorski
>Assignee: Bruno Pusztahazi
>Priority: Major
> Attachments: HIVE-21366.1.patch, HIVE-21366.2.patch
>
>
> hive> SELECT ROUND('1',4) AS r_str, ROUND(1,4) AS r_num;
> OK
> r_str   r_num
> *{color:#FF}1.0{color}* 1



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21612) Upgrade druid to 0.14.0-incubating

2019-04-18 Thread Nishant Bangarwa (JIRA)


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

Nishant Bangarwa commented on HIVE-21612:
-

[~bslim] [~ashutoshc] Any comments here ? 

> Upgrade druid to 0.14.0-incubating
> --
>
> Key: HIVE-21612
> URL: https://issues.apache.org/jira/browse/HIVE-21612
> Project: Hive
>  Issue Type: Task
>Reporter: Nishant Bangarwa
>Assignee: Nishant Bangarwa
>Priority: Major
>  Labels: pull-request-available
> Attachments: HIVE-21612.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Druid 0.14.0-incubating is released. 
> This task is to upgrade hive to use 0.14.0-incubating version of druid. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (HIVE-21366) Inconsistent behavior of ROUND() with integer in string as argument

2019-04-18 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21366:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
33s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
8s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
1s{color} | {color:blue} ql in master has 2265 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
0s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
28s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} ql: The patch generated 0 new + 0 unchanged - 25 
fixed = 0 total (was 25) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
14s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
0s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 24m 33s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-16985/dev-support/hive-personality.sh
 |
| git revision | master / 8f7f5d1 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-16985/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Inconsistent behavior of ROUND() with integer in string as argument
> ---
>
> Key: HIVE-21366
> URL: https://issues.apache.org/jira/browse/HIVE-21366
> Project: Hive
>  Issue Type: Bug
>Reporter: Sergey Yavorski
>Assignee: Bruno Pusztahazi
>Priority: Major
> Attachments: HIVE-21366.1.patch, HIVE-21366.2.patch
>
>
> hive> SELECT ROUND('1',4) AS r_str, ROUND(1,4) AS r_num;
> OK
> r_str   r_num
> *{color:#FF}1.0{color}* 1



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21366) Inconsistent behavior of ROUND() with integer in string as argument

2019-04-18 Thread Bruno Pusztahazi (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bruno Pusztahazi updated HIVE-21366:

Status: Open  (was: Patch Available)

> Inconsistent behavior of ROUND() with integer in string as argument
> ---
>
> Key: HIVE-21366
> URL: https://issues.apache.org/jira/browse/HIVE-21366
> Project: Hive
>  Issue Type: Bug
>Reporter: Sergey Yavorski
>Assignee: Bruno Pusztahazi
>Priority: Major
> Attachments: HIVE-21366.1.patch, HIVE-21366.2.patch
>
>
> hive> SELECT ROUND('1',4) AS r_str, ROUND(1,4) AS r_num;
> OK
> r_str   r_num
> *{color:#FF}1.0{color}* 1



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21366) Inconsistent behavior of ROUND() with integer in string as argument

2019-04-18 Thread Bruno Pusztahazi (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bruno Pusztahazi updated HIVE-21366:

Attachment: HIVE-21366.2.patch

> Inconsistent behavior of ROUND() with integer in string as argument
> ---
>
> Key: HIVE-21366
> URL: https://issues.apache.org/jira/browse/HIVE-21366
> Project: Hive
>  Issue Type: Bug
>Reporter: Sergey Yavorski
>Assignee: Bruno Pusztahazi
>Priority: Major
> Attachments: HIVE-21366.1.patch, HIVE-21366.2.patch
>
>
> hive> SELECT ROUND('1',4) AS r_str, ROUND(1,4) AS r_num;
> OK
> r_str   r_num
> *{color:#FF}1.0{color}* 1



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (HIVE-21366) Inconsistent behavior of ROUND() with integer in string as argument

2019-04-18 Thread Bruno Pusztahazi (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bruno Pusztahazi updated HIVE-21366:

Status: Patch Available  (was: Open)

> Inconsistent behavior of ROUND() with integer in string as argument
> ---
>
> Key: HIVE-21366
> URL: https://issues.apache.org/jira/browse/HIVE-21366
> Project: Hive
>  Issue Type: Bug
>Reporter: Sergey Yavorski
>Assignee: Bruno Pusztahazi
>Priority: Major
> Attachments: HIVE-21366.1.patch, HIVE-21366.2.patch
>
>
> hive> SELECT ROUND('1',4) AS r_str, ROUND(1,4) AS r_num;
> OK
> r_str   r_num
> *{color:#FF}1.0{color}* 1



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)