importccl: DELIMITED should match more closely the functionality of mysql's LOAD INTO #40959
Labels
A-disaster-recovery
A-sql-semantics
C-enhancement
Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Currently
DELIMITED
mode for importing text files has limited support for handling unmatched quotes in enclosed fields. Mysql supports a broad range of use cases and sinceDELIMITED
is meant as our analog of Mysql'sLOAD INTO
command we should get them to par. Also this is currently causing problems with on-boarding enterprise clients. See #40374 which deals with mishandling of a few rows in large csv-like files.This what one can achieve with MySql today when importing file
quotes.csv
with separator|
:Our current implementation crashed on this input, while in MySql this is treated quite sanely:
Describe the solution you'd like
Add support for the above use case in Cockroah
DELIMITED
import mode.Additional context
See #40374
The text was updated successfully, but these errors were encountered: