Re: Cassandra DSE Solr - search JSON content in column

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

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Jack Krupansky
i Doan >> Reply-To: >> Date: Wednesday, January 13, 2016 at 9:10 AM >> To: >> Subject: Re: Cassandra DSE Solr - search JSON content in column >> >> Try >> >> SELECT * FROM your_table WHERE solr_query='json:"*100 ABC Street*"';

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Joseph Tech
i Doan > Reply-To: > Date: Wednesday, January 13, 2016 at 9:10 AM > To: > 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'r

Re: Cassandra DSE Solr - search JSON content in column

2016-01-13 Thread Russell Bradberry
, January 13, 2016 at 9:10 AM To: 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 wildc

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, Jose

Cassandra DSE Solr - search JSON content in column

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