[IGNITE-7539] SQL COPY command: implement NULL escape sequence handling

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Kirill Shirokov
• Created: 25/Jan/18 16:13
• Updated: 26/Jan/18 12:36

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:

COPY
    ...
    FORMAT CSV
        ...
        [NULL='null-sequence']

Issue Links

• is blocked by: IGNITE-6917 SQL: implement COPY command for efficient data loading
• is related to: IGNITE-7548 SQL COPY: handle CSV lines with less values than required correctly
• relates to: IGNITE-7372 Implement escape sequences handling in internal SQL parser
• relates to: IGNITE-7537 SQL COPY command: implement CSV format options