Hello, I’m wondering why it’s not possible to sort by properties that doesn’t exist in a single index? HS6 adds “unmapped_type” to search query when create request for multiple indexes but for single index doesn’t. I checked direct request to Elasticsearch (7.16.3), and when to generated request …

This was fixed in Hibernate Search 6.1.4.Final. Thanks for reporting the problem. [image] Hibernate Search 6.1.4.Final released - In Relation To We just published a maintenance release for Hibernate Search: 6.1.4.Final. This releases mainly upgrades to Hibernate ORM 6.0.0.Final for -…

Hello, [image] Kamil: I’m wondering why it’s not possible to sort by properties that doesn’t exist in a single index? It is possible, as far as I know? If you’re having a problem, please post your code and the stacktrace. EDIT: Okay, I didn’t understand what you meant. Adding another answe…

It’s possible when you’re searching multiple indexes and at least one of them has that property, because then Hibernate Search knows what to put inside unmapped_type: the type of the property in the index that actually has that property. It’s not possible when you’re searching a single index becaus…

Let’s say i have a products for different regions. Products have a list of properties for example (property.A, property.B, property.C) In products index it could look like this (JSON view from Kibana) “property”: { “A”: “A”, “B”: “B”, “C”: “C”, }, I want to have different sorting for regions…

[image] Kamil: But if I add unmapped_type for example “sort”:[ “_score”, { “property.A”:{ “missing”:“_last”, “unmapped_type”:“keyword” } } ] then it works Well, sure. But how exactly is Hibernate Search supposed to guess that unmapped_type should be set to keyword and not, say, inte…

Yes, i create these properties dynamically, with template, these properties are strings: IndexSchemaObjectField propertyField = context.indexSchemaElement().objectField(“property”); propertyField.fieldTemplate(“propertyTemplate”, context.typeFactory().asString() .sortable(Sortable.YES) ) and th…

Alright, if you’re using dynamic field templates then Hibernate Search is indeed able to add the unmapped type. And what you’re asking definitely makes sense. I would have expected Elasticsearch to not require the unmapped type in this case (since it knows about the type, through dynamic templates)…

Created [HSEARCH-4531] - Hibernate JIRA

Hibernate Search 6 + Elasticsearch(7.16.3) , sorting by not existing property in a single index

Hibernate Search

yrodiere April 7, 2022, 9:35am 9

This was fixed in Hibernate Search 6.1.4.Final. Thanks for reporting the problem.

1 Like

Topic		Replies	Views
@KeywordField is causing bad elastic search json query Hibernate Search	6	599	January 11, 2022
Do Sortable Fields in a Programmatic Mapping require indexNullAs if the value is nullable? Hibernate Search	5	784	October 29, 2020
Sorting on dynamic fields Hibernate Search	2	1620	April 15, 2019
Sorting not working for Double type property? Also issue with `entityManager` Hibernate Search	5	1511	February 25, 2019
How to sort by LocalDateTime Hibernate Search	4	1072	November 4, 2022

Hibernate Search 6 + Elasticsearch(7.16.3) , sorting by not existing property in a single index

Related topics