1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
# name: test/sql/copy/csv/csv_copy_sniffer.test
# description: Test CSV sniffer copy
# group: [csv]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE sales (
salesid INTEGER NOT NULL PRIMARY KEY,
listid INTEGER NOT NULL,
sellerid INTEGER NOT NULL,
buyerid INTEGER NOT NULL,
eventid INTEGER NOT NULL,
dateid SMALLINT NOT NULL,
qtysold SMALLINT NOT NULL,
pricepaid DECIMAL (8,2),
commission DECIMAL (8,2),
saletime TIMESTAMP);
statement ok
COPY sales FROM '{DATA_DIR}/csv/sales_snippet.csv' (TIMESTAMPFORMAT '%m/%d/%Y %I:%M:%S', IGNORE_ERRORS true);
|
