[ https://issues.apache.org/jira/browse/HIVE-25540?focusedWorklogId=662615&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-662615 ]
ASF GitHub Bot logged work on HIVE-25540: ----------------------------------------- Author: ASF GitHub Bot Created on: 08/Oct/21 09:07 Start Date: 08/Oct/21 09:07 Worklog Time Spent: 10m Work Description: deniskuzZ commented on pull request #2657: URL: https://github.com/apache/hive/pull/2657#issuecomment-938477954 > I would guess that the Derby is also covered by the unit tests. > > Maybe it would be better to test with other databases unless we know there are some known issues which are hard to mitigate. The best would be to add an appropriate test to the [TestHiveMetastore.java](https://github.com/apache/hive/blob/07464b12ada011f13546b3d5d37276b76218416c/standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java) > > I see a [testColumnStatistics](https://github.com/apache/hive/blob/07464b12ada011f13546b3d5d37276b76218416c/standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java#L1674) method. This might be the one that we need, and we only have to run the tests against a cluster like described here: See: https://cwiki.apache.org/confluence/display/Hive/MetaStore+API+tests#MetaStoreAPITests-IMetaStoreClientTests > > You can use Docker images defined here to set up the db to test agains: https://github.com/apache/hive/blob/master/standalone-metastore/DEV-README > > @deniskuzZ: Is there a faster way to test out the changes against multiple databases? > > Thanks, Peter use ITestDbTxnManager: ```` mvn test -Dtest=ITestDbTxnManager -Dtest.metastore.db=mysql -Ditest.jdbc.jars=mysql-connector-java-5.1.49.jar mvn test -Dtest=ITestDbTxnManager -Dtest.metastore.db=postgres -Ditest.jdbc.jars=postgresql-42.2.23.jar mvn test -Dtest=ITestDbTxnManager -Dtest.metastore.db=oracle -Ditest.jdbc.jars=ojdbc8.jar ```` -- 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. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 662615) Time Spent: 0.5h (was: 20m) > Enable batch update of column stats only for MySql and Postgres > ---------------------------------------------------------------- > > Key: HIVE-25540 > URL: https://issues.apache.org/jira/browse/HIVE-25540 > Project: Hive > Issue Type: Sub-task > Reporter: mahesh kumar behera > Assignee: mahesh kumar behera > Priority: Major > Labels: pull-request-available > Time Spent: 0.5h > Remaining Estimate: 0h > > The batch updation of partition column stats using direct sql is tested only > for MySql and Postgres. -- This message was sent by Atlassian Jira (v8.3.4#803005)