cockroach-staging / hello-world

0 stars 0 forks source link

S317: As a developer, I want a fast way to get my data out of CockroachDB so that I can process it in downstream systems. #128

Open exalate-issue-sync[bot] opened 4 years ago

exalate-issue-sync[bot] commented 4 years ago

As a developer, I want a fast way to get my data out of CockroachDB so that I can process it in downstream systems.

exalate-issue-sync[bot] commented 4 years ago

Rachel Casali commented: Why is chunk size a string and not an int? from dt: the alternative, which @knz likes I believe, is that we should put the options to these commands in the SQL grammar like we do for normal commands with appropriate types so the parser would parse options (and be able to complete them, include them in diagrams, etc) just like normal commands. currently we use a string->string map though so that we don’t have to tell the parser about out options

Without this feature (and without CDC), the best practice would be a time travel select *

What do we do about FKs?

A number of people want headers for their CSV exports (https://github.com/jamesmishra/mysqldump-to-csv/issues/5, https://stackoverflow.com/questions/262924/how-to-export-dump-a-mysql-table-into-a-text-file-including-the-field-names-a) but we support those for single node export. Not clear someone who needs to use DISTRIBUTED CSV export would also plan on loading their data into excel. Let's wait to see customer demand.