i am having a hard time figuring out how to make this example more minimal.
this problem first occurred on proprietary data, but i was able to reproduce the problem on the american community survey.
i tried to reproduce it on two smaller data sets, but the problem did not recur.
so i am not sure what is going on, but mserver5.exe just dies on me.
happens every time. it'll just take a bit of time to load the ACS. sorry
Reproducible: Always
Steps to Reproduce:
LOAD the 2013 AMERICAN COMMUNITY SURVEY
options( "monetdb.sequential" = TRUE ) only windows users need this line
path.to.7z <- "7za" only macintosh and *nix users need this line
library(downloader)
setwd( "C:/My Directory/ACS/" )
single.year.datasets.to.download <- 2013
three.year.datasets.to.download <- NULL
five.year.datasets.to.download <- NULL
source_url( "https://raw.github.com/ajdamico/usgsd/master/American%20Community%20Survey/download%20all%20microdata.R" , prompt = FALSE , echo = TRUE )
once it's loaded on your computer, connect to it with these lines
library(MonetDB.R)
batfile <- "C:/My Directory/ACS/MonetDB/acs.bat" note for mac and *nix users: acs.bat might be acs.sh instead
second: run the MonetDB server
pid <- monetdb.server.start( batfile )
third: your five lines to make a monet database connection.
just like above, mine look like this:
dbname <- "acs"
dbport <- 50001
once you are connected, this will cause the server to crash!
distinct_state <- sort( dbGetQuery( db , 'select distinct st from acs2013_1yr_m' )[ , 1 ] )
sql <-
paste0(
"CREATE TABLE test AS
( SELECT puma , serialno , " ,
paste0( "MAX( 1*( st = '" , distinct_state , "' ) ) AS thergrp_" , distinct_state , collapse = " , " ) ,
" FROM ( SELECT DISTINCT puma , serialno , st FROM acs2013_1yr_m ) AS z GROUP BY puma , serialno ) WITH DATA"
)
dbSendQuery( db , sql )
SERVER CRASHES
Actual Results:
mserver5.exe dies
when i run with monetdb.debug.mapi = TRUE here's the output -- it crashes at the end of this. nothing informative.
dbSendQuery( db , sql )
TX: 'sCREATE TABLE test AS
( SELECT puma , serialno , MAX( 1*( st = '1' ) ) AS thergrp_1 , MAX( 1*( st = '2' ) ) AS thergrp_2 , MAX( 1*( st = '4' ) ) AS thergrp_4 , MAX( 1*( st = '5' ) ) AS thergrp_5 , MAX( 1*( st = '6' ) ) AS thergrp_6 , MAX( 1*( st = '8' ) ) AS thergrp_8 , MAX( 1*( st = '9' ) ) AS thergrp_9 , MAX( 1*( st = '10' ) ) AS thergrp_10 , MAX( 1*( st = '11' ) ) AS thergrp_11 , MAX( 1*( st = '12' ) ) AS thergrp_12 , MAX( 1*( st = '13' ) ) AS thergrp_13 , MAX( 1*( st = '15' ) ) AS thergrp_15 , MAX( 1*( st = '16' ) ) AS thergrp_16 , MAX( 1*( st = '17' ) ) AS thergrp_17 , MAX( 1*( st = '18' ) ) AS thergrp_18 , MAX( 1*( st = '19' ) ) AS thergrp_19 , MAX( 1*( st = '20' ) ) AS thergrp_20 , MAX( 1*( st = '21' ) ) AS thergrp_21 , MAX( 1*( st = '22' ) ) AS thergrp_22 , MAX( 1*( st = '23' ) ) AS thergrp_23 , MAX( 1*( st = '24' ) ) AS thergrp_24 , MAX( 1*( st = '25' ) ) AS thergrp_25 , MAX( 1*( st = '26' ) ) AS thergrp_26 , MAX( 1*( st = '27' ) ) AS thergrp_27 , MAX( 1*( st = '28' ) ) AS thergrp_28 , MAX( 1*( st = '29' ) ) AS thergrp_29 , MAX( 1*( st = '30' ) ) AS thergrp_30 , MAX( 1*( st = '31' ) ) AS thergrp_31 , MAX( 1*( st = '32' ) ) AS thergrp_32 , MAX( 1*( st = '33' ) ) AS thergrp_33 , MAX( 1*( st = '34' ) ) AS thergrp_34 , MAX( 1*( st = '35' ) ) AS thergrp_35 , MAX( 1*( st = '36' ) ) AS thergrp_36 , MAX( 1*( st = '37' ) ) AS thergrp_37 , MAX( 1*( st = '38' ) ) AS thergrp_38 , MAX( 1*( st = '39' ) ) AS thergrp_39 , MAX( 1*( st = '40' ) ) AS thergrp_40 , MAX( 1*( st = '41' ) ) AS thergrp_41 , MAX( 1*( st = '42' ) ) AS thergrp_42 , MAX( 1*( st = '44' ) ) AS thergrp_44 , MAX( 1*( st = '45' ) ) AS thergrp_45 , MAX( 1*( st = '46' ) ) AS thergrp_46 , MAX( 1*( st = '47' ) ) AS thergrp_47 , MAX( 1*( st = '48' ) ) AS thergrp_48 , MAX( 1*( st = '49' ) ) AS thergrp_49 , MAX( 1*( st = '50' ) ) AS thergrp_50 , MAX( 1*( st = '51' ) ) AS thergrp_51 , MAX( 1*( st = '53' ) ) AS thergrp_53 , MAX( 1*( st = '54' ) ) AS thergrp_54 , MAX( 1*( st = '55' ) ) AS thergrp_55 , MAX( 1*( st = '56' ) ) AS thergrp_56 FROM ( SELECT DISTINCT puma , serialno , st FROM acs2013_1yr_m ) AS z GROUP BY puma , serialno ) WITH DATA
;'
RX: ''
An object of class "MonetDBResult"
Slot "env":
<environment: 0x0585f1ac>
Expected Results:
a table not a crash :(
MonetDB 5 server v11.19.13 "Oct2014-SP4"
Serving database 'acs', using 4 threads
Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
Found 64.000 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:50001/
MonetDB/SQL module loaded
sessionInfo()
R version 3.2.1 (2015-06-18)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows Server 2008 R2 x64 (build 7601) Service Pack 1
Can't reproduce crash on Oct2014 with OSX. Will try on Windows next.
Offending Query:
CREATE TABLE test AS
( SELECT puma , serialno , MAX( 1*( st = '1' ) ) AS thergrp_1 , MAX( 1*( st = '2' ) ) AS thergrp_2 , MAX( 1*( st = '4' ) ) AS thergrp_4 , MAX( 1*( st = '5' ) ) AS thergrp_5 , MAX( 1*( st = '6' ) ) AS thergrp_6 , MAX( 1*( st = '8' ) ) AS thergrp_8 , MAX( 1*( st = '9' ) ) AS thergrp_9 , MAX( 1*( st = '10' ) ) AS thergrp_10 , MAX( 1*( st = '11' ) ) AS thergrp_11 , MAX( 1*( st = '12' ) ) AS thergrp_12 , MAX( 1*( st = '13' ) ) AS thergrp_13 , MAX( 1*( st = '15' ) ) AS thergrp_15 , MAX( 1*( st = '16' ) ) AS thergrp_16 , MAX( 1*( st = '17' ) ) AS thergrp_17 , MAX( 1*( st = '18' ) ) AS thergrp_18 , MAX( 1*( st = '19' ) ) AS thergrp_19 , MAX( 1*( st = '20' ) ) AS thergrp_20 , MAX( 1*( st = '21' ) ) AS thergrp_21 , MAX( 1*( st = '22' ) ) AS thergrp_22 , MAX( 1*( st = '23' ) ) AS thergrp_23 , MAX( 1*( st = '24' ) ) AS thergrp_24 , MAX( 1*( st = '25' ) ) AS thergrp_25 , MAX( 1*( st = '26' ) ) AS thergrp_26 , MAX( 1*( st = '27' ) ) AS thergrp_27 , MAX( 1*( st = '28' ) ) AS thergrp_28 , MAX( 1*( st = '29' ) ) AS thergrp_29 , MAX( 1*( st = '30' ) ) AS thergrp_30 , MAX( 1*( st = '31' ) ) AS thergrp_31 , MAX( 1*( st = '32' ) ) AS thergrp_32 , MAX( 1*( st = '33' ) ) AS thergrp_33 , MAX( 1*( st = '34' ) ) AS thergrp_34 , MAX( 1*( st = '35' ) ) AS thergrp_35 , MAX( 1*( st = '36' ) ) AS thergrp_36 , MAX( 1*( st = '37' ) ) AS thergrp_37 , MAX( 1*( st = '38' ) ) AS thergrp_38 , MAX( 1*( st = '39' ) ) AS thergrp_39 , MAX( 1*( st = '40' ) ) AS thergrp_40 , MAX( 1*( st = '41' ) ) AS thergrp_41 , MAX( 1*( st = '42' ) ) AS thergrp_42 , MAX( 1*( st = '44' ) ) AS thergrp_44 , MAX( 1*( st = '45' ) ) AS thergrp_45 , MAX( 1*( st = '46' ) ) AS thergrp_46 , MAX( 1*( st = '47' ) ) AS thergrp_47 , MAX( 1*( st = '48' ) ) AS thergrp_48 , MAX( 1*( st = '49' ) ) AS thergrp_49 , MAX( 1*( st = '50' ) ) AS thergrp_50 , MAX( 1*( st = '51' ) ) AS thergrp_51 , MAX( 1*( st = '53' ) ) AS thergrp_53 , MAX( 1*( st = '54' ) ) AS thergrp_54 , MAX( 1*( st = '55' ) ) AS thergrp_55 , MAX( 1*( st = '56' ) ) AS thergrp_56 FROM ( SELECT DISTINCT puma , serialno , st FROM acs2013_1yr_m ) AS z GROUP BY puma , serialno ) WITH DATA
Date: 2015-08-03 23:31:24 +0200
From: Anthony Damico <>
To: SQL devs <>
Version: 11.19.15 (Oct2014-SP4)
CC: ajdamico, @hannesmuehleisen
Last updated: 2015-08-28 13:41:32 +0200
Comment 21095
Date: 2015-08-03 23:31:24 +0200
From: Anthony Damico <>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0
Build Identifier:
i am having a hard time figuring out how to make this example more minimal.
this problem first occurred on proprietary data, but i was able to reproduce the problem on the american community survey.
i tried to reproduce it on two smaller data sets, but the problem did not recur.
so i am not sure what is going on, but mserver5.exe just dies on me.
happens every time. it'll just take a bit of time to load the ACS. sorry
Reproducible: Always
Steps to Reproduce:
LOAD the 2013 AMERICAN COMMUNITY SURVEY
options( "monetdb.sequential" = TRUE ) only windows users need this line
path.to.7z <- "7za" only macintosh and *nix users need this line
library(downloader)
setwd( "C:/My Directory/ACS/" )
single.year.datasets.to.download <- 2013
three.year.datasets.to.download <- NULL
five.year.datasets.to.download <- NULL
source_url( "https://raw.github.com/ajdamico/usgsd/master/American%20Community%20Survey/download%20all%20microdata.R" , prompt = FALSE , echo = TRUE )
library(MonetDB.R)
batfile <- "C:/My Directory/ACS/MonetDB/acs.bat" note for mac and *nix users:
acs.batmight beacs.shinsteadsecond: run the MonetDB server
pid <- monetdb.server.start( batfile )
third: your five lines to make a monet database connection.
just like above, mine look like this:
dbname <- "acs"
dbport <- 50001
monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname )
db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
distinct_state <- sort( dbGetQuery( db , 'select distinct st from acs2013_1yr_m' )[ , 1 ] )
sql <-
paste0(
"CREATE TABLE test AS
( SELECT puma , serialno , " ,
dbSendQuery( db , sql )
SERVER CRASHES
Actual Results:
mserver5.exe dies
when i run with monetdb.debug.mapi = TRUE here's the output -- it crashes at the end of this. nothing informative.
RX: ''
An object of class "MonetDBResult"
Slot "env":
<environment: 0x0585f1ac>
Expected Results:
a table not a crash :(
MonetDB 5 server v11.19.13 "Oct2014-SP4"
Serving database 'acs', using 4 threads
Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
Found 64.000 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:50001/
MonetDB/SQL module loaded
locale:
[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] MonetDB.R_1.0.0 DBI_0.3.1
loaded via a namespace (and not attached):
[1] codetools_0.2-11 digest_0.6.8
Comment 21100
Date: 2015-08-05 15:05:36 +0200
From: @hannesmuehleisen
Can't reproduce crash on Oct2014 with OSX. Will try on Windows next.
Offending Query:
CREATE TABLE test AS
( SELECT puma , serialno , MAX( 1*( st = '1' ) ) AS thergrp_1 , MAX( 1*( st = '2' ) ) AS thergrp_2 , MAX( 1*( st = '4' ) ) AS thergrp_4 , MAX( 1*( st = '5' ) ) AS thergrp_5 , MAX( 1*( st = '6' ) ) AS thergrp_6 , MAX( 1*( st = '8' ) ) AS thergrp_8 , MAX( 1*( st = '9' ) ) AS thergrp_9 , MAX( 1*( st = '10' ) ) AS thergrp_10 , MAX( 1*( st = '11' ) ) AS thergrp_11 , MAX( 1*( st = '12' ) ) AS thergrp_12 , MAX( 1*( st = '13' ) ) AS thergrp_13 , MAX( 1*( st = '15' ) ) AS thergrp_15 , MAX( 1*( st = '16' ) ) AS thergrp_16 , MAX( 1*( st = '17' ) ) AS thergrp_17 , MAX( 1*( st = '18' ) ) AS thergrp_18 , MAX( 1*( st = '19' ) ) AS thergrp_19 , MAX( 1*( st = '20' ) ) AS thergrp_20 , MAX( 1*( st = '21' ) ) AS thergrp_21 , MAX( 1*( st = '22' ) ) AS thergrp_22 , MAX( 1*( st = '23' ) ) AS thergrp_23 , MAX( 1*( st = '24' ) ) AS thergrp_24 , MAX( 1*( st = '25' ) ) AS thergrp_25 , MAX( 1*( st = '26' ) ) AS thergrp_26 , MAX( 1*( st = '27' ) ) AS thergrp_27 , MAX( 1*( st = '28' ) ) AS thergrp_28 , MAX( 1*( st = '29' ) ) AS thergrp_29 , MAX( 1*( st = '30' ) ) AS thergrp_30 , MAX( 1*( st = '31' ) ) AS thergrp_31 , MAX( 1*( st = '32' ) ) AS thergrp_32 , MAX( 1*( st = '33' ) ) AS thergrp_33 , MAX( 1*( st = '34' ) ) AS thergrp_34 , MAX( 1*( st = '35' ) ) AS thergrp_35 , MAX( 1*( st = '36' ) ) AS thergrp_36 , MAX( 1*( st = '37' ) ) AS thergrp_37 , MAX( 1*( st = '38' ) ) AS thergrp_38 , MAX( 1*( st = '39' ) ) AS thergrp_39 , MAX( 1*( st = '40' ) ) AS thergrp_40 , MAX( 1*( st = '41' ) ) AS thergrp_41 , MAX( 1*( st = '42' ) ) AS thergrp_42 , MAX( 1*( st = '44' ) ) AS thergrp_44 , MAX( 1*( st = '45' ) ) AS thergrp_45 , MAX( 1*( st = '46' ) ) AS thergrp_46 , MAX( 1*( st = '47' ) ) AS thergrp_47 , MAX( 1*( st = '48' ) ) AS thergrp_48 , MAX( 1*( st = '49' ) ) AS thergrp_49 , MAX( 1*( st = '50' ) ) AS thergrp_50 , MAX( 1*( st = '51' ) ) AS thergrp_51 , MAX( 1*( st = '53' ) ) AS thergrp_53 , MAX( 1*( st = '54' ) ) AS thergrp_54 , MAX( 1*( st = '55' ) ) AS thergrp_55 , MAX( 1*( st = '56' ) ) AS thergrp_56 FROM ( SELECT DISTINCT puma , serialno , st FROM acs2013_1yr_m ) AS z GROUP BY puma , serialno ) WITH DATA
Schema:
CREATE TABLE "sys"."acs2013_1yr_m" (
"rt" CHAR(1),
"serialno" INTEGER,
"division" INTEGER,
"puma" INTEGER,
"region" INTEGER,
"st" INTEGER,
"adjhsg" INTEGER,
"adjinc" INTEGER,
"wgtp" INTEGER,
"np" INTEGER,
"type_" INTEGER,
"access" INTEGER,
"acr" INTEGER,
"ags" INTEGER,
"bath" INTEGER,
"bdsp" INTEGER,
"bld" INTEGER,
"broadbnd" INTEGER,
"bus" INTEGER,
"compothx" INTEGER,
"conp" INTEGER,
"dialup" INTEGER,
"dsl" INTEGER,
"elep" INTEGER,
"fiberop" INTEGER,
"fs" INTEGER,
"fulp" INTEGER,
"gasp" INTEGER,
"handheld" INTEGER,
"hfl" INTEGER,
"insp" INTEGER,
"laptop" INTEGER,
"mhp" INTEGER,
"modem" INTEGER,
"mrgi" INTEGER,
"mrgp" INTEGER,
"mrgt" INTEGER,
"mrgx" INTEGER,
"othsvcex" INTEGER,
"refr" INTEGER,
"rmsp" INTEGER,
"rntm" INTEGER,
"rntp" INTEGER,
"rwat" INTEGER,
"rwatpr" INTEGER,
"satellite" INTEGER,
"sink" INTEGER,
"smp" INTEGER,
"stov" INTEGER,
"tel" INTEGER,
"ten" INTEGER,
"toil" INTEGER,
"vacs" INTEGER,
"valp" INTEGER,
"veh" INTEGER,
"watp" INTEGER,
"ybl" INTEGER,
"fes" INTEGER,
"ffincp" INTEGER,
"fgrntp" INTEGER,
"fhincp" INTEGER,
"fincp" INTEGER,
"fparc" INTEGER,
"fsmocp" INTEGER,
"grntp" INTEGER,
"grpip" INTEGER,
"hhl" INTEGER,
"hht" INTEGER,
"hincp" INTEGER,
"hugcl" INTEGER,
"hupac" INTEGER,
"hupaoc" INTEGER,
"huparc" INTEGER,
"kit" INTEGER,
"lngi" INTEGER,
"multg" INTEGER,
"mv" INTEGER,
"noc" INTEGER,
"npf" INTEGER,
"npp" INTEGER,
"nr" INTEGER,
"nrc" INTEGER,
"ocpip" INTEGER,
"partner" INTEGER,
"plm" INTEGER,
"psf" INTEGER,
"r18" INTEGER,
"r60" INTEGER,
"r65" INTEGER,
"resmode" INTEGER,
"smocp" INTEGER,
"smx" INTEGER,
"srnt" INTEGER,
"ssmc" INTEGER,
"sval" INTEGER,
"taxp" INTEGER,
"wif" INTEGER,
"wkexrel" INTEGER,
"workstat" INTEGER,
"faccessp" INTEGER,
"facrp" INTEGER,
"fagsp" INTEGER,
"fbathp" INTEGER,
"fbdsp" INTEGER,
"fbldp" INTEGER,
"fbroadbndp" INTEGER,
"fbusp" INTEGER,
"fcompothxp" INTEGER,
"fconp" INTEGER,
"fdialupp" INTEGER,
"fdslp" INTEGER,
"felep" INTEGER,
"ffiberopp" INTEGER,
"ffsp" INTEGER,
"ffulp" INTEGER,
"fgasp" INTEGER,
"fhandheldp" INTEGER,
"fhflp" INTEGER,
"finsp" INTEGER,
"fkitp" INTEGER,
"flaptopp" INTEGER,
"fmhp" INTEGER,
"fmodemp" INTEGER,
"fmrgip" INTEGER,
"fmrgp" INTEGER,
"fmrgtp" INTEGER,
"fmrgxp" INTEGER,
"fmvp" INTEGER,
"fothsvcexp" INTEGER,
"fplmp" INTEGER,
"frefrp" INTEGER,
"frmsp" INTEGER,
"frntmp" INTEGER,
"frntp" INTEGER,
"frwatp" INTEGER,
"frwatprp" INTEGER,
"fsatellitep" INTEGER,
"fsinkp" INTEGER,
"fsmp" INTEGER,
"fsmxhp" INTEGER,
"fsmxsp" INTEGER,
"fstovp" INTEGER,
"ftaxp" INTEGER,
"ftelp" INTEGER,
"ftenp" INTEGER,
"ftoilp" INTEGER,
"fvacsp" INTEGER,
"fvalp" INTEGER,
"fvehp" INTEGER,
"fwatp" INTEGER,
"fyblp" INTEGER,
"wgtp1" INTEGER,
"wgtp2" INTEGER,
"wgtp3" INTEGER,
"wgtp4" INTEGER,
"wgtp5" INTEGER,
"wgtp6" INTEGER,
"wgtp7" INTEGER,
"wgtp8" INTEGER,
"wgtp9" INTEGER,
"wgtp10" INTEGER,
"wgtp11" INTEGER,
"wgtp12" INTEGER,
"wgtp13" INTEGER,
"wgtp14" INTEGER,
"wgtp15" INTEGER,
"wgtp16" INTEGER,
"wgtp17" INTEGER,
"wgtp18" INTEGER,
"wgtp19" INTEGER,
"wgtp20" INTEGER,
"wgtp21" INTEGER,
"wgtp22" INTEGER,
"wgtp23" INTEGER,
"wgtp24" INTEGER,
"wgtp25" INTEGER,
"wgtp26" INTEGER,
"wgtp27" INTEGER,
"wgtp28" INTEGER,
"wgtp29" INTEGER,
"wgtp30" INTEGER,
"wgtp31" INTEGER,
"wgtp32" INTEGER,
"wgtp33" INTEGER,
"wgtp34" INTEGER,
"wgtp35" INTEGER,
"wgtp36" INTEGER,
"wgtp37" INTEGER,
"wgtp38" INTEGER,
"wgtp39" INTEGER,
"wgtp40" INTEGER,
"wgtp41" INTEGER,
"wgtp42" INTEGER,
"wgtp43" INTEGER,
"wgtp44" INTEGER,
"wgtp45" INTEGER,
"wgtp46" INTEGER,
"wgtp47" INTEGER,
"wgtp48" INTEGER,
"wgtp49" INTEGER,
"wgtp50" INTEGER,
"wgtp51" INTEGER,
"wgtp52" INTEGER,
"wgtp53" INTEGER,
"wgtp54" INTEGER,
"wgtp55" INTEGER,
"wgtp56" INTEGER,
"wgtp57" INTEGER,
"wgtp58" INTEGER,
"wgtp59" INTEGER,
"wgtp60" INTEGER,
"wgtp61" INTEGER,
"wgtp62" INTEGER,
"wgtp63" INTEGER,
"wgtp64" INTEGER,
"wgtp65" INTEGER,
"wgtp66" INTEGER,
"wgtp67" INTEGER,
"wgtp68" INTEGER,
"wgtp69" INTEGER,
"wgtp70" INTEGER,
"wgtp71" INTEGER,
"wgtp72" INTEGER,
"wgtp73" INTEGER,
"wgtp74" INTEGER,
"wgtp75" INTEGER,
"wgtp76" INTEGER,
"wgtp77" INTEGER,
"wgtp78" INTEGER,
"wgtp79" INTEGER,
"wgtp80" INTEGER,
"sporder" INTEGER,
"pwgtp" INTEGER,
"agep" INTEGER,
"cit" INTEGER,
"citwp" INTEGER,
"cow" INTEGER,
"ddrs" INTEGER,
"dear" INTEGER,
"deye" INTEGER,
"dout" INTEGER,
"dphy" INTEGER,
"drat" INTEGER,
"dratx" INTEGER,
"drem" INTEGER,
"eng" INTEGER,
"fer" INTEGER,
"gcl" INTEGER,
"gcm" INTEGER,
"gcr" INTEGER,
"hins1" INTEGER,
"hins2" INTEGER,
"hins3" INTEGER,
"hins4" INTEGER,
"hins5" INTEGER,
"hins6" INTEGER,
"hins7" INTEGER,
"intp" INTEGER,
"jwmnp" INTEGER,
"jwrip" INTEGER,
"jwtr" INTEGER,
"lanx" INTEGER,
"mar" INTEGER,
"marhd" INTEGER,
"marhm" INTEGER,
"marht" INTEGER,
"marhw" INTEGER,
"marhyp" INTEGER,
"mig" INTEGER,
"mil" INTEGER,
"mlpa" INTEGER,
"mlpb" INTEGER,
"mlpcd" INTEGER,
"mlpe" INTEGER,
"mlpfg" INTEGER,
"mlph" INTEGER,
"mlpi" INTEGER,
"mlpj" INTEGER,
"mlpk" INTEGER,
"nwab" INTEGER,
"nwav" INTEGER,
"nwla" INTEGER,
"nwlk" INTEGER,
"nwre" INTEGER,
"oip" INTEGER,
"pap" INTEGER,
"relp" INTEGER,
"retp" INTEGER,
"sch" INTEGER,
"schg" INTEGER,
"schl" INTEGER,
"semp" INTEGER,
"sex" INTEGER,
"ssip" INTEGER,
"ssp" INTEGER,
"wagp" INTEGER,
"wkhp" INTEGER,
"wkl" INTEGER,
"wkw" INTEGER,
"wrk" INTEGER,
"yoep" INTEGER,
"anc" INTEGER,
"anc1p" INTEGER,
"anc2p" INTEGER,
"decade" INTEGER,
"dis" INTEGER,
"drivesp" INTEGER,
"esp" INTEGER,
"esr" INTEGER,
"fod1p" INTEGER,
"fod2p" INTEGER,
"hicov" INTEGER,
"hisp" INTEGER,
"indp" INTEGER,
"jwap" INTEGER,
"jwdp" INTEGER,
"lanp" INTEGER,
"migpuma" INTEGER,
"migsp" INTEGER,
"msp" INTEGER,
"naicsp" VARCHAR(255),
"nativity" INTEGER,
"nop" INTEGER,
"oc" INTEGER,
"occp" INTEGER,
"paoc" INTEGER,
"pernp" INTEGER,
"pincp" INTEGER,
"pobp" INTEGER,
"povpip" INTEGER,
"powpuma" INTEGER,
"powsp" INTEGER,
"privcov" INTEGER,
"pubcov" INTEGER,
"qtrbir" INTEGER,
"rac1p" INTEGER,
"rac2p" INTEGER,
"rac3p" INTEGER,
"racaian" INTEGER,
"racasn" INTEGER,
"racblk" INTEGER,
"racnh" INTEGER,
"racnum" INTEGER,
"racpi" INTEGER,
"racsor" INTEGER,
"racwht" INTEGER,
"rc" INTEGER,
"sciengp" INTEGER,
"sciengrlp" INTEGER,
"sfn" INTEGER,
"sfr" INTEGER,
"socp" VARCHAR(255),
"vps" INTEGER,
"waob" INTEGER,
"fagep" INTEGER,
"fancp" INTEGER,
"fcitp" INTEGER,
"fcitwp" INTEGER,
"fcowp" INTEGER,
"fddrsp" INTEGER,
"fdearp" INTEGER,
"fdeyep" INTEGER,
"fdisp" INTEGER,
"fdoutp" INTEGER,
"fdphyp" INTEGER,
"fdratp" INTEGER,
"fdratxp" INTEGER,
"fdremp" INTEGER,
"fengp" INTEGER,
"fesrp" INTEGER,
"fferp" INTEGER,
"ffodp" INTEGER,
"fgclp" INTEGER,
"fgcmp" INTEGER,
"fgcrp" INTEGER,
"fhins1p" INTEGER,
"fhins2p" INTEGER,
"fhins3c" INTEGER,
"fhins3p" INTEGER,
"fhins4c" INTEGER,
"fhins4p" INTEGER,
"fhins5c" INTEGER,
"fhins5p" INTEGER,
"fhins6p" INTEGER,
"fhins7p" INTEGER,
"fhisp" INTEGER,
"findp" INTEGER,
"fintp" INTEGER,
"fjwdp" INTEGER,
"fjwmnp" INTEGER,
"fjwrip" INTEGER,
"fjwtrp" INTEGER,
"flanp" INTEGER,
"flanxp" INTEGER,
"fmarhdp" INTEGER,
"fmarhmp" INTEGER,
"fmarhtp" INTEGER,
"fmarhwp" INTEGER,
"fmarhyp" INTEGER,
"fmarp" INTEGER,
"fmigp" INTEGER,
"fmigsp" INTEGER,
"fmilpp" INTEGER,
"fmilsp" INTEGER,
"foccp" INTEGER,
"foip" INTEGER,
"fpap" INTEGER,
"fpernp" INTEGER,
"fpincp" INTEGER,
"fpobp" INTEGER,
"fpowsp" INTEGER,
"fprivcovp" INTEGER,
"fpubcovp" INTEGER,
"fracp" INTEGER,
"frelp" INTEGER,
"fretp" INTEGER,
"fschgp" INTEGER,
"fschlp" INTEGER,
"fschp" INTEGER,
"fsemp" INTEGER,
"fsexp" INTEGER,
"fssip" INTEGER,
"fssp" INTEGER,
"fwagp" INTEGER,
"fwkhp" INTEGER,
"fwklp" INTEGER,
"fwkwp" INTEGER,
"fwrkp" INTEGER,
"fyoep" INTEGER,
"pwgtp1" INTEGER,
"pwgtp2" INTEGER,
"pwgtp3" INTEGER,
"pwgtp4" INTEGER,
"pwgtp5" INTEGER,
"pwgtp6" INTEGER,
"pwgtp7" INTEGER,
"pwgtp8" INTEGER,
"pwgtp9" INTEGER,
"pwgtp10" INTEGER,
"pwgtp11" INTEGER,
"pwgtp12" INTEGER,
"pwgtp13" INTEGER,
"pwgtp14" INTEGER,
"pwgtp15" INTEGER,
"pwgtp16" INTEGER,
"pwgtp17" INTEGER,
"pwgtp18" INTEGER,
"pwgtp19" INTEGER,
"pwgtp20" INTEGER,
"pwgtp21" INTEGER,
"pwgtp22" INTEGER,
"pwgtp23" INTEGER,
"pwgtp24" INTEGER,
"pwgtp25" INTEGER,
"pwgtp26" INTEGER,
"pwgtp27" INTEGER,
"pwgtp28" INTEGER,
"pwgtp29" INTEGER,
"pwgtp30" INTEGER,
"pwgtp31" INTEGER,
"pwgtp32" INTEGER,
"pwgtp33" INTEGER,
"pwgtp34" INTEGER,
"pwgtp35" INTEGER,
"pwgtp36" INTEGER,
"pwgtp37" INTEGER,
"pwgtp38" INTEGER,
"pwgtp39" INTEGER,
"pwgtp40" INTEGER,
"pwgtp41" INTEGER,
"pwgtp42" INTEGER,
"pwgtp43" INTEGER,
"pwgtp44" INTEGER,
"pwgtp45" INTEGER,
"pwgtp46" INTEGER,
"pwgtp47" INTEGER,
"pwgtp48" INTEGER,
"pwgtp49" INTEGER,
"pwgtp50" INTEGER,
"pwgtp51" INTEGER,
"pwgtp52" INTEGER,
"pwgtp53" INTEGER,
"pwgtp54" INTEGER,
"pwgtp55" INTEGER,
"pwgtp56" INTEGER,
"pwgtp57" INTEGER,
"pwgtp58" INTEGER,
"pwgtp59" INTEGER,
"pwgtp60" INTEGER,
"pwgtp61" INTEGER,
"pwgtp62" INTEGER,
"pwgtp63" INTEGER,
"pwgtp64" INTEGER,
"pwgtp65" INTEGER,
"pwgtp66" INTEGER,
"pwgtp67" INTEGER,
"pwgtp68" INTEGER,
"pwgtp69" INTEGER,
"pwgtp70" INTEGER,
"pwgtp71" INTEGER,
"pwgtp72" INTEGER,
"pwgtp73" INTEGER,
"pwgtp74" INTEGER,
"pwgtp75" INTEGER,
"pwgtp76" INTEGER,
"pwgtp77" INTEGER,
"pwgtp78" INTEGER,
"pwgtp79" INTEGER,
"pwgtp80" INTEGER,
"one" INTEGER,
"idkey" INTEGER auto_increment
);
Data:
http://wikistats.ins.cwi.nl/lsde-data/acstbl.csv.bz2 (600MB, default delimiters)
Comment 21101
Date: 2015-08-05 16:33:34 +0200
From: Anthony Damico <>
https://youtu.be/tfQs7WbVse8?t=85
Comment 21102
Date: 2015-08-05 16:35:50 +0200
From: @hannesmuehleisen
Confirmed this on Windows 7 with the Oct 2014 branch.
Comment 21103
Date: 2015-08-05 16:51:30 +0200
From: @hannesmuehleisen
Works fine in Jul branch, used build from http://monetdb.cwi.nl/testweb/web/56485:aebfa751b214/MonetDB5-SQL-Installer-x86_64-aebfa751b214.msi
Comment 21179
Date: 2015-08-28 13:41:32 +0200
From: @sjoerdmullender
Jul2015 has been released.
The text was updated successfully, but these errors were encountered: