デフォルトの書式 - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
ft:locale
ja-JP
ft:lastEdition
2021-09-23
dita:mapPath
ja-JP/spp1591731285373.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage
SHOW TABLE riverflow_csv;
CREATE MULTISET FOREIGN TABLE riverflow_csv ,FALLBACK ,
     EXTERNAL SECURITY MyAuthObj,
     MAP = TD_MAP1
     (
      Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
      GageHeight2 FLOAT FORMAT '-ZZZ9.99',
      Flow FLOAT FORMAT '-ZZZZ9.99',
      site_no BIGINT,
      datetime VARCHAR(16) CHARACTER SET UNICODE CASESPECIFIC,
      Precipitation FLOAT FORMAT '-ZZZ9.99',
      GageHeight FLOAT FORMAT '-ZZZ9.99')
USING
(
      LOCATION  ('/s3/YOUR-BUCKET.s3.amazonaws.com/CSVDATA/')
      MANIFEST  ('FALSE')
      PATHPATTERN  ('$var1/$site_no/$var3/$var4/$var5')
      ROWFORMAT  ('{"field_delimiter":",","record_delimiter":"\n","character_set":"LATIN"}')
      STOREDAS  ('TEXTFILE')
      HEADER  ('TRUE')
      STRIP_EXTERIOR_SPACES  ('FALSE')
      STRIP_ENCLOSING_CHAR  ('NONE')
)
NO PRIMARY INDEX ;