Vector 6.0 | Syntax for Defining an External Table

User Guide > User Guide > Using External Tables > 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