[
https://issues.apache.org/jira/browse/HIVE-26035?focusedWorklogId=842182&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-842182
]
ASF GitHub Bot logged work on HIVE-26035:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 30/Jan/23 07:33
Start Date: 30/Jan/23 07:33
Worklog Time Spent: 10m
Work Description: VenuReddy2103 commented on code in PR #3905:
URL: https://github.com/apache/hive/pull/3905#discussion_r1090257405
##########
standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/conf/MetastoreConf.java:
##########
@@ -692,6 +692,8 @@ public enum ConfVars {
"Default transaction isolation level for identity generation."),
DATANUCLEUS_USE_LEGACY_VALUE_STRATEGY("datanucleus.rdbms.useLegacyNativeValueStrategy",
"datanucleus.rdbms.useLegacyNativeValueStrategy", true, ""),
+ DATANUCLEUS_QUERY_SQL_ALLOWALL("datanucleus.query.sql.allowAll",
"datanucleus.query.sql.allowAll",
+ true, "Allow insert, update and delete operations from JDO SQL"),
Review Comment:
Done. This property is a DataNucleus extension to allow insert/update/delete
operations from jdo sql. Have added detailed description like this now -
`In strict JDO all SQL queries must begin with "SELECT ...", and
consequently it is not possible to execute queries that change data. This
DataNucleus property when set to true allows insert, update and delete
operations from JDO SQL. Default value is true.`
Issue Time Tracking
-------------------
Worklog Id: (was: 842182)
Time Spent: 4h 40m (was: 4.5h)
> 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: 4h 40m
> 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)
