Load Data

• Load Data Using COPY
  • Load from a file
  • Load from STDIN
  • Load data using \copy in psql
  • Input format
• Load External Data Using Foreign Table
  • Use foreign table
  • Query a foreign table
• Load Data from Kafka Using Kafka FDW
  • Basic usage
  • Supported data formats
  • Query
  • Message producer
  • Data import
• Load Data from Object Storage and HDFS
  • Load data from object storage
  • Load Iceberg table data from S3 (without an external metadata service)
  • Read Iceberg tables on S3 via Polaris Catalog
  • Load data from HDFS without authentication
  • Load data from HDFS using Kerberos authentication
• Load Data from Hive Data Warehouse
  • Step 1. Configure Hive and HDFS information on SynxDB Elastic
  • Step 2. Create foreign data wrapper and Hive Connector extension
  • Step 3. Create server and user mapping
  • Step 4. Sync Hive objects to SynxDB Elastic
  • Supported usage and limitations
• Load Data Using gpfdist
  • About gpfdist
  • Step 1. Install gpfdist
  • Step 2. Start and stop gpfdist
  • Step 3. Use gpfdist with external tables to load data