• Home
• io.trino
• trino-product-tests
• 459
• source code
• tables_with_header_and_footer.sql

×

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.testcases.tables_with_header_and_footer.sql Maven / Gradle / Ivy

-- database: presto; tables: table_with_header, table_with_footer, table_with_header_and_footer; groups: hive, hive_file_header;
--! name: simple_scan with header
SELECT count(*) FROM table_with_header
--!
34816
--! name: filter with header
SELECT *
FROM table_with_header
WHERE data = 'data'
--!
--! name: simple_scan with footer
SELECT count(*) FROM table_with_footer
--!
34816
--! name: filter with footer
SELECT *
FROM table_with_footer
WHERE data = 'data'
--!
--! name: simple_scan with header and footer
SELECT count(*) FROM table_with_header_and_footer
--!
34816
--! name: filter with header and footer
SELECT *
FROM table_with_header_and_footer
WHERE data = 'data'
--!