[ https://issues.apache.org/jira/browse/HIVE-26217?focusedWorklogId=776168&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-776168 ]
ASF GitHub Bot logged work on HIVE-26217: ----------------------------------------- Author: ASF GitHub Bot Created on: 31/May/22 09:24 Start Date: 31/May/22 09:24 Worklog Time Spent: 10m Work Description: deniskuzZ commented on code in PR #3281: URL: https://github.com/apache/hive/pull/3281#discussion_r885410160 ########## ql/src/java/org/apache/hadoop/hive/ql/parse/TaskCompiler.java: ########## @@ -517,17 +517,21 @@ private Path getDefaultCtasLocation(final ParseContext pCtx) throws SemanticExce try { String protoName = null, suffix = ""; boolean isExternal = false; - + boolean useSuffix = HiveConf.getBoolVar(conf, HiveConf.ConfVars.HIVE_ACID_CREATE_TABLE_USE_SUFFIX) + || HiveConf.getBoolVar(conf, HiveConf.ConfVars.HIVE_ACID_LOCKLESS_READS_ENABLED); + if (pCtx.getQueryProperties().isCTAS()) { protoName = pCtx.getCreateTable().getDbTableName(); isExternal = pCtx.getCreateTable().isExternal(); - + if (!isExternal && useSuffix) { Review Comment: we should exclude managed non-txn tables as well ```` AcidUtils.isTransactionalTable(tbl) ```` Issue Time Tracking ------------------- Worklog Id: (was: 776168) Time Spent: 7h 10m (was: 7h) > Make CTAS use Direct Insert Semantics > ------------------------------------- > > Key: HIVE-26217 > URL: https://issues.apache.org/jira/browse/HIVE-26217 > Project: Hive > Issue Type: Improvement > Reporter: Sourabh Badhya > Assignee: Sourabh Badhya > Priority: Major > Labels: pull-request-available > Time Spent: 7h 10m > Remaining Estimate: 0h > > CTAS on transactional tables currently does a copy from staging location to > table location. This can be avoided by using Direct Insert semantics. Added > support for suffixed table locations as well. -- This message was sent by Atlassian Jira (v8.20.7#820007)