Greenplum

    Supported Version

    How to create a PostgreSQL Load Node

    2. -- MySQL extract node
    3. CREATE TABLE `mysql_extract_table`(
    4.   `id` BIGINT,
    5.   `name` STRING,
    6.   `age` INT
    7. ) WITH (
    8.   'connector' = 'mysql-cdc-inlong',
    9.   'url' = 'jdbc:mysql://localhost:3306/read',
    11.   'password' = 'inlong',
    12.   'table-name' = 'user'
    13. )
    15. -- Greenplum load node
    16. CREATE TABLE `greenplum_load_table`(
    17.   `id` BIGINT,
    18.   `name` STRING,
    19.   `age` INT
    20. ) WITH (
    22.   'url' = 'jdbc:postgresql://localhost:5432/write',
    23.   'dialect-impl' = 'org.apache.inlong.sort.jdbc.dialect.GreenplumDialect',
    24.   'username' = 'inlong',
    25.   'password' = 'inlong',
    26.   'table-name' = 'public.user'
    27. )
    29. -- write data into Greenplum
    30. SELECT id, name , age FROM mysql_extract_table;

    Data Type Mapping