Skip to content
New issue

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

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

Already on GitHub? # to your account

hudi quickstart does not allow you to create tables #46

Open
alberttwong opened this issue Feb 19, 2024 · 1 comment
Open

hudi quickstart does not allow you to create tables #46

alberttwong opened this issue Feb 19, 2024 · 1 comment

Comments

@alberttwong
Copy link
Contributor

mysql> create table user_behavior as
    ->     SELECT * FROM FILES(
    ->         "path" = "s3://huditest/user_behavior_sample_data.parquet",
    ->         "format" = "parquet",
    ->         "aws.s3.access_key" = "admin",
    ->         "aws.s3.secret_key" = "password",
    ->         "aws.s3.region" = "us-west-2",
    ->         "aws.s3.use_instance_profile" = "false",
    ->         "aws.s3.enable_ssl" = "false",
    ->         "aws.s3.enable_path_style_access" = "true",
    ->         "aws.s3.endpoint" = "http://minio:9000"
    -> );
ERROR 1064 (HY000): Table replication num should be less than of equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10004]. table=user_behavior, properties.replication_num=3

the reason why is that there is only 1 FE and 1 BE.

@alberttwong
Copy link
Contributor Author

You need to execute

mysql> ADMIN SET FRONTEND CONFIG ('default_replication_num' ="1");
Query OK, 0 rows affected (0.01 sec)

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant