• Home
• io.prestosql
• presto-product-tests
• 346
• source code
• csv_with_header_and_footer.ddl

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql-tests.datasets.csv_with_header_and_footer.ddl Maven / Gradle / Ivy

-- type: hive
CREATE %EXTERNAL% TABLE %NAME%
(
	c_bigint BIGINT,
	c_varchar VARCHAR(255))
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
STORED AS TEXTFILE
LOCATION '%LOCATION%'
TBLPROPERTIES (
    'skip.header.line.count' = '1',
    'skip.footer.line.count' = '1')