BULK INSERT example using Apache Parquet formatted data source

This BULK INSERT statement:

• reads data from an Apache Parquet formatted data source found in a destination URL
• maps data to destination table columns found in parquet-target table
• inserts the data

Before you begin

• BULK INSERT examples
• Learn about Apache PARQUET format
• BULK INSERT statement
• CREATE TABLE parquet-target

Run SHOW TABLE <tablename> to learn the structure of a destination table

BULK INSERT statement

BULK INSERT
  INTO parquet-target(
    _id,
    integercol,
    decimalcol
  )
  MAP(
    'id' id,
    'intval' int,
    'decval' decimal(4)
  )
  FROM
    'https://s3.amazonaws.com/todd-scratch.molecula.com/sample.parquet'
  WITH
    FORMAT 'PARQUET'
    INPUT 'URL';

Arguments

Next step

• SELECT FROM parquet-target