sql-tests.datasets.datatype.ddl Maven / Gradle / Ivy
-- type: hive
CREATE %EXTERNAL% TABLE %NAME%(
c_bigint bigint,
c_double double,
c_string string,
c_date date,
c_timestamp timestamp,
c_boolean boolean,
c_short_decimal decimal(5,2),
c_long_decimal decimal(30,10)
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
STORED AS TEXTFILE