[GitHub] [hive] ashish-kumar-sharma edited a comment on pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma edited a comment on pull request #2211:
URL: https://github.com/apache/hive/pull/2211#issuecomment-830789617


   @kishendas  Can you please review the PR


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] wangyum opened a new pull request #2251: HIVE-21563: Improve Table#getEmptyTable performance by disabling registerAllFunctionsOnce

2021-05-05 Thread GitBox


wangyum opened a new pull request #2251:
URL: https://github.com/apache/hive/pull/2251


   ### What changes were proposed in this pull request?
   
   Improve `Table#getEmptyTable` performance by disabling 
`registerAllFunctionsOnce`.
   
   ### Why are the changes needed?
   
   `Table#getEmptyTable` do not need `registerAllFunctionsOnce` . The stack 
trace:
   ```java
 at 
org.apache.hadoop.hive.ql.exec.Registry.registerGenericUDF(Registry.java:177)
 at 
org.apache.hadoop.hive.ql.exec.Registry.registerGenericUDF(Registry.java:170)
 at 
org.apache.hadoop.hive.ql.exec.FunctionRegistry.(FunctionRegistry.java:209)
 at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:247)
 at 
org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:231)
 at org.apache.hadoop.hive.ql.metadata.Hive.(Hive.java:388)
 at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:332)
 at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:312)
 at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:288)
 at 
org.apache.hadoop.hive.ql.session.SessionState.setAuthorizerV2Config(SessionState.java:913)
 at 
org.apache.hadoop.hive.ql.session.SessionState.setupAuth(SessionState.java:877)
 at 
org.apache.hadoop.hive.ql.session.SessionState.getAuthenticator(SessionState.java:1479)
 at 
org.apache.hadoop.hive.ql.session.SessionState.getUserFromAuthenticator(SessionState.java:1150)
 at org.apache.hadoop.hive.ql.metadata.Table.getEmptyTable(Table.java:180)
   ```
   
   ### Does this PR introduce _any_ user-facing change?
   
   No.
   
   
   ### How was this patch tested?
   
   Existing test.
   


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] wangyum commented on pull request #2251: HIVE-21563: Improve Table#getEmptyTable performance by disabling registerAllFunctionsOnce

2021-05-05 Thread GitBox


wangyum commented on pull request #2251:
URL: https://github.com/apache/hive/pull/2251#issuecomment-833144629


   cc @sunchao 


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626336640



##
File path: ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java
##
@@ -777,13 +777,14 @@ public ValidTxnList getValidTxns(List 
excludeTxnTypes) throws LockExcep
   public ValidTxnWriteIdList getValidWriteIds(List tableList,
   String validTxnList) throws 
LockException {
 assert isTxnOpen();
-assert validTxnList != null && !validTxnList.isEmpty();
-try {
-  return TxnCommonUtils.createValidTxnWriteIdList(
-  txnId, getMS().getValidWriteIds(tableList, validTxnList));
-} catch (TException e) {
-  throw new 
LockException(ErrorMsg.METASTORE_COMMUNICATION_FAILED.getMsg(), e);
+if (!StringUtils.isEmpty(validTxnList)) {

Review comment:
   When ever validTxnList is null Assert will return false and break the 
entire execution loop. Due to which 40 odd UTs are failing. Hence I have to 
replace the assert check to simple null check to get the green build.
   for list of test failing please check - 
http://ci.hive.apache.org/blue/organizations/jenkins/hive-precommit/detail/PR-2211/7/tests




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626393549



##
File path: 
standalone-metastore/metastore-common/src/main/thrift/hive_metastore.thrift
##
@@ -740,7 +752,9 @@ struct CheckConstraintsResponse {
 struct AllTableConstraintsRequest {
   1: required string dbName,
   2: required string tblName,
-  3: required string catName
+  3: required string catName,
+  4: optional string validWriteIdList,
+  5: optional i64 tableId=-1 // table id

Review comment:
   Done




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626394973



##
File path: ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
##
@@ -5838,10 +5838,20 @@ public void dropConstraint(String dbName, String 
tableName, String constraintNam
 }
   }
 
-  public SQLAllTableConstraints getTableConstraints(String dbName, String 
tblName)
+  public SQLAllTableConstraints getTableConstraints(String dbName, String 
tblName, long tableId)
   throws HiveException, NoSuchObjectException {
 try {
-  return getMSC().getAllTableConstraints(new 
AllTableConstraintsRequest(dbName, tblName, getDefaultCatalog(conf)));
+
+  ValidWriteIdList validWriteIdList = null;

Review comment:
   Make sense. Actually there already exist a method created by you for 
same. I will replace this code with getValidWriteIdList(String dbName, String 
tableName).




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626395557



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/RawStore.java
##
@@ -1572,9 +1579,20 @@ void getFileMetadataByExpr(List fileIds, 
FileMetadataExprType type, byte[]
* @return list of primary key columns or an empty list if the table does 
not have a primary key
* @throws MetaException error accessing the RDBMS
*/
+  @Deprecated
   List getPrimaryKeys(String catName, String db_name, String 
tbl_name)
   throws MetaException;
 
+  /**
+   * Get the primary associated with a table.  Strangely enough each 
SQLPrimaryKey is actually a

Review comment:
   Right. I will keep in mind.




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626395244



##
File path: 
standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.java
##
@@ -1230,7 +1230,7 @@ public void createTable(Table tbl, EnvironmentContext 
envContext) throws Already
 boolean success = false;
 try {
   // Subclasses can override this step (for example, for temporary tables)
-  create_table_with_environment_context(tbl, envContext);
+   create_table_with_environment_context(tbl, envContext);

Review comment:
   Sure. I will keep in mind. Removed as of now.




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626396870



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/cache/CachedStore.java
##
@@ -2584,57 +2584,89 @@ long getPartsFound() {
   }
 
   @Override
+  @Deprecated
   public List getPrimaryKeys(String catName, String dbName, 
String tblName) throws MetaException {
-catName = StringUtils.normalizeIdentifier(catName);
-dbName = StringUtils.normalizeIdentifier(dbName);
-tblName = StringUtils.normalizeIdentifier(tblName);
+PrimaryKeysRequest request = new PrimaryKeysRequest(dbName, tblName);
+request.setCatName(catName);
+return getPrimaryKeys(request);
+  }
+
+  @Override
+  public List getPrimaryKeys(PrimaryKeysRequest request) throws 
MetaException {
+String catName = StringUtils.normalizeIdentifier(request.getCatName());
+String dbName = StringUtils.normalizeIdentifier(request.getDb_name());
+String tblName = StringUtils.normalizeIdentifier(request.getTbl_name());
 if (shouldGetConstraintFromRawStore(catName, dbName, tblName)) {
-  return rawStore.getPrimaryKeys(catName, dbName, tblName);
+  return rawStore.getPrimaryKeys(request);
 }
 return sharedCache.listCachedPrimaryKeys(catName, dbName, tblName);
   }
 
   @Override
+  @Deprecated
   public List getForeignKeys(String catName, String 
parentDbName, String parentTblName,
   String foreignDbName, String foreignTblName) throws MetaException {
+ForeignKeysRequest request = new ForeignKeysRequest(parentDbName, 
parentTblName, foreignDbName, foreignTblName);
+request.setCatName(catName);
+return getForeignKeys(request);
+  }
+
+  @Override
+  public List getForeignKeys(ForeignKeysRequest request) throws 
MetaException {
 // Get correct ForeignDBName and TableName
-if (StringUtils.isEmpty(foreignDbName) || 
StringUtils.isEmpty(foreignTblName) || StringUtils.isEmpty(parentDbName)
-|| StringUtils.isEmpty(parentTblName)) {
-  return rawStore.getForeignKeys(catName, parentDbName, parentTblName, 
foreignDbName, foreignTblName);
+if (StringUtils.isEmpty(request.getParent_db_name()) || 
StringUtils.isEmpty(request.getParent_tbl_name())
+|| StringUtils.isEmpty(request.getForeign_db_name()) || 
StringUtils.isEmpty(request.getForeign_tbl_name())) {
+  return rawStore.getForeignKeys(request);
 }
 
-catName = StringUtils.normalizeIdentifier(catName);
-foreignDbName = StringUtils.normalizeIdentifier(foreignDbName);
-foreignTblName = StringUtils.normalizeIdentifier(foreignTblName);
-parentDbName = StringUtils.isEmpty(parentDbName) ? "" : 
normalizeIdentifier(parentDbName);
-parentTblName = StringUtils.isEmpty(parentTblName) ? "" : 
StringUtils.normalizeIdentifier(parentTblName);
+String catName = StringUtils.normalizeIdentifier(request.getCatName());
+String foreignDbName = 
StringUtils.normalizeIdentifier(request.getForeign_db_name());
+String foreignTblName = 
StringUtils.normalizeIdentifier(request.getForeign_tbl_name());
+String parentDbName =
+StringUtils.isEmpty(request.getParent_db_name()) ? "" : 
normalizeIdentifier(request.getParent_db_name());
+String parentTblName = StringUtils.isEmpty(request.getParent_tbl_name()) ? 
"" : StringUtils
+.normalizeIdentifier(request.getParent_tbl_name());
 
 if (shouldGetConstraintFromRawStore(catName, foreignDbName, 
foreignTblName)) {
-  return rawStore.getForeignKeys(catName, parentDbName, parentTblName, 
foreignDbName, foreignTblName);
+  return rawStore.getForeignKeys(request);
 }
 return sharedCache.listCachedForeignKeys(catName, foreignDbName, 
foreignTblName, parentDbName, parentTblName);
   }
 
   @Override
+  @Deprecated
   public List getUniqueConstraints(String catName, String 
dbName, String tblName)
   throws MetaException {
-catName = StringUtils.normalizeIdentifier(catName);
-dbName = StringUtils.normalizeIdentifier(dbName);
-tblName = StringUtils.normalizeIdentifier(tblName);
+UniqueConstraintsRequest request = new UniqueConstraintsRequest(catName, 
dbName, tblName);
+return getUniqueConstraints(request);
+  }
+
+  @Override
+  public List 
getUniqueConstraints(UniqueConstraintsRequest request) throws MetaException {
+String catName = StringUtils.normalizeIdentifier(request.getCatName());
+String dbName = StringUtils.normalizeIdentifier(request.getDb_name());
+String tblName = StringUtils.normalizeIdentifier(request.getTbl_name());
 if (shouldGetConstraintFromRawStore(catName, dbName, tblName)) {
-  return rawStore.getUniqueConstraints(catName, dbName, tblName);
+  return rawStore.getUniqueConstraints(request);
 }
 return sharedCache.listCachedUniqueConstraint(catName, dbName, tblName);
   }
 
   @Override
+  @Deprecated
   public List getNotNullConstraints(String catName, 

[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626396989



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/RawStore.java
##
@@ -1588,10 +1606,22 @@ void getFileMetadataByExpr(List fileIds, 
FileMetadataExprType type, byte[]
* matches the arguments the results here will be all mixed together into a 
single list.
* @throws MetaException error access the RDBMS.
*/
+  @Deprecated
   List getForeignKeys(String catName, String parent_db_name,
 String parent_tbl_name, String foreign_db_name, String foreign_tbl_name)
 throws MetaException;
 
+  /**
+   * Get the foreign keys for a table.  All foreign keys for a particular 
table can be fetched by
+   * passing null for the last two arguments.

Review comment:
   Done




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626394008



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/HMSHandler.java
##
@@ -9479,43 +9479,38 @@ void updateMetrics() throws MetaException {
 
   @Override
   public PrimaryKeysResponse get_primary_keys(PrimaryKeysRequest request) 
throws TException {
-String catName = request.isSetCatName() ? request.getCatName() : 
getDefaultCatalog(conf);
-String db_name = request.getDb_name();
-String tbl_name = request.getTbl_name();
-startTableFunction("get_primary_keys", catName, db_name, tbl_name);
+if (!request.isSetCatName())

Review comment:
   Sure. For now I have replaced it with conditional operator.




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on pull request #2211:
URL: https://github.com/apache/hive/pull/2211#issuecomment-832539913


   > Where are the tests to ensure that we are sending tableId and 
validWriteIdList to get constraint APIs ?
   
   This PR is more around changing signature of various method and send table 
Id to metastore. I am waiting for https://github.com/apache/hive/pull/2128 to 
get merge. After that I can put a check of tableId and validwriteId in 
metastore and write all test cases around that. 


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626395719



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/HMSHandler.java
##
@@ -9479,43 +9479,38 @@ void updateMetrics() throws MetaException {
 
   @Override
   public PrimaryKeysResponse get_primary_keys(PrimaryKeysRequest request) 
throws TException {
-String catName = request.isSetCatName() ? request.getCatName() : 
getDefaultCatalog(conf);
-String db_name = request.getDb_name();
-String tbl_name = request.getTbl_name();
-startTableFunction("get_primary_keys", catName, db_name, tbl_name);
+if (!request.isSetCatName())
+  request.setCatName(getDefaultCatalog(conf));
+startTableFunction("get_primary_keys", request.getCatName(), 
request.getDb_name(), request.getTbl_name());
 List ret = null;
 Exception ex = null;
 try {
-  ret = getMS().getPrimaryKeys(catName, db_name, tbl_name);
+  ret = getMS().getPrimaryKeys(request);
 } catch (Exception e) {
   ex = e;
   throwMetaException(e);
 } finally {
-  endFunction("get_primary_keys", ret != null, ex, tbl_name);
+  endFunction("get_primary_keys", ret != null, ex, request.getTbl_name());
 }
 return new PrimaryKeysResponse(ret);
   }
 
   @Override
   public ForeignKeysResponse get_foreign_keys(ForeignKeysRequest request) 
throws TException {
-String catName = request.isSetCatName() ? request.getCatName() : 
getDefaultCatalog(conf);
-String parent_db_name = request.getParent_db_name();
-String parent_tbl_name = request.getParent_tbl_name();
-String foreign_db_name = request.getForeign_db_name();
-String foreign_tbl_name = request.getForeign_tbl_name();
-startFunction("get_foreign_keys", " : parentdb=" + parent_db_name +
-" parenttbl=" + parent_tbl_name + " foreigndb=" + foreign_db_name +
-" foreigntbl=" + foreign_tbl_name);
+if (!request.isSetCatName())

Review comment:
   Done

##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/HMSHandler.java
##
@@ -9532,93 +9527,85 @@ private void throwMetaException(Exception e) throws 
MetaException,
   }
 
   @Override
-  public UniqueConstraintsResponse 
get_unique_constraints(UniqueConstraintsRequest request)
-  throws TException {
-String catName = request.isSetCatName() ? request.getCatName() : 
getDefaultCatalog(conf);
-String db_name = request.getDb_name();
-String tbl_name = request.getTbl_name();
-startTableFunction("get_unique_constraints", catName, db_name, tbl_name);
+  public UniqueConstraintsResponse 
get_unique_constraints(UniqueConstraintsRequest request) throws TException {
+if (!request.isSetCatName())

Review comment:
   Done




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on pull request #2211:
URL: https://github.com/apache/hive/pull/2211#issuecomment-832540166


   > Sending ValidWriteIdList and tableId as part of get_*_constraints HMS api 
to validate _whether_ data stored in HMS cached Store is stale or latest. ( You 
don't need a ? at the end )
   
   Latest and complete changes.


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626411104



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/ObjectStore.java
##
@@ -11978,8 +12027,26 @@ private String getPrimaryKeyConstraintName(String 
catName, String dbName, String
* @throws MetaException
*/
   @Override
+  @Deprecated
   public SQLAllTableConstraints getAllTableConstraints(String catName, String 
dbName, String tblName)
   throws MetaException,NoSuchObjectException {
+AllTableConstraintsRequest request = new 
AllTableConstraintsRequest(dbName,tblName,catName);
+return getAllTableConstraints(request);
+  }
+
+  /**
+   * Api to fetch all constraints at once
+   * @param tableConstraintsRequest request object
+   * @return all table constraints
+   * @throws MetaException
+   * @throws NoSuchObjectException
+   */
+  @Override
+  public SQLAllTableConstraints 
getAllTableConstraints(AllTableConstraintsRequest tableConstraintsRequest)
+  throws MetaException, NoSuchObjectException {
+String catName = tableConstraintsRequest.getCatName();

Review comment:
   done




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] ashish-kumar-sharma commented on a change in pull request #2211: HIVE-23931: Send ValidWriteIdList and tableId to get_*_constraints HMS APIs

2021-05-05 Thread GitBox


ashish-kumar-sharma commented on a change in pull request #2211:
URL: https://github.com/apache/hive/pull/2211#discussion_r626411212



##
File path: 
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/ObjectStore.java
##
@@ -11565,11 +11579,21 @@ private String getPrimaryKeyConstraintName(String 
catName, String dbName, String
}
 
   @Override
-  public List getForeignKeys(String catName, String 
parent_db_name,
-String parent_tbl_name, String foreign_db_name, String foreign_tbl_name) 
throws MetaException {
+  public List getForeignKeys(String catName, String 
parent_db_name, String parent_tbl_name,
+  String foreign_db_name, String foreign_tbl_name) throws MetaException {
+ForeignKeysRequest request =
+new ForeignKeysRequest(parent_db_name, parent_tbl_name, 
foreign_db_name, foreign_tbl_name);

Review comment:
   Can you given an example?




-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] scarlin-cloudera opened a new pull request #2250: HIVE-23756: Add foreign keys to jdo file

2021-05-05 Thread GitBox


scarlin-cloudera opened a new pull request #2250:
URL: https://github.com/apache/hive/pull/2250


   
   
   ### What changes were proposed in this pull request?
   
   
   
   ### Why are the changes needed?
   
   
   
   ### Does this PR introduce _any_ user-facing change?
   
   
   
   ### How was this patch tested?
   
   


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org



[GitHub] [hive] scarlin-cloudera closed pull request #2250: HIVE-23756: Add foreign keys to jdo file

2021-05-05 Thread GitBox


scarlin-cloudera closed pull request #2250:
URL: https://github.com/apache/hive/pull/2250


   


-- 
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



-
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org