Solr Indexing of json field in cassandra

(3 posts) (2 voices)

• Started 11 months ago by Pearly
• Latest reply from xedin
• This topic is not resolved

Tags:

No tags yet.

1. 

   Pearly
   Member

   Hi,

   My CF has a column defined to store a structured JSON data as following.
   {
   "lastname":"mylastname",
   "firstname":"myfirstname",
   "address":[
   "123 california st.",
   ""
   ],
   "city":"San Francisco",
   "state":"CA",
   "country":"US",
   "emailAddress":"apple@me.com",
   "postalCode":"94111",
   "phoneNumbers":[
   {
   "value":"(123) 456-7890",
   "type":"dayPhone"
   }
   ]
   }

   I basically want to create solr index on some of the fields in json such as firstname, lastname. What should be the approach?

   Thanks for helping me on this,

   Posted 11 months ago #
2. 

   Pearly
   Member

   Appreciate any help on this !!

   Posted 10 months ago #
3. 

   xedin
   Member

   Here is a good read to get you started http://www.datastax.com/docs/datastax_enterprise2.0/search/dse_search_start

   Briefly: you would have to include fields, that you want to query using solr, to the schema.xml which would create appropriate solr-backed secondary indices for you and you will be able to query them using CQL.

   Posted 10 months ago #

RSS feed for this topic

Reply

You must log in to post.