Parquet - Teradata Vantage - Analytics Database

CREATE FOREIGN TABLE Statement

CREATE FOREIGN TABLE ParquetTab1 (
  Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
  GageHeight2 FLOAT,
  Flow FLOAT,
  site_no BIGINT,
  datetime VARCHAR(16) CHARACTER SET UNICODE NOT CASESPECIFIC,
  Precipitation FLOAT,
  GageHeight FLOAT
)
USING (LOCATION ('/s3/td-usgs-public.s3.amazonaws.com/PARQUETDATA/'));

SHOW TABLE Statement

SHOW TABLE ParquetTab1;

CREATE MULTISET FOREIGN TABLE ParquetTab1 ,FALLBACK ,
     MAP = TD_MAP1
     (
      Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
      GageHeight2 FLOAT,
      Flow FLOAT,
      site_no BIGINT,
      datetime VARCHAR(16) CHARACTER SET UNICODE NOT CASESPECIFIC,
      Precipitation FLOAT,
      GageHeight FLOAT)
USING
(
      LOCATION  ('/s3/td-usgs-public.s3.amazonaws.com/PARQUETDATA/')
      MANIFEST  ('FALSE')
      PATHPATTERN  ('$var1/$var2/$var3/$var4/$var5')
      STOREDAS  ('PARQUET')
)
NO PRIMARY INDEX
PARTITION BY COLUMN ADD 65525;