[
https://issues.apache.org/jira/browse/HIVE-24188?focusedWorklogId=487942&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-487942
]
ASF GitHub Bot logged work on HIVE-24188:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 22/Sep/20 05:01
Start Date: 22/Sep/20 05:01
Worklog Time Spent: 10m
Work Description: nareshpr opened a new pull request #1516:
URL: https://github.com/apache/hive/pull/1516
What changes were proposed in this pull request?
Included check to skip TXN tblproperties for external table from MMM
Why are the changes needed?
CTLT is failing from MM to External
Does this PR introduce any user-facing change?
no
How was this patch tested?
Using repro sql, included it as part of testcase.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 487942)
Remaining Estimate: 0h
Time Spent: 10m
> CTLT from MM to External fails because table txn properties are not skipped
> ---------------------------------------------------------------------------
>
> Key: HIVE-24188
> URL: https://issues.apache.org/jira/browse/HIVE-24188
> Project: Hive
> Issue Type: Bug
> Reporter: Naresh P R
> Assignee: Naresh P R
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Repro steps
>
> {code:java}
> set hive.support.concurrency=true;
> set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
> create table test_mm(age int, name string) partitioned by(dept string) stored
> as orc tblproperties('transactional'='true',
> 'transactional_properties'='default');
> create external table test_external like test_mm LOCATION
> '${system:test.tmp.dir}/create_like_mm_to_external';
> {code}
> Fails with below exception
> {code:java}
> Error: Error while processing statement: FAILED: Execution Error, return code
> 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
> MetaException(message:default.test_external cannot be declared transactional
> because it's an external table) (state=08S01,code=1){code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
