apache / apache/hudi

bulk insert overwrite table will delete the table and then recreate a table

Open
#15,380 0 comments 0 reactions 1 assignee Assigned to @xushiyan View on GitHub
area:sql area:writer from-jira priority:high type:bug
Dominant language
Java
Stars
6.2k
Forks
2.5k
Avg merge
2d 8h
Merged PRs (30d)
111

Description

When hoodie.sql.bulk.insert.enable is enabled, executing insert overwrite will delete the table and then recreate a table, so time travel cannot be performed.

 
{code:java}
create table hudi_cow_test_tbl (
  id bigint,
  name string,
  ts bigint,
  dt string,
  hh string
) using hudi
tblproperties (
  type = 'cow',
  primaryKey = 'id',
  preCombineField = 'ts',
  'hoodie.sql.insert.mode' = 'non-strict',
  'hoodie.sql.bulk.insert.enable' = 'true'
);

insert into hudi_cow_test_tbl select 1, 'a1', 1001, '2021-12-09', '11';

insert overwrite hudi_cow_test_tbl select 3, 'a3', 1001, '2021-12-09', '11';

{code}

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-4704
- Type: Bug
- Affects version(s):
- 0.12.0
- Fix version(s):
- 1.1.0

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.