CREATE TABLE orc-target

The table orc-target is the destination for a BULK INSERT statement, and contains:

• a numeric unique identifier
• BOOL, ID, INT and STRING data types
• IF NOT EXISTS and WITH COMMENT table options

Before you begin

• CREATE TABLE examples
• CREATE TABLE statement Learn about FeatureBase data types used in this statement:
• BOOL data type
• ID data type
• INT data type
• STRING data type

CREATE TABLE statement

CREATE TABLE
  IF NOT EXISTS
  orc-target (
    _id ID,
    stringcol STRING,
    boolcol BOOL,
    intcol INT
)
WITH COMMENT 'destination table for APACHE orc data source'
;

Next step

• BULK INSERT INTO orc-target from URL