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

-- database: trino; tables: csv_table_with_custom_parameters; groups: hive, storage_formats;
--! name: scan from csv table
SELECT * FROM csv_table_with_custom_parameters
--!
10|QQ
--! name: describe csv table
DESCRIBE csv_table_with_custom_parameters
--!
c_bigint|varchar|||
c_varchar|varchar|||
--! name: show create csv table
SHOW CREATE TABLE csv_table_with_custom_parameters
--!
CREATE TABLE hive.default.csv_table_with_custom_parameters (\n   c_bigint varchar,\n   c_varchar varchar\n)\nWITH (\n   csv_escape = 'E',\n   csv_quote = 'Q',\n   csv_separator = 'S',\n   external_location = 'hdfs://hadoop-master:9000/tmp/product-test/datasets/csv_table_with_custom_parameters',\n   format = 'CSV'\n)
--! name: create table like
DROP TABLE IF EXISTS like_csv_table;
CREATE TABLE like_csv_table (LIKE csv_table_with_custom_parameters 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   csv_escape = 'E',\n   csv_quote = 'Q',\n   csv_separator = 'S',\n   external_location = 'hdfs://hadoop-master:9000/tmp/product-test/datasets/csv_table_with_custom_parameters',\n   format = 'CSV'\n)