keboola / db-writer-redshift

Redshift database writer
MIT License
0 stars 0 forks source link

use null as? #17

Open odinuv opened 5 years ago

odinuv commented 5 years ago

https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html#copy-null-as

pokud se uprostred stringu vyskytuje NUL, tak se nenaimportuje, protoze

COPY treats it as an end of record (EOR) and terminates the record.

podle dokumentace to sice vypada, ze NULL AS na to sice vubec nepomuze, ale tahle veta naznacuje, ze by mozna precejen mohlo

If a field contains a string that ends with NUL and NULL AS is specified, the string is inserted with NUL at the end.

cili ze to jako umi naimportovat i pokud je v tom stringu nul, otazka je jestli musi byt nakonci nebo muze byt kdekoliv, to je potreba vyzkouset