Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Broker Load to non duplicate key table make replica inconsistent #8707

Closed
meegoo opened this issue Jul 14, 2022 · 0 comments · Fixed by #8714
Closed

Broker Load to non duplicate key table make replica inconsistent #8707

meegoo opened this issue Jul 14, 2022 · 0 comments · Fixed by #8714
Labels
type/bug Something isn't working

Comments

@meegoo
Copy link
Contributor

meegoo commented Jul 14, 2022

Steps to reproduce the behavior (Required)

  1. CREATE TABLE hits_signed_uk (
    CounterID int(11) NULL ,
    EventDate date NULL ,
    UserID bigint(20) NULL ,
    WatchID bigint(20) NULL ,
    JavaEnable tinyint(4) NULL ,
    Title varchar(65533) NULL ,
    GoodEvent smallint(6) NULL ,
    EventTime datetime NULL ,
    ClientIP int(11) NULL
    ) ENGINE=OLAP
    UNIQUE KEY(CounterID, EventDate, UserID)
    DISTRIBUTED BY HASH(UserID) BUCKETS 10
    PROPERTIES (
    'replication_num' = '3'
    )

  2. LOAD LABEL test
    (
    DATA INFILE('hdfs://x.x.x.x:9002/*')
    INTO TABLE hits_signed_uk
    )
    WITH BROKER 'broker1'
    PROPERTIES
    (
    'timeout' = '3600'
    )

  3. SELECT count(*) from hits_signed_uk;

Expected behavior (Required)

replica consistent

Real behavior (Required)

replica inconsistent

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant