[jira] [Commented] (HIVE-13130) HS2 changes : API calls for retrieving primary keys and foreign keys information

[Hari Sankar Sivarama Subramaniyan (JIRA)]

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

Hari Sankar Sivarama Subramaniyan commented on HIVE-13130:
--

Did the tests locally and confirmed that there are no issues. Sample outputs 
from the tests:
{code}
Tests run: 3404, Failures: 0, Errors: 0, Skipped: 2
{code}
I am attaching the results  as an attachment.

The jira is in commit stage.

Thanks
Hari

>  HS2 changes : API calls for retrieving primary keys and foreign keys 
> information
> -
>
> Key: HIVE-13130
> URL: https://issues.apache.org/jira/browse/HIVE-13130
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Hari Sankar Sivarama Subramaniyan
>Assignee: Hari Sankar Sivarama Subramaniyan
> Attachments: HIVE-13130.1.patch, HIVE-13130.2.patch, 
> HIVE-13130.3.patch, HIVE-13130.4.patch, HIVE-13130.5.patch, 
> HIVE-13130.5.patch, HIVE-13130.6.patch, test-results.txt
>
>
> ODBC exposes the SQLPrimaryKeys and SQLForeignKeys API calls and JDBC exposes 
> getPrimaryKeys and getCrossReference API calls. We need to provide these 
> interfaces as part of PK/FK implementation in Hive.



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

[jira] [Commented] (HIVE-13130) HS2 changes : API calls for retrieving primary keys and foreign keys information

[Ashutosh Chauhan (JIRA)]

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

Ashutosh Chauhan commented on HIVE-13130:
-

+1 pending tests

>  HS2 changes : API calls for retrieving primary keys and foreign keys 
> information
> -
>
> Key: HIVE-13130
> URL: https://issues.apache.org/jira/browse/HIVE-13130
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Hari Sankar Sivarama Subramaniyan
>Assignee: Hari Sankar Sivarama Subramaniyan
> Attachments: HIVE-13130.1.patch, HIVE-13130.2.patch, 
> HIVE-13130.3.patch, HIVE-13130.4.patch, HIVE-13130.5.patch
>
>
> ODBC exposes the SQLPrimaryKeys and SQLForeignKeys API calls and JDBC exposes 
> getPrimaryKeys and getCrossReference API calls. We need to provide these 
> interfaces as part of PK/FK implementation in Hive.



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

[jira] [Commented] (HIVE-13130) HS2 changes : API calls for retrieving primary keys and foreign keys information

[Hive QA (JIRA)]

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

Hive QA commented on HIVE-13130:




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

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

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7439/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7439/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-7439/

Messages:
{noformat}
 This message was trimmed, see log for full details 
[ERROR] location: interface 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncIface
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[112,35]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: interface 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncIface
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[405,47]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[405,12]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[411,37]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[418,12]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[428,53]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[428,12]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[434,40]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[441,12]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1005,32]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1037,35]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1013,15]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient.GetPrimaryKeys_call
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1014,34]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient.GetPrimaryKeys_call
[ERROR] 

[jira] [Commented] (HIVE-13130) HS2 changes : API calls for retrieving primary keys and foreign keys information

[Hive QA (JIRA)]

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

Hive QA commented on HIVE-13130:




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

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

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

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-METASTORE-Test/133/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-METASTORE-Test/133/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-METASTORE-Test-133/

Messages:
{noformat}
LXC derby found.
LXC derby is not started. Starting container...
Container started.
Preparing derby container...
Container prepared.
Calling /hive/testutils/metastore/dbs/derby/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/derby/execute.sh ...
Tests executed.
LXC mysql found.
LXC mysql is not started. Starting container...
Container started.
Preparing mysql container...
Container prepared.
Calling /hive/testutils/metastore/dbs/mysql/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/mysql/execute.sh ...
Tests executed.
LXC oracle found.
LXC oracle is not started. Starting container...
Container started.
Preparing oracle container...
Container prepared.
Calling /hive/testutils/metastore/dbs/oracle/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/oracle/execute.sh ...
Tests executed.
LXC postgres found.
LXC postgres is not started. Starting container...
Container started.
Preparing postgres container...
Container prepared.
Calling /hive/testutils/metastore/dbs/postgres/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/postgres/execute.sh ...
Tests executed.
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12796188 - PreCommit-HIVE-METASTORE-Test

>  HS2 changes : API calls for retrieving primary keys and foreign keys 
> information
> -
>
> Key: HIVE-13130
> URL: https://issues.apache.org/jira/browse/HIVE-13130
> Project: Hive
>  Issue Type: Sub-task
>Reporter: Hari Sankar Sivarama Subramaniyan
>Assignee: Hari Sankar Sivarama Subramaniyan
> Attachments: HIVE-13130.1.patch, HIVE-13130.2.patch, 
> HIVE-13130.3.patch, HIVE-13130.4.patch, HIVE-13290.4.patch
>
>
> ODBC exposes the SQLPrimaryKeys and SQLForeignKeys API calls and JDBC exposes 
> getPrimaryKeys and getCrossReference API calls. We need to provide these 
> interfaces as part of PK/FK implementation in Hive.



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

[jira] [Commented] (HIVE-13130) HS2 changes : API calls for retrieving primary keys and foreign keys information

[Hive QA (JIRA)]

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

Hive QA commented on HIVE-13130:




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

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

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7415/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7415/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-7415/

Messages:
{noformat}
 This message was trimmed, see log for full details 
[ERROR] location: interface 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncIface
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[112,35]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: interface 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncIface
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[405,47]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[405,12]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[411,37]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[418,12]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[428,53]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[428,12]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[434,40]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[441,12]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceResp
[ERROR] location: class org.apache.hive.service.rpc.thrift.TCLIService.Client
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1005,32]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1037,35]
 cannot find symbol
[ERROR] symbol:   class TGetCrossReferenceReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1013,15]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient.GetPrimaryKeys_call
[ERROR] 
/data/hive-ptest/working/apache-github-source-source/service-rpc/src/gen/thrift/gen-javabean/org/apache/hive/service/rpc/thrift/TCLIService.java:[1014,34]
 cannot find symbol
[ERROR] symbol:   class TGetPrimaryKeysReq
[ERROR] location: class 
org.apache.hive.service.rpc.thrift.TCLIService.AsyncClient.GetPrimaryKeys_call
[ERROR]