okumin commented on code in PR #6020: URL: https://github.com/apache/hive/pull/6020#discussion_r2280285708
########## standalone-metastore/metastore-client/src/main/java/org/apache/hadoop/hive/metastore/utils/TableFetcher.java: ########## @@ -102,21 +104,47 @@ public List<TableName> getTables() throws Exception { List<String> databases = client.getDatabases(catalogName, dbPattern); for (String db : databases) { - Database database = client.getDatabase(catalogName, db); - if (MetaStoreUtils.checkIfDbNeedsToBeSkipped(database)) { - LOG.debug("Skipping table under database: {}", db); - continue; - } - if (MetaStoreUtils.isDbBeingPlannedFailedOver(database)) { - LOG.info("Skipping table that belongs to database {} being failed over.", db); - continue; - } - List<String> tablesNames = client.listTableNamesByFilter(catalogName, db, tableFilter, -1); + List<String> tablesNames = getTableNamesForDatabase(catalogName, db); tablesNames.forEach(tablesName -> candidates.add(TableName.fromString(tablesName, catalogName, db))); } return candidates; } + public List<Table> getTables(int maxBatchSize) throws Exception { + List<Table> candidates = new ArrayList<>(); + + // if tableTypes is empty, then a list with single empty string has to specified to scan no tables. + if (tableTypes.isEmpty()) { + LOG.info("Table fetcher returns empty list as no table types specified"); + return candidates; + } + + List<String> databases = client.getDatabases(catalogName, dbPattern); + + for (String db : databases) { + List<String> tablesNames = getTableNamesForDatabase(catalogName, db); Review Comment: Let me summarize the points. - This PR would reduce # of API calls from O(num-tables) to O(num-tables / batch size). It's neat 👍 - This PR would require the O(num-tables * tbl-size) space. We'd like to reduce it - Regardless of this PR, we retain the O(num-tables * length-of-table-name) space. Is it OK or should we optimize it? -- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org