Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Joseph Tech
se-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

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Jack Krupansky
m/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 J

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Joseph Tech
nsformers > > 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 > >

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread DuyHai Doan
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,

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Russell Bradberry
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 y