I’ve downloaded a database yesterday consistent of tweets during the games in the confederation cup. And I saved it in the Mongo DB. My data model in the database is like the following json:
{ "_id" : ObjectId("51bc9036194069119ff88c10"),
"text" : "Adianta AGORA ir para ruas e protesta, como em Brasilia e outras capitais contra a copa das confederações e do... http://t.co/41e4GGoe4o",
"created_at" : "2013-06-15 16:03:02",
"id" : NumberLong("345934481724669954"),
"user" : { "image" : "http://a0.twimg.com/profile_images/3425436378/57edc83f19d834283351a3729595d480_normal.jpeg",
"screen_name" : "Fernando_Fontes",
"id" : 54433693,
"name" : "Fernando Fontes"
}
}
Now, I wish to retrieve tweets using a term from the field ‘text’, for example: ‘Brasilia’. But, I couldn’t make a query searching for part of the text. I’m still starting with NoSQL and Big Data things. Is there any way to find the documents which has a word inside the field ‘text’?