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
45
46
47
48
|
# name: test/sql/copy/csv/test_web_page.test
# description: Test copy from web_page csv
# group: [csv]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE web_page(wp_web_page_sk integer not null, wp_web_page_id char(16) not null, wp_rec_start_date date, wp_rec_end_date date, wp_creation_date_sk integer, wp_access_date_sk integer, wp_autogen_flag char(1), wp_customer_sk integer, wp_url varchar(100), wp_type char(50), wp_char_count integer, wp_link_count integer, wp_image_count integer, wp_max_ad_count integer, primary key (wp_web_page_sk));
query I
COPY web_page FROM '{DATA_DIR}/csv/real/web_page.csv' DELIMITER '|';
----
60
query ITTTIITITTIIII
SELECT * FROM web_page ORDER BY wp_web_page_sk LIMIT 3;
----
1 AAAAAAAABAAAAAAA 1997-09-03 NULL 2450810 2452620 Y 98539 http://www.foo.com welcome 2531 8 3 4
2 AAAAAAAACAAAAAAA 1997-09-03 2000-09-02 2450814 2452580 N NULL http://www.foo.com protected 1564 4 3 1
3 AAAAAAAACAAAAAAA 2000-09-03 NULL 2450814 2452611 N NULL http://www.foo.com feedback 1564 4 3 4
query I
COPY web_page TO '{TEMP_DIR}/web_page.csv' DELIMITER ' ' HEADER;
----
60
# clear the table
statement ok
DELETE FROM web_page;
query ITTTIITITTIIII
SELECT * FROM web_page;
----
# now copy back into the table
query I
COPY web_page FROM '{TEMP_DIR}/web_page.csv' DELIMITER ' ' HEADER;
----
60
query ITTTIITITTIIII
SELECT * FROM web_page ORDER BY wp_web_page_sk LIMIT 3;
----
1 AAAAAAAABAAAAAAA 1997-09-03 NULL 2450810 2452620 Y 98539 http://www.foo.com welcome 2531 8 3 4
2 AAAAAAAACAAAAAAA 1997-09-03 2000-09-02 2450814 2452580 N NULL http://www.foo.com protected 1564 4 3 1
3 AAAAAAAACAAAAAAA 2000-09-03 NULL 2450814 2452611 N NULL http://www.foo.com feedback 1564 4 3 4
|
