[HIVE-18735] Create table like loses transactional attribute

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Transactions
• Target Version/s: 4.0.0
• Assignee: László Pintér
• Reporter: Eugene Koifman
• Created: 16/Feb/18 20:45
• Updated: 25/Nov/22 05:13
• Resolved: 28/Jun/19 13:22

Description

create table T1(a int, b int) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')";

create table T like T1;

show create table T ;

CREATE TABLE `T`(
  `a` int,
  `b` int)
CLUSTERED BY (
  a)
INTO 2 BUCKETS
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION
 'file:/Users/ekoifman/IdeaProjects/hive/ql/target/tmp/org.apache.hadoop.hive.ql.TestTxnCommands-1518813536099/warehouse/t'
TBLPROPERTIES (
  'transient_lastDdlTime'='1518813564')

Specifying props explicitly does work 

create table T1(a int, b int) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')";
create table T like T1 TBLPROPERTIES ('transactional'='true');
show create table T ;
CREATE TABLE `T`(
  `a` int,
  `b` int)
CLUSTERED BY (
  a)
INTO 2 BUCKETS
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION
  'file:/Users/ekoifman/IdeaProjects/hive/ql/target/tmp/org.apache.hadoop.hive.ql.TestTxnCommands-1518814098564/warehouse/t'
TBLPROPERTIES (
  'transactional'='true',
  'transactional_properties'='default',
  'transient_lastDdlTime'='1518814111')

Issue Links

• is related to: HIVE-18983 Add support for table properties inheritance in Create table like
• relates to: HIVE-18736 Create Table Like doc needs to be updated
• relates to: HIVE-22098 Data loss occurs when multiple tables are join with different bucket_version
• links to: review board