I am not sure that your use case is okay because you have one table and two subsets of data inside (first col1 - col10 and second col11-col100). I guess that will be easier to create two tables with these fields and then use joins by ID.
However, according to your question - Ignite and GridGain support parallel access to the data. Spark integration will just transform your requests to SQL commands that can be executed in parallel.
>>Is it possible? if yes : what is the best configuration to do that (standalone or shared deployment) ?
I suggest using distributed Spark deployment because it will increase the speed of operations with Ignite/GridGain. I will provide several links that can be useful:
1065 East Hillsdale Blvd, Suite 220 Foster City, CA 94404
(650) 241-2281 firstname.lastname@example.org email@example.com