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

Question

question

mdiiazster_186257 asked Mar 26, '20 Erick Ramirez edited Mar 30, '20

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
      }
    ]
  }
}

search score

2

10 |1000

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

Erick Ramirez ♦♦ commented · Mar 26, 2020 at 09:37 PM

@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 ·

Erick Ramirez ♦♦ commented · Mar 27, 2020 at 11:40 PM

@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 ·

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2020-03-28T06:05:54Z

Erick Ramirez answered Mar 28, '20 Erick Ramirez edited Mar 30, '20

@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 Share

10 |1000

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

mdiiazster_186257 commented · Mar 30, 2020 at 02:02 PM

@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 ·

Erick Ramirez ♦♦ mdiiazster_186257 commented · Mar 30, 2020 at 09:28 PM

@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 ·

question