[ 
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)

Reply via email to