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.

Sign up for GitHub

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

Jump to bottom

Document the strict_quotes IMPORT option #5851

Closed
dbist opened this issue Nov 13, 2019 · 1 comment · Fixed by #6244
Closed

Document the strict_quotes IMPORT option #5851

dbist opened this issue Nov 13, 2019 · 1 comment · Fixed by #6244
Assignees
@lnhsingh
Labels
C-doc-improvement O-customer-success P-1 High priority; must be done this release T-missing-info
Projects
Education Sprint 15 (12/23/19 - 1/3/20)
Milestone
20.1

Comments

@dbist
Copy link
Contributor

dbist commented Nov 13, 2019

Re: IMPORT

Issue Description

document a CSV import flag strict_quotes. If import CSV file has quotes, multiple rows can be treated as single rows. strict_quotes flag will produce reasonable output to hint at an underlying issue row 1914: reading CSV record: parse error on line 1914, column 28: extraneous or missing " in quoted-field

Suggested Resolution

document flag strict_quotes if import files have quotes within rows. This flag doesn't take any input. Example: CSV DATA ('gs://artem_cockroach_bucket/aka_name.csv') WITH strict_quotes, delimiter = ',';
@dbist dbist mentioned this issue Nov 13, 2019
Closed
@jseldess jseldess added this to the 20.1 milestone Nov 26, 2019
@jseldess
Copy link
Contributor

@lnhsingh, any updates here? Would be great to wrap this up in Jan. Requested by the customer success team.

@lnhsingh lnhsingh added this to To do in Education Sprint 15 (12/23/19 - 1/3/20) via automation Dec 26, 2019
@lnhsingh lnhsingh moved this from To do to In progress in Education Sprint 15 (12/23/19 - 1/3/20) Dec 26, 2019
lnhsingh pushed a commit that referenced this issue Dec 26, 2019
Add strict_quotes option. Closes #5851
a56829c
@lnhsingh lnhsingh moved this from In progress to Review in progress in Education Sprint 15 (12/23/19 - 1/3/20) Dec 26, 2019
@lnhsingh lnhsingh mentioned this issue Dec 26, 2019
Merged
lnhsingh pushed a commit that referenced this issue Jan 2, 2020
IMPORT updates
f26e8c7 
Add example of DELIMITED with escaping. Closes #5895.

Add note about DEFAULT values and using multiple options.

Closes #5494. Closes #5929.

Add strict_quotes option. Closes #5851

Edits based on feedback

Edits based on feedback
Education Sprint 15 (12/23/19 - 1/3/20) automation moved this from Review in progress to Done Jan 2, 2020
@jseldess jseldess changed the title IMPORT Doc Update Document the strict_quotes IMPORT option Feb 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lnhsingh lnhsingh

Labels
C-doc-improvement O-customer-success P-1 High priority; must be done this release T-missing-info
Projects
No open projects
Education Sprint 15 (12/23/19 - 1/3/20)
  
Done
Milestone
20.1
Development

Successfully merging a pull request may close this issue.

Misc. IMPORT updates cockroachdb/docs
3 participants
@dbist @lnhsingh @jseldess