tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud WeData
    Documentation
    Download PDF

    ClickHouse Data Source

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

      ClickHouse Single Table Write Node Configuration

      Configure ClickHouse Node

      1. On the Data Integration page, in the left sidebar, click Real-time Sync.
      2. On the real-time sync page, select Single Table Sync at the top, create new (choose between form and canvas mode) and enter the configuration page.
      3. Click the left-side Write, click to select the ClickHouse node and configure the node information.
      
      
      4. You can refer to the following table for parameter configuration.
      Parameters
      Description
      Type
      ClickHouse
      Data Destination
      Select the ClickHouse data source to write to.
      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, causing the inability to directly pull library information, you can manually enter the database name.
      Data synchronization can still be performed when the DataInLong network is connected.
      Table
      Support selection or manual entry of the table name to be written to.
      If the data source network is not connected, causing the inability to directly pull table information, 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.
      Partition Field
      Select one or more fields as partition fields.
      Advanced Settings
      You can configure parameters according to business needs.
      5. Preview fields and map them to the fields in the write node configuration, click Save.

      ClickHouse Log Collection Write Node Configuration

      Parameters
      Description
      Data Destination
      Select the available ClickHouse data source in the current project.
      Database/Table
      Select the corresponding database table from this data source.
      Primary Key
      Select a field as the primary key for the data table.
      Partition Field
      Select one or more fields as partition fields.
      Advanced Settings (optional)
      You can configure parameters according to business needs.

      Data type conversion support

      Write

      Internal Types
      ClickHouse Type
      CHAR
      String
      VARCHAR
      String,IP,UUID
      STRING
      String,EnumL
      BOOLEAN
      UInt8
      BYTES
      FixedString
      DECIMAL
      Decimal,Int128,Int256,UInt64,UInt128,UInt256
      TINYINT
      Int8
      SMALLINT
      Int16,UInt8
      INTEGER
      Int32,UInt16,Interval
      BIGINT
      Int64,UInt32
      FLOAT
      Float32
      DATE
      Date
      TIME
      DateTime
      TIMESTAMP
      DateTime
      TIMESTAMP_LTZ
      DateTime
      INTERVAL_YEAR_MONTH
      Int32
      INTERVAL_DAY_TIME
      Int64
      ARRAY
      Array
      MAP
      Map
      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