Actian X 11.1 | Syntax for Defining an External Table

Was this helpful?

Syntax for Defining an External Table

The syntax for defining an external table is as follows:

CREATE EXTERNAL TABLE table_name (column_name data_type {,column_name data_type})

USING SPARK

WITH REFERENCE='reference'

[,FORMAT='format']

[,OPTIONS=('key'=value {,'key'='value'})]

For details, see CREATE EXTERNAL TABLE in the SQL Language Guide.

Last modified date: 11/09/2022