CODEWITHSUNDEEP
couchbase
aatuc210
aatuc210

Reputation: 1868

Need to import 2M of JSON into ONE Couchbase Document

I've been given an odd requirement to store an Excel spreadsheet in one JSON document within Couchbase. cbimport is saying that my document is not valid JSON, when it is, so I believe something else is wrong.

My document goes along the style of this:

[{ "sets": [
   {
      "cluster" : "M1M",
      "type" : "SET",
      "shortName" : "MARTIN MARIETTA MATERIALS",
      "clusterName" : "MARTIN MARIETTA",
      "setNum" : "10000163"
   },
   {
      "shortName" : "STERLING INC",
      "type" : "SET",
      "cluster" : "SJW",
      "setNum" : "10001427",
      "clusterName" : "STERLING JEWELERS"
   },
   ...
]}]

And my cbimport command looks like this:

cbimport json --cluster localhost --bucket documentBucket \
--dataset file://set_numbers.json --username Administrator \
--password password --format lines -e errors.log -l debug.log \
--generate-key 1

I've tried to format as lines as well as list. Both fail. What am I doing wrong?

Upvotes: 0

Views: 347

Answers (2)

KARTHIKEYAN.A
KARTHIKEYAN.A

Reputation: 20088

use cbimport to upload json data

cbimport json -c couchbase://127.0.0.1 -b data -d file://data.json -u Administrator -p password -f list -g "%id%" -t 4

Upvotes: 1

Matthew Groves
Matthew Groves

Reputation: 26141

I wrote your sample to a json file called set_numbers.json and tried it locally with list.

cbimport json --cluster localhost --bucket documentBucket --dataset file://set_numbers.json --username Administrator --password password --format list --generate-key 1

It imported successfully into a single document.

Upvotes: 2

Related Questions