demo icon indicating copy to clipboard operation
demo copied to clipboard

hudi quickstart does not allow you to create tables

Open alberttwong opened this issue 1 year ago • 1 comments

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 avatar Feb 19 '24 08:02 alberttwong

You need to execute

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

alberttwong avatar Feb 19 '24 08:02 alberttwong