[ https://issues.apache.org/jira/browse/HIVE-25276?focusedWorklogId=614593&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-614593 ]
ASF GitHub Bot logged work on HIVE-25276: ----------------------------------------- Author: ASF GitHub Bot Created on: 24/Jun/21 16:05 Start Date: 24/Jun/21 16:05 Worklog Time Spent: 10m Work Description: pvary commented on a change in pull request #2419: URL: https://github.com/apache/hive/pull/2419#discussion_r658085550 ########## File path: iceberg/iceberg-handler/src/test/java/org/apache/iceberg/mr/hive/TestHiveIcebergStorageHandlerWithEngine.java ########## @@ -1314,6 +1314,85 @@ public void testScanTableCaseInsensitive() throws IOException { Assert.assertArrayEquals(new Object[] {1L, "Bob", "Green"}, rows.get(1)); } + @Test + public void testStatWithInsert() { + TableIdentifier identifier = TableIdentifier.of("default", "customers"); + + shell.setHiveSessionValue(HiveConf.ConfVars.HIVESTATSAUTOGATHER.varname, true); + testTables.createTable(shell, identifier.name(), HiveIcebergStorageHandlerTestUtils.CUSTOMER_SCHEMA, + PartitionSpec.unpartitioned(), fileFormat, ImmutableList.of()); + + if (testTableType != TestTables.TestTableType.HIVE_CATALOG) { + // If the location is set and we have to gather stats, then we have to update the table stats now + shell.executeStatement("ANALYZE TABLE " + identifier + " COMPUTE STATISTICS FOR COLUMNS"); + } + + String insert = testTables.getInsertQuery(HiveIcebergStorageHandlerTestUtils.CUSTOMER_RECORDS, identifier, false); + shell.executeStatement(insert); + + checkColStat(identifier.name(), "customer_id"); + } + + @Test + public void testStatWithInsertOverwrite() { + TableIdentifier identifier = TableIdentifier.of("default", "customers"); + + shell.setHiveSessionValue(HiveConf.ConfVars.HIVESTATSAUTOGATHER.varname, true); + testTables.createTable(shell, identifier.name(), HiveIcebergStorageHandlerTestUtils.CUSTOMER_SCHEMA, Review comment: My thought process was the following: - We need a basic test - so created unpartitioned insert - We need to test partitioned tables (what happens with the partition columns) - so created partitioned test (not sure that this is strictly needed) - We need to test IOW - so created IOW I am open to discussions either way -- 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: 614593) Time Spent: 50m (was: 40m) > Enable automatic statistics generation for Iceberg tables > --------------------------------------------------------- > > Key: HIVE-25276 > URL: https://issues.apache.org/jira/browse/HIVE-25276 > Project: Hive > Issue Type: Improvement > Reporter: Peter Vary > Assignee: Peter Vary > Priority: Major > Labels: pull-request-available > Time Spent: 50m > Remaining Estimate: 0h > > During inserts we should have calculate the column statistics -- This message was sent by Atlassian Jira (v8.3.4#803005)