[ https://issues.apache.org/jira/browse/HIVE-18735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16871913#comment-16871913 ]
Hive QA commented on HIVE-18735: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12972721/HIVE-18735.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 47 failed/errored test(s), 16339 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_rename_table] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_table_stats_status] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autoColumnStats_1] (batchId=24) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autoColumnStats_2] (batchId=92) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autoColumnStats_3] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autoColumnStats_8] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_alter_list_bucketing_table1] (batchId=29) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_like2] (batchId=95) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_like] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_like_tbl_props] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_table_like_stats] (batchId=65) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[describe_table] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explain_ddl] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[load_dyn_part8] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[merge3] (batchId=64) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mm_default] (batchId=91) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_discovery] (batchId=25) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats12] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats13] (batchId=89) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats14] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats15] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats2] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats4] (batchId=88) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats6] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats7] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats8] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats9] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats_noscan_1] (batchId=63) org.apache.hadoop.hive.cli.TestErasureCodingHDFSCliDriver.testCliDriver[erasure_simple] (batchId=196) org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_queries] (batchId=106) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[whroot_external1] (batchId=156) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[autoColumnStats_1] (batchId=165) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[autoColumnStats_2] (batchId=184) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata] (batchId=178) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[stats_noscan_1] (batchId=176) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_5] (batchId=110) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[load_dyn_part8] (batchId=142) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats12] (batchId=140) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats13] (batchId=149) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats14] (batchId=141) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats15] (batchId=118) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats2] (batchId=140) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats6] (batchId=125) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats7] (batchId=136) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats8] (batchId=145) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats9] (batchId=124) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats_noscan_1] (batchId=138) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/17716/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/17716/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-17716/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 47 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12972721 - PreCommit-HIVE-Build > Create table like loses transactional attribute > ----------------------------------------------- > > Key: HIVE-18735 > URL: https://issues.apache.org/jira/browse/HIVE-18735 > Project: Hive > Issue Type: Bug > Components: Transactions > Affects Versions: 2.0.0 > Reporter: Eugene Koifman > Assignee: Laszlo Pinter > Priority: Major > Attachments: HIVE-18735.01.patch > > > {noformat} > 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') > {noformat} > Specifying props explicitly does work > {noformat} > 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') > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)