tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud WeData
    Documentation
    Download PDF

    Greenplum Data Source

    Last updated: 2024-11-01 17:00:28
    Download PDF

      Greenplum Single Table Write Node Configuration

      Configure Greenplum Node

      1. On the DataInLong page, in the left sidebar, click Real-time Sync.
      2. At the top of the Real-time Sync page, select Single Table Sync to create a new one (you can choose between form and canvas modes) and enter the configuration page.
      3. click on the left write, click to select Greenplum nodes and configure node information.
      
      
      
      4. You can refer to the table below to configure parameter information.
      Parameters
      Description
      Data Destination
      Greenplum Data Source to be Written.
      Database
      Support selection or manual entry of the library name to be written to.
      By default, the database bound to the data source is used as the default database. Other databases need to be manually entered.
      If the data source network is not connected and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the DataInLong network is connected.
      schema
      Supports selection or manual input of the Schema name to be read.
      Table
      Support selection or manual entry of the table name to be written to.
      If the data source network is not connected and the table information cannot be fetched directly, you can manually enter the table name. Data synchronization can still be performed when the DataInLong network is connected.
      Primary Key
      Select a field as the primary key for the target table.
      Advanced Settings
      You can configure parameters according to business needs.
      5. Preview Data Fields and map them with Read Node Configuration Fields, click Save.

      Greenplum Log Collection Write Node Configuration

      Parameters
      Description
      Data Destination
      Select an available Greenplum Data Source in the current project.
      Database
      Support selection or manual entry of the library name to be written to.
      By default, the database bound to the data source is used as the default database. Other databases need to be manually entered.
      If the data source network is not connected and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the DataInLong network is connected.
      schema
      Supports selection or manual input of the Schema name to be read.
      Table
      Support selection or manual entry of the table name to be written to.
      If the data source network is not connected and the table information cannot be fetched directly, you can manually enter the table name. Data synchronization can still be performed when the DataInLong network is connected.
      Primary Key
      Select a field as the primary key for the data table.
      Advanced Settings (optional)
      You can configure parameters according to business needs.

      Greenplum Write Data Type Conversion Support

      Write

      Internal Types
      Greenplum Type
      TINYINT
      -
      SMALLINT
      SMALLINT,INT2,SMALLSERIAL,SERIAL2
      INT
      INTEGER,SERIAL
      BIGINT
      BIGINT,BIGSERIAL
      DECIMAL(20, 0)
      -
      FLOAT
      REAL,FLOAT4
      DOUBLE
      FLOAT8,DOUBLE PRECISION
      DECIMAL(p, s)
      NUMERIC(p, s),DECIMAL(p, s)
      BOOLEAN
      BOOLEAN
      DATE
      DATE
      TIME [(p)][WITHOUT TIMEZONE]
      TIME [(p)][WITHOUT TIMEZONE]
      TIMESTAMP [(p)][WITHOUT TIMEZONE]
      TIMESTAMP [(p)]WITHOUT TIMEZONE
      STRING
      CHAR(n),CHARACTER(n),VARCHAR(n),CHARACTER VARYING(n),TEXT
      BYTES
      BYTEA
      
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy