• Data Loading Overview
  • Data Loading Roadmap: Choosing a Data Loading Method
  • Migrating Your Data to Actian Data Platform
  • Overview of SQL-Based Data Loading
    • Cloud Object Storage Loading Methods
    • Grant External Tables Access
• Loading Delimited Text Data
  • Data Load
    • Introduction to Data Load
    • Use Data Load to Load Delimited Text Files
  • Loading Delimited Text Data from Cloud Data Storage
    • Introduction to Loading Delimited Text Data
    • Loading Delimited Text Data Using COPY VWLOAD (SQL)
      • Loading Delimited Text Data from Google Cloud Storage Using COPY VWLOAD
      • Loading Delimited Text Data from Azure Blob Storage Using COPY VWLOAD
      • Loading Delimited Text Data from AWS S3 Storage Using COPY VWLOAD
    • Loading Delimited Text Data from External Tables (SQL)
      • Loading Delimited Text Data from Google Cloud Storage Using External Tables
      • Loading Delimited Text Data from Azure Blob Storage Using External Tables
      • Loading Delimited Text Data from AWS S3 Storage Using External Tables
    • Delimiter Text File Switches
  • Batch Data Loading
• Loading Parquet Data
  • Loading Parquet Data from Cloud Data Storage
    • Introduction to Loading Parquet Data
    • Loading Parquet Data from External Tables (SQL)
      • Loading Parquet Data from Google Cloud Storage
      • Loading Parquet Data from Azure Blob Storage
      • Loading Parquet Data from AWS S3 Storage
• Loading JSON Data
  • Loading JSON Data from Cloud Data Storage
    • Introduction to Loading JSON Data
    • Loading JSON Data from External Tables (SQL)
      • Loading JSON Data from Google Cloud Storage
      • Loading JSON Data from Azure Blob Storage
      • Loading JSON Data from AWS S3 Storage
• Appendixes
  • Managing Integration Users, Groups, and Listeners
    • Manage Integration Users
    • Manage Integration Groups
    • Manage Integration Listeners
  • Updating Data
    • Methods for Updating Data
    • Batch and Bulk Updates
      • Transfer Data from a Traditional Ingres Table
    • Combining Tables
    • How to Avoid Propagation
    • MODIFY...TO COMBINE Statement--Merge and Update Data
      • Propagate In-memory Updates to Disk
    • Best Practices for Updates
    • Allowing Concurrent Inserts
  • Exporting and Importing Data
    • SQL Loading and Exporting Methods
    • Exporting to an External Table and Importing the Data Elsewhere
    • Using DBeaver to Generate a CREATE TABLE Statement
    • Using COPY VWLOAD
      • Required COPY VWLOAD Options to Load Data Written with INSERT INTO EXTERNAL CSV
    • Exporting to CSV Files
  • Managing Tables and Views
    • Table Management
      • Tools for Creating a Table
      • Table Ownership
      • Enable or Disable Journaling
      • Duplicate Rows in Tables
      • Data Type Conversion Functions for Default Values
      • Constraints
        • Constraint Types
      • Delete Constraints
    • Views
      • Views and Permissions
      • Working with View Objects
      • Updates on Views
        • Types of Updates Not Permitted on Views
    • Schemas
    • Synonyms, Temporary Tables, and Comments
      • Synonyms
        • Working with Synonym Objects
      • Temporary Tables
        • Temporary Table Declaration and the Optional SESSION Schema Qualifier
        • Examples of Working with Temporary Tables
      • Comments to Describe Tables and Views
        • The COMMENT ON Statement
  • Using External Tables
    • Introduction to External Tables
    • How External Tables Work
    • Syntax for Defining an External Table
    • Reading and Writing to an External Table
    • Adding Extra Data Sources
    • External Table Limitations
    • External Table Usage Notes
    • Examples of Defining External Tables and Loading Data
      • CSV Files
        • Small Data Set
        • Large Data Set
      • JSON Files
      • JDBC Data Source
      • ORC Files
      • PARQUET Files
      • AVRO Files
  • Actian Data Platform to Spark Data Type Mapping

Data Loading Overview

Actian Data Platform to Spark Data Type Mapping