CREATE FOREIGN TABLE構文 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
2021年1月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/ncd1596241368722.ditamap
dita:ditavalPath
ja-JP/ncd1596241368722.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

CSVまたはJSONとしてフォーマットされた外部データの場合:

CREATE [MULTISET] FOREIGN TABLE table_specification 
[ table_options ]
[ , external_security_clause ]
[ ( location_column, payload_column ) ]
USING (
  LOCATION ( 'external_file_path' ) 
  [ PATHPATTERN ( 'value' ) ]
  [ MANIFEST ( { 'TRUE' | 'FALSE' } ) ] 	
  [ ROWFORMAT ( 'encoding_format' ) ]
  [ STOREDAS ( 'TEXTFILE' ) ]
  )
[ [,] NO PRIMARY INDEX ] 
[ [,] PARTITION BY COLUMN ] [;]

Parquetとしてフォーマットされた外部データの場合:

CREATE [MULTISET] FOREIGN TABLE table_specification 
[ table_options ]
[ , external_security_clause ]
[ ( location_column, data_column_definition ) ]
USING (
  LOCATION ( 'extemal_file_path' ) 
  [ PATHPATTERN ( 'value' ) ]
  [ MANIFEST ( { 'TRUE' | 'FALSE' } ) ] 	
  STOREDAS ( 'PARQUET' )
  )
[ [,] NO PRIMARY INDEX ] 
[ [,] PARTITION BY COLUMN ] [;]
table_specification
[database_name. | user_name.] table_name
external_security_clause
EXTERNAL SECURITY {
  DEFINER TRUSTED [ authorization_name ] |  
  [ INVOKER ] TRUSTED  authorization_name
}