-
Notifications
You must be signed in to change notification settings - Fork 13
Open
Description
This command
crunch -in existing-supposedly.csv -as e -in ddb-tenants-LIVE.csv -as l -in ddb-tenants-USA.csv -as u -sql 'SELECT e.*, l.te, u.te FROM e LEFT JOIN l ON e.name = l.te LEFT JOIN u ON e.name = u.te' -out joined2.csv
fails with
SQL: INSERT INTO "output" (SELECT "e".*, "l"."te", "u"."te" FROM "e" LEFT JOIN "l" ON "e"."name" = "l"."te" LEFT JOIN "u" ON "e"."name" = "u"."te")
cz.dynawest.csvcruncher.CsvCruncherException: Error executing user SQL:
DB error: SQLSyntaxErrorException number of target columns does not match that of query expression
Possibly because of the same names of the columns?
Tables and column types:
* l
- te CHARACTER VARYING
- av BOOLEAN
- ax CHARACTER VARYING
- caid CHARACTER VARYING
- cf CHARACTER VARYING
- ev CHARACTER VARYING
- granit CHARACTER VARYING
- id UUID
- na CHARACTER VARYING
- oltp CHARACTER VARYING
- sd CHARACTER VARYING
- se CHARACTER VARYING
- v SMALLINT
* u
- te CHARACTER VARYING
- av BOOLEAN
- ax CHARACTER VARYING
- caid CHARACTER VARYING
- cf CHARACTER VARYING
- ev CHARACTER VARYING
- granit CHARACTER VARYING
- id UUID
- na CHARACTER VARYING
- sd CHARACTER VARYING
- se CHARACTER VARYING
- v SMALLINT
* e
- name CHARACTER VARYING
* output
- name CHARACTER VARYING
- te CHARACTER VARYING
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels