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

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)

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

No branches or pull requests

1 participant