Startrocks建表语句及测试数据

建表语句

CREATE TABLE stwb (
                      id INT,
                      boolean_TEST BOOLEAN,
                      tinyint_TEST TINYINT,
                      smallint_TEST SMALLINT,
                      int_TEST INT,
                      bigint_TEST BIGINT,
                      largeint_TEST LARGEINT,
                      float_TEST FLOAT,
                      double_TEST DOUBLE,
                      date_TEST DATE,
                      datetime_TEST DATETIME,
                      decimal_TEST DECIMAL(10, 2),
                      decimalv2_TEST DECIMAL(27, 9), -- 使用 DECIMAL 替代
                      decimal32_TEST DECIMAL(9, 5),
                      decimal64_TEST DECIMAL(18, 4),
                      decimal128_TEST DECIMAL(38, 10),
                      char_TEST CHAR(100),
                      varchar_TEST VARCHAR(255)
) PRIMARY KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 4
PROPERTIES (
    "replication_num" = "1",
    "enable_persistent_index"="true"
);

INSERT INTO stwb (
    id,
    boolean_TEST,
    tinyint_TEST,
    smallint_TEST,
    int_TEST,
    bigint_TEST,
    largeint_TEST,
    float_TEST,
    double_TEST,
    date_TEST,
    datetime_TEST,
    decimal_TEST,
    decimalv2_TEST,
    decimal32_TEST,
    decimal64_TEST,
    decimal128_TEST,
    char_TEST,
    varchar_TEST
) VALUES (
             1,
             true,
             1,
             10,
             100,
             9223372036854775807,-- BIGINT 的最大值
             9223372036854775807,
             1.23,
             1.23456789,
             '2023-10-23',
             '2023-10-23 10:00:00',
             123.45,
             123456789.123456789,
             123.45678,
             12345678.1234,
             123456789012345678.90,
             'TestChar',
             'This is a varchar field'
         );