[ https://issues.apache.org/jira/browse/HIVE-26035?focusedWorklogId=840803&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-840803 ]
ASF GitHub Bot logged work on HIVE-26035: ----------------------------------------- Author: ASF GitHub Bot Created on: 21/Jan/23 15:11 Start Date: 21/Jan/23 15:11 Worklog Time Spent: 10m Work Description: VenuReddy2103 commented on code in PR #3905: URL: https://github.com/apache/hive/pull/3905#discussion_r1070867838 ########## standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/conf/MetastoreConf.java: ########## @@ -753,6 +755,12 @@ public enum ConfVars { "SQL. For some DBs like Oracle and MSSQL, there are hardcoded or perf-based limitations\n" + "that necessitate this. For DBs that can handle the queries, this isn't necessary and\n" + "may impede performance. -1 means no batching, 0 means automatic batching."), + DIRECT_SQL_MAX_PARAMS_IN_INSERT("metastore.direct.sql.max.parameters.in.insert", Review Comment: done Issue Time Tracking ------------------- Worklog Id: (was: 840803) Time Spent: 2.5h (was: 2h 20m) > Explore moving to directsql for ObjectStore::addPartitions > ---------------------------------------------------------- > > Key: HIVE-26035 > URL: https://issues.apache.org/jira/browse/HIVE-26035 > Project: Hive > Issue Type: Bug > Reporter: Rajesh Balamohan > Assignee: Venugopal Reddy K > Priority: Major > Labels: pull-request-available > Time Spent: 2.5h > Remaining Estimate: 0h > > Currently {{addPartitions}} uses datanuclues and is super slow for large > number of partitions. It will be good to move to direct sql. Lots of repeated > SQLs can be avoided as well (e.g SDS, SERDE, TABLE_PARAMS) -- This message was sent by Atlassian Jira (v8.20.10#820010)