Ravi, If you need to speed up SQL, you should make sure Ignite uses indexes to execute queries. I think you can do the following: - Create Hive RDD and map it to RDD of key value pairs. - Create new IgniteRDD on top of a cache and use IgniteRDD#savePairs method to load data from Hive to Ignite. - IgniteRDD#sql method to execute queries.
Note that SQL needs to be configured in Ignite (i.e. you need to specify queryable fields, indexes, etc.). More information here: https://apacheignite.readme.io/docs/sql-queries -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Running-Spark-SQL-on-Spark-Thrift-Server-with-Ignite-tp16087p16115.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.