Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-26027

Bi-directional Data Transfer to and from Couchbase for CSV/TSV data

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Duplicate
    • Major
    • None
    • 3.1.2, 4.0.0
    • tools
    • Any couchbase server install where it must integrate into an environment with existing data, databases, or personnel unfamiliar with nosql.

    Description

      Cbtransfer supports CSV for ingestion but does not provide a generic input/output mechanism to/from CSV, although it does support CSVs with an ID field. The requirement we're being asked to provide is a generic data import/export tool that will ingest or export data in CSV/TSV format.
      Cbcdocloader could possible provide this functionality but it only operates on JSON documents and not even a monolithic file for bulk-loading as well (i.e. a CSV converted to JSON docs and output to a large file for bulk loading into couchbase). Terabytes and petabytes are not ideal for this tool, but cbtransfer could do the job.

      Requesting official support for BSON - since it's experimental as of CB 2.0
      Requesting official support for JSON without document ID - since we can read JSON, it would be good to load, even if the doc ID isn't defined in the files.
      Requesting official support for generic CSV/TSV import/export, but could include the ID field on export but no metadata.

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              perry Perry Krug
              austin Austin Gonyou
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty