jsonPredicateHints is not working, getting complete result instead of filtered result

[ShridharSangamkar]

I am trying to use delta-share client to connect delta share and fetch the result. I am using delta-share latest version which I have installed using following

pip install --upgrade delta-share

the code snippet for fetching the data

predicate_json = json.dumps({
            "op": "equal",
            "children": [
                {"op": "column", "name": "memberid", "valueType": "integer"},
                {"op": "literal", "value": "123456", "valueType": "integer"},
            ],
        })
df = delta_sharing.load_as_pandas(url=table_url, jsonPredicateHints=predicate_json)

[walkeralexander]

Sorry, did you get this resolved?

[ShridharSangamkar]

Yes that is resolved, the underlying table should be partitioned then only it will work, Also if it does not matches the condition then it will return complete result

[walkeralexander]

Gotcha, do you have any thoughts about the multi-condition jsonPredicateHint I was referring to? Totally fine if you haven't tried this.