17.10 - JSON - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1144-171K-JPN
Language
日本語 (日本)
Last Update
2021-09-23

CREATE FOREIGN TABLE文

CREATE FOREIGN TABLE JSONTab1
USING (LOCATION ('/s3/td-usgs-public.s3.amazonaws.com/JSONDATA/'));

SHOW TABLE文

SHOW TABLE JSONTab1;
CREATE MULTISET FOREIGN TABLE JSONTab1 ,FALLBACK ,
     MAP = TD_MAP1
     (
      Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
      Payload JSON(16776192) INLINE LENGTH 64000 CHARACTER SET LATIN)
USING
(
      LOCATION  ('/s3/td-usgs-public.s3.amazonaws.com/JSONDATA/')
      MANIFEST  ('FALSE')
      PATHPATTERN  ('$var1/$var2/$var3/$var4/$var5')
      ROWFORMAT  ('{"record_delimiter":"\n","character_set":"LATIN"}')
      STOREDAS  ('TEXTFILE')
)
NO PRIMARY INDEX ;