1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# name: test/sql/copy/csv/test_cranlogs.test_slow
# description: Test cranlogs broken gzip copy and temp table
# group: [csv]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE cranlogs (date date,time string,size int,r_version string,r_arch string,r_os string,package string,version string,country string,ip_id int)
query I
COPY cranlogs FROM '{DATA_DIR}/csv/real/tmp2013-06-15.csv.gz';
----
37459
query TTITTTTTTI
SELECT * FROM cranlogs LIMIT 5
----
2013-06-15 00:18:11 46338 NA NA NA date 1.2-33 JP 1
2013-06-15 00:18:18 740765 NA NA NA plyr 1.8 JP 2
2013-06-15 00:54:25 1229408 NA NA NA RJSONIO 1.0-3 JP 3
2013-06-15 00:58:50 501915 2.15.3 x86_64 linux-gnu animation 2.2 IN 4
2013-06-15 00:14:52 254933 3.0.1 x86_64 linux-gnu foreign 0.8-54 HK 5
|
