CREATE FOREIGN TABLE文
CREATE FOREIGN TABLE riverflow_json
USING ( LOCATION ('/s3/td-usgs-public.s3.amazonaws.com/JSONDATA/') );
SHOW TABLE文
次を実行します。
SHOW TABLE riverflow_json;
結果:
CREATE MULTISET FOREIGN TABLE NOS_USR.riverflow_json ,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 ;