[ https://issues.apache.org/jira/browse/HIVE-25303?focusedWorklogId=620024&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-620024 ]
ASF GitHub Bot logged work on HIVE-25303: ----------------------------------------- Author: ASF GitHub Bot Created on: 07/Jul/21 15:10 Start Date: 07/Jul/21 15:10 Worklog Time Spent: 10m Work Description: zeroflag commented on pull request #2442: URL: https://github.com/apache/hive/pull/2442#issuecomment-875687658 @saihemanth-cloudera , could you verify that this combination still works? ``` legacy settings = off metadata translator = on create table tbl1 TBLPROPERTIES ('transactional'='false') as select * from other; ``` Original issue was that this was converted ton an external table by hms but getDefaultCtasLocation still pointed to the managed location. Because of the condition setTargetDir() won't be set in this case right? Which patch is going to be used? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 620024) Time Spent: 40m (was: 0.5h) > CTAS hive.create.as.external.legacy tries to place data files in managed WH > path > -------------------------------------------------------------------------------- > > Key: HIVE-25303 > URL: https://issues.apache.org/jira/browse/HIVE-25303 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore > Reporter: Sai Hemanth Gantasala > Assignee: Sai Hemanth Gantasala > Priority: Major > Labels: pull-request-available > Time Spent: 40m > Remaining Estimate: 0h > > Under legacy table creation mode (hive.create.as.external.legacy=true), when > a database has been created in a specific LOCATION, in a session where that > database is USEd, tables created using > CREATE TABLE <tablename> AS SELECT <select statement> > should inherit the HDFS path from the database's location. > Instead, Hive is trying to write the table data into > /warehouse/tablespace/managed/hive/<database_directory_name>/<table_name> -- This message was sent by Atlassian Jira (v8.3.4#803005)