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

-- database: presto; groups: insert; mutable_tables: datatype|created; tables: datatype
-- delimiter: |; ignoreOrder: true;
--!
insert into ${mutableTables.hive.datatype} select * from datatype order by 1 limit 2;
select * from ${mutableTables.hive.datatype}
--!
12|12.25|String1|1999-01-08|1999-01-08 02:05:06|true|123.22|12345678901234567890.0123456789|
25|55.52|test|1952-01-05|1989-01-08 04:05:06|false|321.21|-12345678901234567890.0123456789|