[hibernate-issues] [JIRA] (HSEARCH-3839) Sorting by numeric value has an exception "(expected=NUMERIC). Use UninvertingReader or index with docvalues"

[Waldemar Kłaczyński (JIRA)]

Waldemar Kłaczyński ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A77e50cac-bda3-4af4-9bb3-6461f4d10eea ) *commented* on HSEARCH-3839 ( https://hibernate.atlassian.net/browse/HSEARCH-3839?atlOrigin=eyJpIjoiYTNiODg0MDc4YTJlNDRkMGIzZmRiMjcxNWVkZjE2MmIiLCJwIjoiaiJ9 )

Re: Sorting by numeric value has an exception "(expected=NUMERIC). Use UninvertingReader or index with docvalues" ( https://hibernate.atlassian.net/browse/HSEARCH-3839?atlOrigin=eyJpIjoiYTNiODg0MDc4YTJlNDRkMGIzZmRiMjcxNWVkZjE2MmIiLCJwIjoiaiJ9 )

All in all, the solution completely exhausts the problem of many fields. There is still a problem of aggregation of many values. Report a new aggregation problem. The problem is similar, you must specify how the filter should behave for multiple values. In storage Storage.FLATTENED works but you cannot specify the logic, in Storage.NESTED all values for the filter disappear.

   PredicateFinalStep filter = scope.predicate()
               .match().field("prices.active").matching(true);

    SearchQuery<Assortment> query = session.search(scope)
               .where((f) -> f.bool().must(select)
               .filter(filter))

This is also a critical problem, I will try to solve it. I think that the multi parameter from AND, OR, XOR etc. could be similarly vy ....

( https://hibernate.atlassian.net/browse/HSEARCH-3839#add-comment?atlOrigin=eyJpIjoiYTNiODg0MDc4YTJlNDRkMGIzZmRiMjcxNWVkZjE2MmIiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-3839#add-comment?atlOrigin=eyJpIjoiYTNiODg0MDc4YTJlNDRkMGIzZmRiMjcxNWVkZjE2MmIiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:cefda43 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200226/d30efae4/attachment.html