Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Is copy local supported? #113

Closed
slemme1 opened this issue Jan 9, 2023 · 3 comments · Fixed by #128 or #130
Closed

Is copy local supported? #113

slemme1 opened this issue Jan 9, 2023 · 3 comments · Fixed by #128 or #130

Comments

@slemme1
Copy link

slemme1 commented Jan 9, 2023

Bulk load/copy with files on Vertica mount works:
copy my_table from '/usr/src/my_table.txt' delimiter E'\t' null E'\N' enforcelength rejected data as table loader_rejects;

Is load/copy from local (Windows) file supported and if so, can you provide an example?
copy my_table from local 'c:\source\my_table.txt' delimiter E'\t' null E'\N' enforcelength rejected data as table loader_rejects;

This currently throws the following error:
AssertionError [ERR_ASSERTION]: unknown message code: 46
at Parser.handlePacket (C:\Source\canvas-cli\node_modules\v-protocol\dist\parser.js:159:34)
at Parser.parse (C:\Source\canvas-cli\node_modules\v-protocol\dist\parser.js:56:38)
at Socket. (C:\Source\canvas-cli\node_modules\v-protocol\dist\index.js:30:42)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
generatedMessage: false,
code: 'ERR_ASSERTION',
actual: undefined,
expected: undefined,
operator: 'fail'
}

Node.js v18.13.0

@DMickens
Copy link
Collaborator

Copy functionality is on the roadmap. It is not supported right now. Will update when we have a potential timeframe.

@DMickens
Copy link
Collaborator

DMickens commented Jan 8, 2024

Copy from local stream and file will be available in the 1.1.0 release expected by the end of the month

This was linked to pull requests Jan 30, 2024
@DMickens
Copy link
Collaborator

Available in latest release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
2 participants