sql-tests.testcases.insert.insert_columns_where.sql Maven / Gradle / Ivy
-- database: presto; groups: insert; mutable_tables: datatype|created; tables: datatype
-- delimiter: |; ignoreOrder: true;
--!
insert into ${mutableTables.hive.datatype} select c_bigint, c_double, c_string, c_date, c_timestamp, c_boolean, c_short_decimal, c_long_decimal from datatype where c_double < 20;
select * from ${mutableTables.hive.datatype}
--!
12|12.25|String1|1999-01-08|1999-01-08 02:05:06|true|123.22|12345678901234567890.0123456789|
964|0.245|Again|1936-02-08|2005-01-09 04:05:06|false|333.82|98765432109876543210.9876543210|
100|12.25|testing|1949-07-08|2002-01-07 01:05:06|true|-393.22|-98765432109876543210.9876543210|
5252|12.25|sample|1987-04-09|2010-01-02 04:03:06|true|123.00|00000000000000000001.0000000000|
100|9.8777|STRING1|1923-04-08|2010-01-02 05:09:06|true|010.01|00000000000000000002.0000000000|
100|12.8788|string1|1922-04-02|2010-01-02 02:05:06|true|999.99|-99999999999999999999.9999999999|