Bug 3846 - feature request: please allow multiple NULL AS null_string values for a COPY INTO line
Summary: feature request: please allow multiple NULL AS null_string values for a COPY ...
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: -- development
Hardware: All All
: Normal enhancement
Assignee: SQL devs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-02 16:19 CET by Anthony Damico
Modified: 2016-04-11 11:45 CEST (History)
1 user (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Anthony Damico 2015-11-02 16:19:28 CET
User-Agent:       Mozilla/5.0 (Windows NT 6.3; WOW64; rv:41.0) Gecko/20100101 Firefox/41.0
Build Identifier: 

no big deal if this is impossible, just a feature that would be nice to have.

the 2014 american community survey (something monetdb is good at) has started mixing fields where sometimes ",," is a NULL and other times ", ," is a NULL.

http://www2.census.gov/programs-surveys/acs/data/pums/2014/1-Year/

Reproducible: Always




here's what the first data line of that text file now looks like.

aside from the very first column, all columns are INTEGER


> readLines("ss14hak.csv",n=10)
 [1] "RT,SERIALNO,DIVISION,PUMA,REGION,ST,ADJHSG,ADJINC,WGTP,NP,TYPE,ACCESS,ACR,AGS,BATH,BDSP,BLD,BROADBND,BUS,COMPOTHX,CONP,DIALUP,DSL,ELEP,FIBEROP,FS,FULP,GASP,HANDHELD,HFL,INSP,LAPTOP,MHP,MODEM,MRGI,MRGP,MRGT,MRGX,OTHSVCEX,REFR,RMSP,RNTM,RNTP,RWAT,RWATPR,SATELLITE,SINK,SMP,STOV,TEL,TEN,TOIL,VACS,VALP,VEH,WATP,YBL,FES,FFINCP,FGRNTP,FHINCP,FINCP,FPARC,FPLMPRP,FSMOCP,GRNTP,GRPIP,HHL,HHT,HINCP,HOTWAT,HUGCL,HUPAC,HUPAOC,HUPARC,KIT,LNGI,MULTG,MV,NOC,NPF,NPP,NR,NRC,OCPIP,PARTNER,PLM,PLMPRP,PSF,R18,R60,R65,RESMODE,SMOCP,SMX,SRNT,SSMC,SVAL,TAXP,WIF,WKEXREL,WORKSTAT,FACCESSP,FACRP,FAGSP,FBATHP,FBDSP,FBLDP,FBROADBNDP,FBUSP,FCOMPOTHXP,FCONP,FDIALUPP,FDSLP,FELEP,FFIBEROPP,FFSP,FFULP,FGASP,FHANDHELDP,FHFLP,FHOTWATP,FINSP,FKITP,FLAPTOPP,FMHP,FMODEMP,FMRGIP,FMRGP,FMRGTP,FMRGXP,FMVP,FOTHSVCEXP,FPLMP,FREFRP,FRMSP,FRNTMP,FRNTP,FRWATP,FRWATPRP,FSATELLITEP,FSINKP,FSMP,FSMXHP,FSMXSP,FSTOVP,FTAXP,FTELP,FTENP,FTOILP,FVACSP,FVALP,FVEHP,FWATP,FYBLP,wgtp1,wgtp2,wgtp3,wgtp4,wgtp5,wgtp6,wgtp7,wgtp8,wgtp9,wgtp10,wgtp11,wgtp12,wgtp13,wgtp14,wgtp15,wgtp16,wgtp17,wgtp18,wgtp19,wgtp20,wgtp21,wgtp22,wgtp23,wgtp24,wgtp25,wgtp26,wgtp27,wgtp28,wgtp29,wgtp30,wgtp31,wgtp32,wgtp33,wgtp34,wgtp35,wgtp36,wgtp37,wgtp38,wgtp39,wgtp40,wgtp41,wgtp42,wgtp43,wgtp44,wgtp45,wgtp46,wgtp47,wgtp48,wgtp49,wgtp50,wgtp51,wgtp52,wgtp53,wgtp54,wgtp55,wgtp56,wgtp57,wgtp58,wgtp59,wgtp60,wgtp61,wgtp62,wgtp63,wgtp64,wgtp65,wgtp66,wgtp67,wgtp68,wgtp69,wgtp70,wgtp71,wgtp72,wgtp73,wgtp74,wgtp75,wgtp76,wgtp77,wgtp78,wgtp79,wgtp80"
 [2] "H,77,9,00400,4,02,1000000,1008425,00022,00,1,,1,,2,02,02,,2,, ,,, ,,, , ,,, ,, ,,, ,,,,1,03,, ,2,9,,2, ,1,,,2,7, ,, ,10,,0,0,0, ,,0,0, , ,,, ,9,,,,,2,,,, , ,,, , ,,2,9,,,,,2, ,,0,,0,,,,,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,00021,00009,00022,00039,00022,00025,00021,00036,00021,00039,00006,00021,00006,00023,00021,00022,00006,00009,00039,00022,00041,00021,00006,00025,00006,00006,00037,00022,00037,00021,00025,00040,00021,00040,00006,00009,00021,00025,00022,00037,00022,00006,00023,00036,00021,00021,00021,00036,00022,00038,00009,00024,00006,00021,00021,00024,00006,00006,00039,00025,00036,00022,00006,00022,00006,00009,00036,00021,00036,00021,00024,00036,00024,00036,00006,00006,00020,00022,00022,00038"