[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-09-17 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:




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

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

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

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

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: 12980476 - PreCommit-HIVE-Build

> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch, HIVE-21875.04.patch, HIVE-21875.05.patch, 
> HIVE-21875.06.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, PartitionDropOptions options);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> boolean dropPartition(String db_name, String tbl_name, String name, boolean 
> deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, String 
> name, boolean deleteData){code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)


[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-09-17 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:


| (/) *{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  
5s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
13s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
32s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
55s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  1m 
11s{color} | {color:blue} standalone-metastore/metastore-server in master has 
178 extant Findbugs warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
4s{color} | {color:blue} ql in master has 1572 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
22s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue}  0m 
26s{color} | {color:blue} Maven dependency ordering for patch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
58s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
32s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m 
32s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
17s{color} | {color:green} standalone-metastore/metastore-server: 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 
40s{color} | {color:green} The patch ql 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}  5m 
29s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
19s{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} 30m 56s{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-18621/dev-support/hive-personality.sh
 |
| git revision | master / 8055650 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: standalone-metastore/metastore-server ql U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18621/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch, HIVE-21875.04.patch, HIVE-21875.05.patch, 
> HIVE-21875.06.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> 

[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-09-16 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:




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

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

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

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Tests exited with: Exception: Patch URL 
https://issues.apache.org/jira/secure/attachment/12980417/HIVE-21875.05.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: 12980417 - PreCommit-HIVE-Build

> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch, HIVE-21875.04.patch, HIVE-21875.05.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, PartitionDropOptions options);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> boolean dropPartition(String db_name, String tbl_name, String name, boolean 
> deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, String 
> name, boolean deleteData){code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)


[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-09-16 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:




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

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

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

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

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: 12980417 - PreCommit-HIVE-Build

> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch, HIVE-21875.04.patch, HIVE-21875.05.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, PartitionDropOptions options);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> boolean dropPartition(String db_name, String tbl_name, String name, boolean 
> deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, String 
> name, boolean deleteData){code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)


[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-09-16 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:


| (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 
45s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
28s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
35s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
58s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  1m 
11s{color} | {color:blue} standalone-metastore/metastore-server in master has 
178 extant Findbugs warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m 
13s{color} | {color:blue} ql in master has 1573 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
20s{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}  2m 
 2s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
35s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m 
35s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
18s{color} | {color:green} standalone-metastore/metastore-server: The patch 
generated 0 new + 1 unchanged - 1 fixed = 1 total (was 2) {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
41s{color} | {color:red} ql: The patch generated 2 new + 17 unchanged - 0 fixed 
= 19 total (was 17) {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 
47s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
25s{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} 31m 44s{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-18614/dev-support/hive-personality.sh
 |
| git revision | master / 1880bc6 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18614/yetus/diff-checkstyle-ql.txt
 |
| modules | C: standalone-metastore/metastore-server ql U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18614/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch, HIVE-21875.04.patch, HIVE-21875.05.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 

[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-08-26 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:




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

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

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

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

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: 12978593 - PreCommit-HIVE-Build

> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, PartitionDropOptions options);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> boolean dropPartition(String db_name, String tbl_name, String name, boolean 
> deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, String 
> name, boolean deleteData){code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)


[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-08-26 Thread Hive QA (Jira)


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

Hive QA commented on HIVE-21875:


| (/) *{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}  2m  
0s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
29s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
37s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
58s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  1m 
12s{color} | {color:blue} standalone-metastore/metastore-server in master has 
181 extant Findbugs warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m 
10s{color} | {color:blue} ql in master has 2254 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
22s{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}  2m 
 2s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
38s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m 
38s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
19s{color} | {color:green} standalone-metastore/metastore-server: 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 
40s{color} | {color:green} The patch ql 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}  5m 
42s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
24s{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} 32m  6s{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-18396/dev-support/hive-personality.sh
 |
| git revision | master / ece9a54 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: standalone-metastore/metastore-server ql U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18396/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch, 
> HIVE-21875.03.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String 

[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-08-06 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21875:




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

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

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

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

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: 12976796 - PreCommit-HIVE-Build

> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, PartitionDropOptions options);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists, boolean needResults);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, PartitionDropOptions options);
> boolean dropPartition(String db_name, String tbl_name, String name, boolean 
> deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, String 
> name, boolean deleteData){code}



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)


[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-08-06 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21875:


| (/) *{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 
40s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
11s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
35s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
58s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  1m 
15s{color} | {color:blue} standalone-metastore/metastore-server in master has 
180 extant Findbugs warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
8s{color} | {color:blue} ql in master has 2250 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
20s{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}  1m 
56s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
35s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m 
35s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
19s{color} | {color:green} standalone-metastore/metastore-server: 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 
42s{color} | {color:green} The patch ql 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}  5m 
46s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
21s{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} 31m 15s{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-18273/dev-support/hive-personality.sh
 |
| git revision | master / 5737095 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: standalone-metastore/metastore-server ql U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18273/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch, HIVE-21875.02.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, 

[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-08-05 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21875:




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

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

{color:red}ERROR:{color} -1 due to 23 failed/errored test(s), 16795 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[repl_1_drop] (batchId=13)
org.apache.hadoop.hive.ql.metadata.TestHive.testAutoPurgeTablesAndPartitions 
(batchId=329)
org.apache.hadoop.hive.ql.metadata.TestHive.testDropPartitionsWithPurge 
(batchId=329)
org.apache.hadoop.hive.ql.metadata.TestHiveRemote.testAutoPurgeTablesAndPartitions
 (batchId=330)
org.apache.hadoop.hive.ql.metadata.TestHiveRemote.testDropPartitionsWithPurge 
(batchId=330)
org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testIncrementalReplWithEventsBatchHavingDropCreateTable
 (batchId=259)
org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testReplLoadFromSourceUsingWithClause
 (batchId=259)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testDropPartitionEventWithPartitionOnTimestampColumn
 (batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testDrops 
(batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testDropsWithCM 
(batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testExchangePartition
 (batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testIncrementalRepeatEventOnMissingObject
 (batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testStatus 
(batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testWithStringPartitionSpecialChars
 (batchId=251)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDropPartitionEventWithPartitionOnTimestampColumn
 (batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDrops (batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDropsWithCM 
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testExchangePartition 
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalRepeatEventOnMissingObject
 (batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testStatus 
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testWithStringPartitionSpecialChars
 (batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testIncrementalReplWithEventsBatchHavingDropCreateTable
 (batchId=263)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testReplLoadFromSourceUsingWithClause
 (batchId=263)
{noformat}

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

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: 23 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12976695 - PreCommit-HIVE-Build

> Implement drop partition related methods on temporary tables
> 
>
> Key: HIVE-21875
> URL: https://issues.apache.org/jira/browse/HIVE-21875
> Project: Hive
>  Issue Type: Sub-task
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Attachments: HIVE-21875.01.patch
>
>
> IMetaStoreClient exposes the following methods related to dropping partitions:
> {code:java}
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, boolean deleteData);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, boolean deleteData);
> boolean dropPartition(String db_name, String tbl_name, List 
> part_vals, PartitionDropOptions options);
> boolean dropPartition(String catName, String db_name, String tbl_name, 
> List part_vals, PartitionDropOptions options);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String catName, String dbName, String tblName, 
> List> partExprs, boolean deleteData, boolean 
> ifExists);
> List dropPartitions(String dbName, String tblName, 
> List> partExprs, 

[jira] [Commented] (HIVE-21875) Implement drop partition related methods on temporary tables

2019-08-05 Thread Hive QA (JIRA)


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

Hive QA commented on HIVE-21875:


| (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 
38s{color} | {color:blue} Maven dependency ordering for branch {color} |
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
14s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
34s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
59s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  1m 
11s{color} | {color:blue} standalone-metastore/metastore-server in master has 
180 extant Findbugs warnings. {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
7s{color} | {color:blue} ql in master has 2250 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
19s{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 
59s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
36s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m 
36s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
19s{color} | {color:green} standalone-metastore/metastore-server: The patch 
generated 0 new + 1 unchanged - 1 fixed = 1 total (was 2) {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red}  0m 
40s{color} | {color:red} ql: The patch generated 2 new + 15 unchanged - 0 fixed 
= 17 total (was 15) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:red}-1{color} | {color:red} findbugs {color} | {color:red}  4m 
18s{color} | {color:red} ql generated 1 new + 2250 unchanged - 0 fixed = 2251 
total (was 2250) {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m 
20s{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} 31m  6s{color} | 
{color:black} {color} |
\\
\\
|| Reason || Tests ||
| FindBugs | module:ql |
|  |  Null passed for non-null parameter of getPartitionedTempTable(Table) in 
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.dropPartition(String,
 String, String, String, boolean)  Method invoked at 
SessionHiveMetaStoreClient.java:of getPartitionedTempTable(Table) in 
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.dropPartition(String,
 String, String, String, boolean)  Method invoked at 
SessionHiveMetaStoreClient.java:[line 1553] |
\\
\\
|| 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-18257/dev-support/hive-personality.sh
 |
| git revision | master / 212b428 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18257/yetus/diff-checkstyle-ql.txt
 |
| findbugs | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18257/yetus/new-findbugs-ql.html
 |
| modules | C: standalone-metastore/metastore-server ql U: . |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-18257/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Implement drop partition related methods on temporary tables
> 
>
> Key: