[jira] [Updated] (HIVE-22396) CMV creating a Full ACID partitioned table fails because of no writeId

2019-10-23 Thread Ashutosh Chauhan (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-22396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ashutosh Chauhan updated HIVE-22396:

Fix Version/s: 4.0.0
   Resolution: Fixed
   Status: Resolved  (was: Patch Available)

Pushed to master.

> CMV creating a Full ACID partitioned table fails because of no writeId
> --
>
> Key: HIVE-22396
> URL: https://issues.apache.org/jira/browse/HIVE-22396
> Project: Hive
>  Issue Type: Sub-task
>  Components: HiveServer2, repl
>Affects Versions: 4.0.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>  Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: HIVE-22396.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> create materialized view acid_cmv_part disable rewrite partitioned on (k)
>   stored as orc TBLPROPERTIES ('transactional'='true')
>   as select key k, value from src order by k limit 5;
> ERROR : FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
> the config by open txn task for migration
> Error: Error while processing statement: FAILED: Execution Error, return code 
> 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not 
> set in the config by open txn task for migration (state=08S01,code=1)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (HIVE-22396) CMV creating a Full ACID partitioned table fails because of no writeId

2019-10-23 Thread Jesus Camacho Rodriguez (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-22396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-22396:
---
Attachment: HIVE-22396.patch

> CMV creating a Full ACID partitioned table fails because of no writeId
> --
>
> Key: HIVE-22396
> URL: https://issues.apache.org/jira/browse/HIVE-22396
> Project: Hive
>  Issue Type: Sub-task
>  Components: HiveServer2, repl
>Affects Versions: 4.0.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>  Labels: pull-request-available
> Attachments: HIVE-22396.patch
>
>
> create materialized view acid_cmv_part disable rewrite partitioned on (k)
>   stored as orc TBLPROPERTIES ('transactional'='true')
>   as select key k, value from src order by k limit 5;
> ERROR : FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
> the config by open txn task for migration
> Error: Error while processing statement: FAILED: Execution Error, return code 
> 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not 
> set in the config by open txn task for migration (state=08S01,code=1)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (HIVE-22396) CMV creating a Full ACID partitioned table fails because of no writeId

2019-10-23 Thread Jesus Camacho Rodriguez (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-22396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-22396:
---
Status: Patch Available  (was: In Progress)

> CMV creating a Full ACID partitioned table fails because of no writeId
> --
>
> Key: HIVE-22396
> URL: https://issues.apache.org/jira/browse/HIVE-22396
> Project: Hive
>  Issue Type: Sub-task
>  Components: HiveServer2, repl
>Affects Versions: 4.0.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>  Labels: pull-request-available
>
> create materialized view acid_cmv_part disable rewrite partitioned on (k)
>   stored as orc TBLPROPERTIES ('transactional'='true')
>   as select key k, value from src order by k limit 5;
> ERROR : FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
> the config by open txn task for migration
> Error: Error while processing statement: FAILED: Execution Error, return code 
> 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not 
> set in the config by open txn task for migration (state=08S01,code=1)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (HIVE-22396) CMV creating a Full ACID partitioned table fails because of no writeId

2019-10-23 Thread Jesus Camacho Rodriguez (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-22396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-22396:
---
Description: 
create materialized view acid_cmv_part disable rewrite partitioned on (k)
  stored as orc TBLPROPERTIES ('transactional'='true')
  as select key k, value from src order by k limit 5;
ERROR : FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in the 
config by open txn task for migration
Error: Error while processing statement: FAILED: Execution Error, return code 1 
from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
the config by open txn task for migration (state=08S01,code=1)

  was:
create table t1(a int, b int);
insert into t1 values (1, 2), (3, 4);
create table t6_part partitioned by (a) stored as orc tblproperties 
("transactional"="true") as select * from t1;
ERROR : FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in the 
config by open txn task for migration
Error: Error while processing statement: FAILED: Execution Error, return code 1 
from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
the config by open txn task for migration (state=08S01,code=1)


> CMV creating a Full ACID partitioned table fails because of no writeId
> --
>
> Key: HIVE-22396
> URL: https://issues.apache.org/jira/browse/HIVE-22396
> Project: Hive
>  Issue Type: Sub-task
>  Components: HiveServer2, repl
>Affects Versions: 4.0.0
>Reporter: Ashutosh Bapat
>Assignee: Ashutosh Bapat
>Priority: Major
>  Labels: pull-request-available
>
> create materialized view acid_cmv_part disable rewrite partitioned on (k)
>   stored as orc TBLPROPERTIES ('transactional'='true')
>   as select key k, value from src order by k limit 5;
> ERROR : FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
> the config by open txn task for migration
> Error: Error while processing statement: FAILED: Execution Error, return code 
> 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not 
> set in the config by open txn task for migration (state=08S01,code=1)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (HIVE-22396) CMV creating a Full ACID partitioned table fails because of no writeId

2019-10-23 Thread Jesus Camacho Rodriguez (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-22396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-22396:
---
Reporter: Jesus Camacho Rodriguez  (was: Ashutosh Bapat)

> CMV creating a Full ACID partitioned table fails because of no writeId
> --
>
> Key: HIVE-22396
> URL: https://issues.apache.org/jira/browse/HIVE-22396
> Project: Hive
>  Issue Type: Sub-task
>  Components: HiveServer2, repl
>Affects Versions: 4.0.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
>Priority: Major
>  Labels: pull-request-available
>
> create materialized view acid_cmv_part disable rewrite partitioned on (k)
>   stored as orc TBLPROPERTIES ('transactional'='true')
>   as select key k, value from src order by k limit 5;
> ERROR : FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in 
> the config by open txn task for migration
> Error: Error while processing statement: FAILED: Execution Error, return code 
> 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not 
> set in the config by open txn task for migration (state=08S01,code=1)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)