[
https://issues.apache.org/jira/browse/IGNITE-7539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kirill Shirokov updated IGNITE-7539:
------------------------------------
Description:
There should be a way to specify NULL field value in a file, which we import
via COPY command.
A popular solution among vendors for CSV format is to have a special escape
sequence for a NULL value in a field: \N for example.
We need to have a possibility to enable/disable null escape sequence handling
for all fields or on per-field basis.
Syntax example:
{noformat}
COPY
...
FORMAT CSV
...
[NULL='null-sequence']
{noformat}
was:
There should be a way to specify NULL field value in a file, which we import
via COPY command.
A popular solution among vendors for CSV format is to have a special escape
sequence for a NULL value in a field: \N for example.
We need to have a possibility to enable/disable null escape sequence handling
for all fields or on per-field basis.
> SQL COPY command: implement NULL escape sequence handling
> ---------------------------------------------------------
>
> Key: IGNITE-7539
> URL: https://issues.apache.org/jira/browse/IGNITE-7539
> Project: Ignite
> Issue Type: Improvement
> Reporter: Kirill Shirokov
> Priority: Major
>
> There should be a way to specify NULL field value in a file, which we import
> via COPY command.
> A popular solution among vendors for CSV format is to have a special escape
> sequence for a NULL value in a field: \N for example.
> We need to have a possibility to enable/disable null escape sequence handling
> for all fields or on per-field basis.
> Syntax example:
> {noformat}
> COPY
> ...
> FORMAT CSV
> ...
> [NULL='null-sequence']
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
