Well, we have several such SQLs which we run against our databases using multiple engines (Impala, Hive, etc) all of these support such queries.
The use case is to have data available in Gridgain cache and fire same SQL queries on the cache against hitting Hive/Impala queries against our database.
Before we onboard Gridgain fully, we tried to hit some queries and test if it works for our SQLs, we can't modify SQL implementations as we have many of them.
Please try these queries on Hive, they do work. Please suggest if this can be supported in Gridgain.
1065 East Hillsdale Blvd, Suite 410Foster City, CA 94404