[SERVER-28631] Unable to query using FIRST KEY after dumping from csv file Created: 05/Apr/17 Updated: 31/May/17 Resolved: 06/Apr/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying, Tools |
| Affects Version/s: | 3.0.12 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Anil [X] | Assignee: | Kelsey Schubert |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Steps To Reproduce: |
|
||||||||
| Participants: | |||||||||
| Description |
|
The scenario is explained here http://stackoverflow.com/questions/43223253/mongodb-cannot-query-using-first-key-after-importing-data-from-csv-file. For whichever the keys in csv file, first key not usable for querying data. |
| Comments |
| Comment by Kelsey Schubert [ 06/Apr/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Hi anilCSE, Thanks for the update. I'm going to close this as a duplicate of Kind regards, | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Anil [X] [ 06/Apr/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Hi, On 7 Apr 2017 1:03 a.m., "Thomas Schubert (JIRA)" <jira@mongodb.org> wrote: [ https://jira.mongodb.org/browse/SERVER-28631?page=com.atlass Thomas Schubert commented on Hi anilCSE, Thanks for providing the data and command. To attempt to reproduce I
After examining the csv, I see that the column name is event. Thank you, tions/43223253/mongodb-cannot-query-using-first-key-after- ---------------------- | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Kelsey Schubert [ 06/Apr/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Hi anilCSE, Thanks for providing the data and command. To attempt to reproduce I executed the following steps all with MongoDB 3.0.12.
After examining the csv, I see that the column name is event. Therefore, the results from my reproduction attempt mach my expectations for how MongoDB ought to behave. Would you please review the steps above and let me know if you are seeing a different result? Thank you, | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Anil [X] [ 05/Apr/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Hi @Thomas, Here is the command I used to import into db:
Please find the attachment above for sample dataset | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Kelsey Schubert [ 05/Apr/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Hi anilCSE, Would you please provide attach a sample csv and the exact command used to import the data into MongoDB? Thank you, |