Primary key table insert data failed with timeout? Help me

Working with Data
1

Here’s the table build statement, and insert statement I used.

After successfully creating the table, it took a long time to execute using the insert statement without success.

Please help me to see what is the problem.

CREATE TABLE orders1 (
    order_id bigint NOT NULL,
    user_id INT NOT NULL,
    good_id INT NOT NULL,
    cnt int NOT NULL,
    revenue int NOT NULL
)
PRIMARY KEY (order_id)
DISTRIBUTED BY HASH (order_id)
PROPERTIES (
    "enable_persistent_index" = "true"
);

insert into orders1 values(1, 2, 3, 4, 5);

Below is a screenshot of my starrocks operation using dbeaver.

image
image972×324 8.32 KB

2

I’m using a mirror deployment: starrocks/fe-ubuntu:branch-3.2

3

You can’t just use the FE. You have to have a full deployment of StarRocks. I would recommend you use the allin1 quickstart container.

4

Thanks, this has been resolved. Specifically, it was because the storage was not configured in the architecture of the storage-computing separation, and this area needed to be set to false

PROPERTIES (
    "enable_persistent_index" = "false"
);
1 Like