“Correct” is hard to quantify without knowing your use case, but option 1 is probably what you want. Spark pushes down SQL execution to Ignite, so you get all the distribution, use of indexes, etc.
> On 14 Jul 2023, at 16:12, Arunima Barik <arunimabari...@gmail.com> wrote: > > Hello team > > What is the correct way out of these? > > 1. Write a spark dataframe to ignite > Read the same back and perform spark.sql() on that > > 2. Write the spark dataframe to ignite > Connect to server via a thin client > Perform client.sql() > > Regards > Arunima