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
|
# name: test/sql/copy/csv/read_csv_variable.test
# description: Test reading CSV files where the file list comes from a table
# group: [csv]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE globbed_files AS FROM glob('{DATA_DIR}/csv/glob/a?/*.csv');
statement ok
SET VARIABLE csv_files=(SELECT LIST(file ORDER BY file) FROM globbed_files)
query I
SELECT [parse_path(x)[-2:] for x in getvariable('csv_files')]
----
[[a1, a1.csv], [a2, a2.csv], [a3, b1.csv]]
# simple globbing
query I
SELECT * FROM read_csv(getvariable('csv_files')) ORDER BY 1
----
2019-06-05
2019-06-15
2019-06-25
2019-07-05
2019-07-15
2019-07-25
2019-08-05
2019-08-15
2019-08-25
|
