You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Moshe Kranc <mo...@gmail.com> on 2015/06/22 10:32:38 UTC
CQL collections and Solr dynamic fields
In the DSE 4.7 advanced tutorial, there is an example of using a CQL map
together with Solr dynamic fields, so that every map entry is automatically
indexed by Solr.
Does this work for the other CQL collections, namely lists and sets? Can I
define CQL lists and sets to use Solr dynamic fields, so they are
automatically indexed by Solr?
Re: CQL collections and Solr dynamic fields
Posted by Sebastian Estevez <se...@datastax.com>.
Jack thanks for your reply.
I apologize for the confusion caused by my previous statement. I was
thinking just of maps when I replied. Correction - *Lists and Sets are
indexed as multivalued fields in DSE Search and Maps are stored as dynamic
fields in DSE Search. *
Both are indexed automatically once you have created your core
appropriately.
My second statement was accurate, fields cannot be both dynamic and
multivalued.
All the best,
[image: datastax_logo.png] <http://www.datastax.com/>
Sebastián Estévez
Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
[image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
<https://twitter.com/datastax> [image: g+.png]
<https://plus.google.com/+Datastax/about>
<http://feeds.feedburner.com/datastax>
<http://cassandrasummit-datastax.com/>
DataStax is the fastest, most scalable distributed database technology,
delivering Apache Cassandra to the world’s most innovative enterprises.
Datastax is built to be agile, always-on, and predictably scalable to any
size. With more than 500 customers in 45 countries, DataStax is the
database technology and transactional backbone of choice for the worlds
most innovative companies such as Netflix, Adobe, Intuit, and eBay.
On Mon, Jun 22, 2015 at 10:42 PM, Jack Krupansky <ja...@gmail.com>
wrote:
> Please do get that clarified - the doc currently says that lists and sets
> are implemented as multvalued fields, which contradicts your statement.
> Yes, map collections are implemented as dynamic fields, but list and set
> collections are somewhat different - or at least the doc says that they
> are: "*Collection list and set: multi-valued field.*"
>
> -- Jack Krupansky
>
> On Mon, Jun 22, 2015 at 9:47 PM, Sebastian Estevez <
> sebastian.estevez@datastax.com> wrote:
>
>> Quick clarification, collections are implemented as dynamic fields in DSE
>> (not multivalued fields).
>>
>> Fields that are both dynamic and multivalued are not supported,
>> therefore, you cannot use multivalued fields for collections.
>>
>>
>> All the best,
>>
>>
>> [image: datastax_logo.png] <http://www.datastax.com/>
>>
>> Sebastián Estévez
>>
>> Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
>>
>> [image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
>> facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
>> <https://twitter.com/datastax> [image: g+.png]
>> <https://plus.google.com/+Datastax/about>
>> <http://feeds.feedburner.com/datastax>
>>
>> <http://cassandrasummit-datastax.com/>
>>
>> DataStax is the fastest, most scalable distributed database technology,
>> delivering Apache Cassandra to the world’s most innovative enterprises.
>> Datastax is built to be agile, always-on, and predictably scalable to any
>> size. With more than 500 customers in 45 countries, DataStax is the
>> database technology and transactional backbone of choice for the worlds
>> most innovative companies such as Netflix, Adobe, Intuit, and eBay.
>>
>> On Mon, Jun 22, 2015 at 11:23 AM, Jack Krupansky <
>> jack.krupansky@gmail.com> wrote:
>>
>>> Well, the doc does state that limitation - "*In CQL-based Solr cores,
>>> the Solr schema fields that are dynamic and multivalued are not supported*"
>>> - but DataStax will have to clarify whether that is still true and true for
>>> lists and sets.
>>>
>>> See:
>>>
>>> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchDynFlds.html
>>>
>>> -- Jack Krupansky
>>>
>>> On Mon, Jun 22, 2015 at 10:23 AM, Moshe Kranc <mo...@gmail.com>
>>> wrote:
>>>
>>>> Lists and sets are implemented as multivalue fields, and dse solr does
>>>> not support dynamic multivalue fields. Therefore, I conclude that dse solr
>>>> does not support dynamic field search for sets and lists, I. E. I will have
>>>> to modify the solr schema and re-index each time I add a new CQL llist
>>>> or set.
>>>>
>>>> Is my logic correct?
>>>>
>>>>
>>>> On Monday, June 22, 2015, Jack Krupansky <ja...@gmail.com>
>>>> wrote:
>>>>
>>>>> List and set collections are mapped to multivalued Solr fields - a
>>>>> Solr query will match on any of the values in a multivalued Solr field (or
>>>>> keywords within those multiple values for Solr tokenized text fields.)
>>>>>
>>>>> See:
>>>>>
>>>>> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchSolrType.html
>>>>>
>>>>>
>>>>> -- Jack Krupansky
>>>>>
>>>>> On Mon, Jun 22, 2015 at 4:32 AM, Moshe Kranc <mo...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> In the DSE 4.7 advanced tutorial, there is an example of using a CQL
>>>>>> map together with Solr dynamic fields, so that every map entry is
>>>>>> automatically indexed by Solr.
>>>>>>
>>>>>> Does this work for the other CQL collections, namely lists and sets?
>>>>>> Can I define CQL lists and sets to use Solr dynamic fields, so they are
>>>>>> automatically indexed by Solr?
>>>>>>
>>>>>
>>>>>
>>>
>>
>
Re: CQL collections and Solr dynamic fields
Posted by Jack Krupansky <ja...@gmail.com>.
Please do get that clarified - the doc currently says that lists and sets
are implemented as multvalued fields, which contradicts your statement.
Yes, map collections are implemented as dynamic fields, but list and set
collections are somewhat different - or at least the doc says that they
are: "*Collection list and set: multi-valued field.*"
-- Jack Krupansky
On Mon, Jun 22, 2015 at 9:47 PM, Sebastian Estevez <
sebastian.estevez@datastax.com> wrote:
> Quick clarification, collections are implemented as dynamic fields in DSE
> (not multivalued fields).
>
> Fields that are both dynamic and multivalued are not supported, therefore,
> you cannot use multivalued fields for collections.
>
>
> All the best,
>
>
> [image: datastax_logo.png] <http://www.datastax.com/>
>
> Sebastián Estévez
>
> Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
>
> [image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
> facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
> <https://twitter.com/datastax> [image: g+.png]
> <https://plus.google.com/+Datastax/about>
> <http://feeds.feedburner.com/datastax>
>
> <http://cassandrasummit-datastax.com/>
>
> DataStax is the fastest, most scalable distributed database technology,
> delivering Apache Cassandra to the world’s most innovative enterprises.
> Datastax is built to be agile, always-on, and predictably scalable to any
> size. With more than 500 customers in 45 countries, DataStax is the
> database technology and transactional backbone of choice for the worlds
> most innovative companies such as Netflix, Adobe, Intuit, and eBay.
>
> On Mon, Jun 22, 2015 at 11:23 AM, Jack Krupansky <jack.krupansky@gmail.com
> > wrote:
>
>> Well, the doc does state that limitation - "*In CQL-based Solr cores,
>> the Solr schema fields that are dynamic and multivalued are not supported*"
>> - but DataStax will have to clarify whether that is still true and true for
>> lists and sets.
>>
>> See:
>>
>> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchDynFlds.html
>>
>> -- Jack Krupansky
>>
>> On Mon, Jun 22, 2015 at 10:23 AM, Moshe Kranc <mo...@gmail.com>
>> wrote:
>>
>>> Lists and sets are implemented as multivalue fields, and dse solr does
>>> not support dynamic multivalue fields. Therefore, I conclude that dse solr
>>> does not support dynamic field search for sets and lists, I. E. I will have
>>> to modify the solr schema and re-index each time I add a new CQL llist
>>> or set.
>>>
>>> Is my logic correct?
>>>
>>>
>>> On Monday, June 22, 2015, Jack Krupansky <ja...@gmail.com>
>>> wrote:
>>>
>>>> List and set collections are mapped to multivalued Solr fields - a Solr
>>>> query will match on any of the values in a multivalued Solr field (or
>>>> keywords within those multiple values for Solr tokenized text fields.)
>>>>
>>>> See:
>>>>
>>>> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchSolrType.html
>>>>
>>>>
>>>> -- Jack Krupansky
>>>>
>>>> On Mon, Jun 22, 2015 at 4:32 AM, Moshe Kranc <mo...@gmail.com>
>>>> wrote:
>>>>
>>>>> In the DSE 4.7 advanced tutorial, there is an example of using a CQL
>>>>> map together with Solr dynamic fields, so that every map entry is
>>>>> automatically indexed by Solr.
>>>>>
>>>>> Does this work for the other CQL collections, namely lists and sets?
>>>>> Can I define CQL lists and sets to use Solr dynamic fields, so they are
>>>>> automatically indexed by Solr?
>>>>>
>>>>
>>>>
>>
>
Re: CQL collections and Solr dynamic fields
Posted by Sebastian Estevez <se...@datastax.com>.
Quick clarification, collections are implemented as dynamic fields in DSE
(not multivalued fields).
Fields that are both dynamic and multivalued are not supported, therefore,
you cannot use multivalued fields for collections.
All the best,
[image: datastax_logo.png] <http://www.datastax.com/>
Sebastián Estévez
Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
[image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
<https://twitter.com/datastax> [image: g+.png]
<https://plus.google.com/+Datastax/about>
<http://feeds.feedburner.com/datastax>
<http://cassandrasummit-datastax.com/>
DataStax is the fastest, most scalable distributed database technology,
delivering Apache Cassandra to the world’s most innovative enterprises.
Datastax is built to be agile, always-on, and predictably scalable to any
size. With more than 500 customers in 45 countries, DataStax is the
database technology and transactional backbone of choice for the worlds
most innovative companies such as Netflix, Adobe, Intuit, and eBay.
On Mon, Jun 22, 2015 at 11:23 AM, Jack Krupansky <ja...@gmail.com>
wrote:
> Well, the doc does state that limitation - "*In CQL-based Solr cores, the
> Solr schema fields that are dynamic and multivalued are not supported*" -
> but DataStax will have to clarify whether that is still true and true for
> lists and sets.
>
> See:
>
> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchDynFlds.html
>
> -- Jack Krupansky
>
> On Mon, Jun 22, 2015 at 10:23 AM, Moshe Kranc <mo...@gmail.com>
> wrote:
>
>> Lists and sets are implemented as multivalue fields, and dse solr does
>> not support dynamic multivalue fields. Therefore, I conclude that dse solr
>> does not support dynamic field search for sets and lists, I. E. I will have
>> to modify the solr schema and re-index each time I add a new CQL llist
>> or set.
>>
>> Is my logic correct?
>>
>>
>> On Monday, June 22, 2015, Jack Krupansky <ja...@gmail.com>
>> wrote:
>>
>>> List and set collections are mapped to multivalued Solr fields - a Solr
>>> query will match on any of the values in a multivalued Solr field (or
>>> keywords within those multiple values for Solr tokenized text fields.)
>>>
>>> See:
>>>
>>> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchSolrType.html
>>>
>>>
>>> -- Jack Krupansky
>>>
>>> On Mon, Jun 22, 2015 at 4:32 AM, Moshe Kranc <mo...@gmail.com>
>>> wrote:
>>>
>>>> In the DSE 4.7 advanced tutorial, there is an example of using a CQL
>>>> map together with Solr dynamic fields, so that every map entry is
>>>> automatically indexed by Solr.
>>>>
>>>> Does this work for the other CQL collections, namely lists and sets?
>>>> Can I define CQL lists and sets to use Solr dynamic fields, so they are
>>>> automatically indexed by Solr?
>>>>
>>>
>>>
>
Re: CQL collections and Solr dynamic fields
Posted by Jack Krupansky <ja...@gmail.com>.
Well, the doc does state that limitation - "*In CQL-based Solr cores, the
Solr schema fields that are dynamic and multivalued are not supported*" -
but DataStax will have to clarify whether that is still true and true for
lists and sets.
See:
http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchDynFlds.html
-- Jack Krupansky
On Mon, Jun 22, 2015 at 10:23 AM, Moshe Kranc <mo...@gmail.com> wrote:
> Lists and sets are implemented as multivalue fields, and dse solr does not
> support dynamic multivalue fields. Therefore, I conclude that dse solr does
> not support dynamic field search for sets and lists, I. E. I will have to
> modify the solr schema and re-index each time I add a new CQL llist or
> set.
>
> Is my logic correct?
>
>
> On Monday, June 22, 2015, Jack Krupansky <ja...@gmail.com> wrote:
>
>> List and set collections are mapped to multivalued Solr fields - a Solr
>> query will match on any of the values in a multivalued Solr field (or
>> keywords within those multiple values for Solr tokenized text fields.)
>>
>> See:
>>
>> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchSolrType.html
>>
>>
>> -- Jack Krupansky
>>
>> On Mon, Jun 22, 2015 at 4:32 AM, Moshe Kranc <mo...@gmail.com>
>> wrote:
>>
>>> In the DSE 4.7 advanced tutorial, there is an example of using a CQL map
>>> together with Solr dynamic fields, so that every map entry is automatically
>>> indexed by Solr.
>>>
>>> Does this work for the other CQL collections, namely lists and sets? Can
>>> I define CQL lists and sets to use Solr dynamic fields, so they are
>>> automatically indexed by Solr?
>>>
>>
>>
Re: CQL collections and Solr dynamic fields
Posted by Moshe Kranc <mo...@gmail.com>.
Lists and sets are implemented as multivalue fields, and dse solr does not
support dynamic multivalue fields. Therefore, I conclude that dse solr does
not support dynamic field search for sets and lists, I. E. I will have to
modify the solr schema and re-index each time I add a new CQL llist or set.
Is my logic correct?
On Monday, June 22, 2015, Jack Krupansky <ja...@gmail.com> wrote:
> List and set collections are mapped to multivalued Solr fields - a Solr
> query will match on any of the values in a multivalued Solr field (or
> keywords within those multiple values for Solr tokenized text fields.)
>
> See:
>
> http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchSolrType.html
>
>
> -- Jack Krupansky
>
> On Mon, Jun 22, 2015 at 4:32 AM, Moshe Kranc <moshekranc@gmail.com
> <javascript:_e(%7B%7D,'cvml','moshekranc@gmail.com');>> wrote:
>
>> In the DSE 4.7 advanced tutorial, there is an example of using a CQL map
>> together with Solr dynamic fields, so that every map entry is automatically
>> indexed by Solr.
>>
>> Does this work for the other CQL collections, namely lists and sets? Can
>> I define CQL lists and sets to use Solr dynamic fields, so they are
>> automatically indexed by Solr?
>>
>
>
Re: CQL collections and Solr dynamic fields
Posted by Jack Krupansky <ja...@gmail.com>.
List and set collections are mapped to multivalued Solr fields - a Solr
query will match on any of the values in a multivalued Solr field (or
keywords within those multiple values for Solr tokenized text fields.)
See:
http://docs.datastax.com/en/datastax_enterprise/4.7//datastax_enterprise/srch/srchSolrType.html
-- Jack Krupansky
On Mon, Jun 22, 2015 at 4:32 AM, Moshe Kranc <mo...@gmail.com> wrote:
> In the DSE 4.7 advanced tutorial, there is an example of using a CQL map
> together with Solr dynamic fields, so that every map entry is automatically
> indexed by Solr.
>
> Does this work for the other CQL collections, namely lists and sets? Can I
> define CQL lists and sets to use Solr dynamic fields, so they are
> automatically indexed by Solr?
>