search

keboola / php-db-import

MIT License
4 stars 0 forks source link

Snowflake - dedupe is broken for empty PK values? #22

Closed Halama closed 7 years ago

Halama commented 7 years ago

https://keboola.zendesk.com/agent/tickets/5790

Tady jsou radky ktere nemaji PK sloupec s prazdnou hodnotou, to je ok: image

A tady radky kde je PK s prazdnou hodnotou: image

Snflk umi dedupe pomoci union, mozna by bylo nejlepsi pouzit to misto te window fce co tam je. Chtelo by to ale urcite nejdrive nejaky benchmark.

Podobna chyba muze byt i u RS - overit v testch pro oboje!

Halama commented 7 years ago

tak problem neni v samotnem dedupe (window fce) ale v nasledne update cilove tabulky a porovnani.