Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

mdiiazster_186257 avatar image
mdiiazster_186257 asked ·

Why when the matching fields are in child documents, the score of parent document is always 0.0 ?

I want to score the results from a query but when the matching fields are only in child documents, the score of parent document is always 0.0

The query:

{!tuple v="(((((brandedNominativeInfo.field9:Julie) AND (brandedNominativeInfo.field13:Bernier)))^64) OR ((((brandedNominativeInfo.field10:Julie) AND (brandedNominativeInfo.field14:Bernier)))^16))"}

The response:

"response": {
    "numFound": 2,
    "start": 0,
    "maxScore": 0,
    "docs": [
{         "*_uri*": "geroot://RootEntity/UniqueCustomer//253464ba-b58a-36b9-b918-188596868483",         "*rootId*": "253464ba-b58a-36b9-b918-188596868483",         "*brandedNominativeInfo*": [           "\{\"field1\":[\"string\"],\"field2\":[\"string\"],\"field3\":[\"string\"],\"field4\":\"2019-07-18T04:00:00Z\",\"field8\":\"Julie\",\"field9\":\"Julie\",\"field10\":\"Julie\",\"field11\":\"female\",\"field12\":\"Bernier\",\"field13\":\"Bernier\",\"field14\":\"Bernier\",\"field18\":\"string\"}
"
        ],
        "brandedEmailValue": [
          "test@desjardins.com"
        ],
        "customerType": "INDV",
        "uniqueCustomerNumber": "500000001",
        "_timestamp": "2020-02-24T15:26:42.543Z",
        "customerNumber": [
          "500000000"
        ],
        "brandedPhoneValue": [
          "4189999999"
        ],
        "_modelName": "UniqueCustomer",
        "uniqueCustomerSharingInfoIndicator": true,
        "brandedEmailValueIgnoreCase": [
          "test@desjardins.com"
        ],
        "brandCd": [
          "DesjardinsGeneralInsurance"
        ],
        "score": 0
      },
{         "*_uri*": "geroot://RootEntity/UniqueCustomer//73ffe418-d788-3504-9453-63d086d42545",         "*rootId*": "73ffe418-d788-3504-9453-63d086d42545",         "*brandedNominativeInfo*": [           "\{\"field1\":[\"string\"],\"field2\":[\"string\"],\"field3\":[\"string\"],\"field4\":\"2019-07-18T04:00:00Z\",\"field8\":\"July\",\"field9\":\"July\",\"field10\":\"July\",\"field11\":\"female\",\"field12\":\"Bernyer\",\"field13\":\"Bernyer\",\"field14\":\"Bernyer\",\"field18\":\"string\"}
"
        ],
        "brandedEmailValue": [
          "test@desjardins.com"
        ],
        "customerType": "INDV",
        "uniqueCustomerNumber": "500000023",
        "_timestamp": "2020-02-24T15:30:28.313Z",
        "customerNumber": [
          "500000022"
        ],
        "brandedPhoneValue": [
          "4189999999"
        ],
        "_modelName": "UniqueCustomer",
        "uniqueCustomerSharingInfoIndicator": true,
        "brandedEmailValueIgnoreCase": [
          "test@desjardins.com"
        ],
        "brandCd": [
          "DesjardinsGeneralInsurance"
        ],
        "score": 0
      }
    ]
  }
}
searchscore
2 comments
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

@mdiiazster_186257 Just acknowledging your question. I've reached out internally to the DSE Search team and will get you a response soon. Cheers!

1 Like 1 · ·

@mdiiazster_186257 I haven't forgotten about your question. I'm still trying to get an answer for you. Apologies for the delay. Cheers!

0 Likes 0 · ·

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

@mdiiazster_186257 We haven't been able to identify the cause of this behaviour in Apache Solr and there does not appear to be any JIRAs in open-source Solr either that fits the bill. Our Engineering team suspect that something about the tuples being indexed as child documents is interfering with the score calculation.

I understand that you have logged a Support ticket and our engineers are working with the DSE Search team to find a solution for you. They will be providing you updates directly in the ticket. Cheers!

2 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

@Erick Ramirez, I have not opened any tickets yet, if you know that there is a related one please send it to me. Otherwise, I will proceed to create one. Thanks.

0 Likes 0 · ·

@mdiiazster_186257 David L. already logged ticket ID 60656 early last week and has been in contact with our engineers. I'll let the discussion continue in the Support ticket. Cheers!

0 Likes 0 · ·