Reputation
8,351
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
8 53 90
Impact
~482k people reached

Feb
8
comment COPY in TSV data enclosed by quotes; treat empty strings as NULLs
Right, what your latest edit shows is that Vertica has loaded empty strings, which isn't what I'm looking for. I want Vertica to load them as NULL values. From my question: "I'm trying to COPY this file into a table and have empty cells (i.e. "") be interpreted as NULLs, which fits the semantics I'm looking for."
Feb
8
comment COPY in TSV data enclosed by quotes; treat empty strings as NULLs
Are those blank values in the table NULLs or empty strings? What do you get for SELECT ISNULL(name, 'NULL') FROM bla;?
Feb
8
comment COPY in TSV data enclosed by quotes; treat empty strings as NULLs
Are you saying if I replace the tabs with pipes, then Vertica will automatically interpret the empty strings (i.e. "") as NULLs? Because that's not what I'm seeing.
Feb
2
asked COPY in TSV data enclosed by quotes; treat empty strings as NULLs
Jan
27
awarded  Good Question
Jan
15
awarded  Nice Answer
Jan
15
accepted Is Vertica's COPY atomic?
Jan
14
awarded  Tumbleweed
Jan
14
asked Is Vertica's COPY atomic?
Jan
10
awarded  Taxonomist
Jan
7
asked Getting “LDAP authentication failed” when connecting to Vertica via JDBC
Oct
27
awarded  Nice Question
Oct
19
awarded  Nice Question
Oct
11
awarded  Famous Question
Sep
24
awarded  Famous Question
Sep
24
awarded  Good Answer
Sep
18
awarded  Popular Question
Aug
13
awarded  Nice Question
Aug
10
awarded  Notable Question
Aug
7
comment Designing a platform: one database or multiple databases?
@azngunit81 - The different databases we went with just corresponded to different services: one for authentication, one for billing, one for entitlements, etc. It just fits the SOA design. If by your question you meant different database systems like Oracle vs. SQL Server, etc. then I think you misunderstood the discussion.