Thanks, Field Transformers is exactly what i was looking for. Mine is a somewhat nested object, so will need to see how complex the transformer would get, and if it would become a maintenance hassle later on; will try this out and share feedback.
-Joseph On Wed, Jan 13, 2016 at 8:31 PM, Russell Bradberry <rbradbe...@gmail.com> wrote: > You can use the full text wildcard search as mentioned. However, if you > need something more specific like certain fields in the JSON indexed, you > can use DSE SOLR field transformers. > http://www.datastax.com/dev/blog/dse-field-transformers > > From: DuyHai Doan <doanduy...@gmail.com> > Reply-To: <user@cassandra.apache.org> > Date: Wednesday, January 13, 2016 at 9:10 AM > To: <user@cassandra.apache.org> > Subject: Re: Cassandra DSE Solr - search JSON content in column > > Try > > SELECT * FROM your_table WHERE solr_query='json:"*100 ABC Street*"'; > > Warning: since you're storing in JSON format, searching data inside a JSON > is equivalent to a wildcard seach *xxx* and it is quite expensive, even for > full text search engines like Solr > > On Wed, Jan 13, 2016 at 2:50 PM, Joseph Tech <jaalex.t...@gmail.com> > wrote: > >> Hi, >> >> Is it possible in DSE Cassandra Solr to search for JSON content within a >> column? >> We store a complex JSON in a column of type "text", very simplified >> version below. >> >> { >> "userId": "user100", >> "addressList": [{ >> "addressId": "100", >> "address": "100 ABC Street" >> }], >> "userName": "user11" >> } >> >> In this, can search return all records that have address="100 ABC Street" >> ? >> >> Thanks, >> Joseph >> >> >
