1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
# name: benchmark/csv/time_type.benchmark
# description: Run CSV scan with timestamp and date types
# group: [csv]
name CSV Read Benchmark with timestamp and date types
group csv
load
CREATE TABLE t1 AS select '30/07/1992', '30/07/1992 17:15:30';
insert into t1 select '30/07/1992', '30/07/1992 17:15:30' from range(0,10000000) tbl(i);
COPY t1 TO '${BENCHMARK_DIR}/time_timestamp.csv' (FORMAT CSV, HEADER 0);
run
SELECT * from read_csv('${BENCHMARK_DIR}/time_timestamp.csv',delim= ',', header = 0)
|
