1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
# name: test/sql/sample/can_sample_from_ingested_files.test
# description: Test reservoir sample crash on large data sets
# group: [sample]
require parquet
statement ok
PRAGMA enable_verification;
statement ok
create table all_types as select * exclude(small_enum, medium_enum, large_enum, "union", bit) from test_all_types();
statement ok
copy all_types to '__TEST_DIR__/sample_all_types.csv' (FORMAT CSV);
statement ok
Create table all_types_csv_1 as select * from read_csv_auto('__TEST_DIR__/sample_all_types.csv');
statement ok
Create table all_types_csv_2 as select * from read_csv_auto('__TEST_DIR__/sample_all_types.csv');
query T nosort result_1
select * from all_types_csv_1;
query T nosort result_1
select * from all_types_csv_2;
statement ok
copy (SELECT * from all_types) to '__TEST_DIR__/sample_all_types.parquet' (FORMAT PARQUET);
# test parquet
statement ok
Create table all_types_parquet_1 as select * from read_parquet('__TEST_DIR__/sample_all_types.parquet');
statement ok
Create table all_types_parquet_2 as select * from read_parquet('__TEST_DIR__/sample_all_types.parquet');
query T nosort result_parquet
select * from all_types_parquet_1;
query T nosort result_paruet
select * from all_types_parquet_2;
|
