New python client (8.x) for sql query

Elastic Stack Elasticsearch
1

I am using sql query in my old python client 7.x and it works like this

data = es.sql.query(body={"query": sql_query1, "fetch_size": 30000})

now using new client 8.x it give me this warning
DeprecationWarning: The 'body' parameter is deprecated and will be removed in a future version. Instead use individual parameters.

I can't figure out how to use this individual parameter. can't seems to find something related to that in document and don't see any example anywhere

2

anyone has any idea?

3

Try the new syntax from : Examples | Elasticsearch Python Client [8.9] | Elastic

like

response = es.search(index="my-index", body= sql_query1, size=3000)
4

ok this is how it works now.
I am using sql query hence have to use es.sql.query
you can use es.search if using rest query

data = es.sql.query(query = sql_query1, fetch_size= 10000)

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.