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
  • Write data to a foreign table with ordered insertion
• 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
  • HDFS and OSS-related configuration parameters
• Load Data from Hive Data Warehouse
  • Step 1. Configure Hive and HDFS information on SynxDB Cloud
  • Step 2. Create foreign data wrapper and Hive Connector extension
  • Step 3. Create server and user mapping
  • Step 4. Sync Hive objects to SynxDB Cloud
  • Supported usage and limitations
• Configure Hive Metadata Auto Sync
  • How it works
  • Prerequisites
  • Step 1. Install the listener on the Hive Metastore
  • Step 2. Prepare the target database
  • Step 3. Access the Hive Meta Sync tab
  • Step 4. Create a configuration (basic information)
  • Step 5. Configure sync parameters
  • Step 6. Preview and submit
  • Verify the synchronization
  • Manage sync tasks
• Load Data between SynxDB Cloud and Spark
  • Overview
  • Prerequisites
  • Configuration
  • Ingest data from SynxDB Cloud to Spark
  • Export data from Spark to SynxDB Cloud
• 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