Actian X 11.1 | CREATE EXTERNAL TABLE Examples

SQL Reference Guide > SQL Reference Guide > SQL Statements > CREATE EXTERNAL TABLE (X100 Only) > CREATE EXTERNAL TABLE Examples

Was this helpful?

CREATE EXTERNAL TABLE Examples

Note: The column names in the Actian X external table must match the column names in the reference source.

1. Define an external table for a CSV data source:

CREATE EXTERNAL TABLE ext_csv (col1 INT4 NOT NULL, col2 VARCHAR(20) NOT NULL)

USING SPARK

WITH REFERENCE='user/mark/file.csv',

OPTIONS=('delimiter' = '|', 'header' = 'true');

Note: If the CSV file does not have a header, the name of the columns in the external table must match those in spark-csv, that is, C0, C1, .... If the option 'header' = 'true' is not specified and the Actian X external table definition has different names, you will get an error like:

E_VW1213 External table provider reported an error

'org.apache.spark.sql.AnalysisException: cannot resolve 'a' given input columns C0, C1; line 1

pos 38'.

Last modified date: 11/09/2022