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