• Home
• io.trino
• trino-product-tests
• 459
• source code
• csv_table.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.csv_table.sql Maven / Gradle / Ivy

-- database: presto; tables: csv_table; groups: hive, storage_formats;
--! name: scan from csv table
SELECT * FROM csv_table
--!
10|""
--! name: describe csv table
DESCRIBE csv_table
--!
c_bigint|varchar|||
c_varchar|varchar|||
--! name: show create csv table
SHOW CREATE TABLE csv_table
--!
CREATE TABLE hive.default.csv_table (\n   c_bigint varchar,\n   c_varchar varchar\n)\nWITH (\n   external_location = 'hdfs://hadoop-master:9000/tmp/product-test/datasets/csv_table',\n   format = 'CSV'\n)
--! name: create table like
DROP TABLE IF EXISTS like_csv_table;
CREATE TABLE like_csv_table (LIKE csv_table INCLUDING PROPERTIES);
SHOW CREATE TABLE like_csv_table
--!
CREATE TABLE hive.default.like_csv_table (\n   c_bigint varchar,\n   c_varchar varchar\n)\nWITH (\n   external_location = 'hdfs://hadoop-master:9000/tmp/product-test/datasets/csv_table',\n   format = 'CSV'\n)