开发者

MongoDB: mongoimport seems to ignore blank field value in first position of tsv file

开发者 https://www.devze.com 2023-04-08 13:28 出处:网络
mongodb version v1.8.0 on Mac 10.6.8. I\'m trying to run a mongoimport on a TSV (tab separated value) file.

mongodb version v1.8.0 on Mac 10.6.8.

I'm trying to run a mongoimport on a TSV (tab separated value) file.

For some reason, it's ignoring blank fields even though I'm not using the --ignoreBlanks switch. At least, I think that's what's happening.

You can download my test file here: http://pastebin.com/9XzbDfgP

Here's my mongoimport command:

mongoimport --drop --headerline --type tsv -d movies -c performances --file ~/Desktop/100performance.tsv 

So what happens is it ends up importing the wrong fie开发者_C百科lds into the wrong field names (headers). And it leaves off some of the fields. It's having trouble with blank fields. I populated some of those blank fields and it seemed to do better. That's not a real fix though, obviously.

Ideas?


This is working for me now using mongodb/mongoimport v2.0.1.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号