[ https://issues.apache.org/jira/browse/HIVE-26837?focusedWorklogId=837085&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-837085 ]
ASF GitHub Bot logged work on HIVE-26837: ----------------------------------------- Author: ASF GitHub Bot Created on: 04/Jan/23 23:43 Start Date: 04/Jan/23 23:43 Worklog Time Spent: 10m Work Description: ramesh0201 commented on code in PR #3854: URL: https://github.com/apache/hive/pull/3854#discussion_r1061974132 ########## ql/src/test/results/clientpositive/llap/ctlt_translate_external.q.out: ########## @@ -0,0 +1,108 @@ +PREHOOK: query: create table test_mm(empno int, name string) partitioned by(dept string) stored as orc tblproperties('transactional'='true', 'transactional_properties'='default') +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_mm +POSTHOOK: query: create table test_mm(empno int, name string) partitioned by(dept string) stored as orc tblproperties('transactional'='true', 'transactional_properties'='default') +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_mm +PREHOOK: query: create table test_external like test_mm +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_external +POSTHOOK: query: create table test_external like test_mm +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_external +PREHOOK: query: desc formatted test_external +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@test_external +POSTHOOK: query: desc formatted test_external +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@test_external +# col_name data_type comment +empno int +name string + +# Partition Information +# col_name data_type comment +dept string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 + numFiles 0 + numPartitions 0 + numRows 0 + rawDataSize 0 + totalSize 0 + transactional true + transactional_properties default +#### A masked pattern was here #### Review Comment: @saihemanth-cloudera Can you review the latest? Issue Time Tracking ------------------- Worklog Id: (was: 837085) Time Spent: 1h 40m (was: 1.5h) > CTLT with hive.create.as.external.legacy as true creates managed table > instead of external table > ------------------------------------------------------------------------------------------------ > > Key: HIVE-26837 > URL: https://issues.apache.org/jira/browse/HIVE-26837 > Project: Hive > Issue Type: Bug > Components: HiveServer2 > Reporter: Ramesh Kumar Thangarajan > Assignee: Ramesh Kumar Thangarajan > Priority: Major > Labels: pull-request-available > Time Spent: 1h 40m > Remaining Estimate: 0h > > When CTLT is used with the config hive.create.as.external.legacy=true, it > still creates managed table by default. Use below to reproduce. > create external table test_ext(empno int, name string) partitioned by(dept > string) stored as orc; > desc formatted test_ext; > set hive.create.as.external.legacy=true; > create table test_external like test_ext; > desc formatted test_external; -- This message was sent by Atlassian Jira (v8.20.10#820010)