diff options
Diffstat (limited to 'tests/fixtures/pretty.sql')
-rw-r--r-- | tests/fixtures/pretty.sql | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/tests/fixtures/pretty.sql b/tests/fixtures/pretty.sql index 8de9c85..46cd6d8 100644 --- a/tests/fixtures/pretty.sql +++ b/tests/fixtures/pretty.sql @@ -178,10 +178,23 @@ FROM ( ) AS x; INSERT OVERWRITE TABLE x VALUES (1, 2.0, '3.0'), (4, 5.0, '6.0'); -INSERT OVERWRITE TABLE x VALUES +INSERT OVERWRITE TABLE x +VALUES (1, 2.0, '3.0'), (4, 5.0, '6.0'); +INSERT INTO TABLE foo REPLACE WHERE cond SELECT * FROM bar; +INSERT INTO foo +REPLACE WHERE cond +SELECT + * +FROM bar; + +INSERT OVERWRITE TABLE zipcodes PARTITION(state = '0') VALUES (896, 'US', 'TAMPA', 33607); +INSERT OVERWRITE TABLE zipcodes PARTITION(state = '0') +VALUES + (896, 'US', 'TAMPA', 33607); + WITH regional_sales AS ( SELECT region, SUM(amount) AS total_sales FROM orders |