Discussion:
Query regarding Dynamic Fields
jay harkhani
2018-12-05 12:28:51 UTC
Permalink
Hello All,


We are using dynamic fields in our collection. We want to use it in query to fetch records. Can someone please advice on it?

i.e.: q=ABC_*:"myValue"

Here "ABC_*" is dynamic field. Currently when we tried if provide field name as above it gives "org.apache.solr.search.SyntaxError". It only returns data when provide actual field name.

Thank you for any help you can offer.

Regards,
Jay Harkhani.
Bruno Mannina
2018-12-05 12:50:15 UTC
Permalink
Hi Jay,

In my case, I created a CopyField for this case.

i.e.
<copyField source="ABC_*" dest="ABC"/>

And of course define ABC before
<field name="ABC" type="text_general" indexed="true" stored="true"
multiValued="true"/>



-----Message d'origine-----
De : jay harkhani [mailto:***@hotmail.com]
Envoyé : mercredi 5 décembre 2018 13:29
À : solr-***@lucene.apache.org
Objet : Query regarding Dynamic Fields

Hello All,


We are using dynamic fields in our collection. We want to use it in query to
fetch records. Can someone please advice on it?

i.e.: q=ABC_*:"myValue"

Here "ABC_*" is dynamic field. Currently when we tried if provide field name
as above it gives "org.apache.solr.search.SyntaxError". It only returns data
when provide actual field name.

Thank you for any help you can offer.

Regards,
Jay Harkhani.


---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
jay harkhani
2018-12-06 13:02:35 UTC
Permalink
Hello Bruno,

Thanks for you suggestion.

But in our use case there are large no. of fields so every time making copy field will not feasible.

i.e.: fields: ABC_Field/Start_Date, ABD_Field/Complete_Date, ABD_Field/info/User_Name, ABD_Field/info/Email

As we use in return field i.e.: *Start_Date, *Complete_Date, *User_Name. Similar We need to use field name to make search query.

Regards,
Jay Harkhani.

________________________________
From: Bruno Mannina <***@free.fr>
Sent: Wednesday, December 5, 2018 6:20 PM
To: solr-***@lucene.apache.org
Subject: RE: Query regarding Dynamic Fields

Hi Jay,

In my case, I created a CopyField for this case.

i.e.
<copyField source="ABC_*" dest="ABC"/>

And of course define ABC before
<field name="ABC" type="text_general" indexed="true" stored="true"
multiValued="true"/>



-----Message d'origine-----
De : jay harkhani [mailto:***@hotmail.com]
Envoyé : mercredi 5 décembre 2018 13:29
À : solr-***@lucene.apache.org
Objet : Query regarding Dynamic Fields

Hello All,


We are using dynamic fields in our collection. We want to use it in query to
fetch records. Can someone please advice on it?

i.e.: q=ABC_*:"myValue"

Here "ABC_*" is dynamic field. Currently when we tried if provide field name
as above it gives "org.apache.solr.search.SyntaxError". It only returns data
when provide actual field name.

Thank you for any help you can offer.

Regards,
Jay Harkhani.


---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
Erick Erickson
2018-12-06 17:07:00 UTC
Permalink
bq: so every time making copy field will not feasible

What's your evidence? If you have a zillion documents and a very large
corpus, that's one thing. But 10M docs isn't very much and you can use
copyFields all over the place.

Plus do you have to search the fields separately too? If not, storing
but not indexing the original field and indexing but not storing the
copyField destination creates an index of roughly the same size as
storing+indexing the original fields only.

Solr simply has no support for wildcards as the field of a search, i.e
ABC*:some_search_value. So either you need to use some kind of
copyField trick or take a look at your architecture. This may well be
an XY problem, you haven't really told us _why_ you think you need all
these dynamic fields, what use-case are you trying to solve? Have you
considered payloads for instance? Whether they apply is impossible to
suggest without more information.

Best,
Erick
Post by jay harkhani
Hello Bruno,
Thanks for you suggestion.
But in our use case there are large no. of fields so every time making copy field will not feasible.
i.e.: fields: ABC_Field/Start_Date, ABD_Field/Complete_Date, ABD_Field/info/User_Name, ABD_Field/info/Email
As we use in return field i.e.: *Start_Date, *Complete_Date, *User_Name. Similar We need to use field name to make search query.
Regards,
Jay Harkhani.
________________________________
Sent: Wednesday, December 5, 2018 6:20 PM
Subject: RE: Query regarding Dynamic Fields
Hi Jay,
In my case, I created a CopyField for this case.
i.e.
<copyField source="ABC_*" dest="ABC"/>
And of course define ABC before
<field name="ABC" type="text_general" indexed="true" stored="true"
multiValued="true"/>
-----Message d'origine-----
Envoyé : mercredi 5 décembre 2018 13:29
Objet : Query regarding Dynamic Fields
Hello All,
We are using dynamic fields in our collection. We want to use it in query to
fetch records. Can someone please advice on it?
i.e.: q=ABC_*:"myValue"
Here "ABC_*" is dynamic field. Currently when we tried if provide field name
as above it gives "org.apache.solr.search.SyntaxError". It only returns data
when provide actual field name.
Thank you for any help you can offer.
Regards,
Jay Harkhani.
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
Continue reading on narkive:
Loading...