For a nested object you can just concatenate the sequence of names with dots or some other separator and use that for each leaf value of the nested tree.
-- Jack Krupansky On Wed, Jan 13, 2016 at 11:40 PM, Joseph Tech <jaalex.t...@gmail.com> wrote: > 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 >>> >>> >> >
