Hi, We are using SAP BOXI for report generation based on the schema defined in Universe using HiveServer2 SQL Dialect to generate HiveQL and Run it on Hive Server2 or SparKSQL Thrift Server. To improve the Query response time we are planning to we wanted to keep the data in Ignite Cache and Run Ignite SQL. So in this context? 1) Do SAP BO or any other BI tool support Ignite as SQL Engine?. 2) If not what is the alternate SQL engine(which is close to Ignite SQL syntax and ANSI-99 complaint) we can make use of it for query generation? 3) People can generate the report on any fields or combination and there will be many tables. So configuring indexing or sql field upfront is the challenging task. or
Make IGFS as secondary file system, change MR engine as ignite and use existing HiveQL dialect and check the performance improvement?. In this case Hive on Ignite will it be better than Spark SQL? Regards Ravi -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Apache-Ignite-JDBC-Support-for-SAP-BOXI-or-Other-BI-tools-tp16154.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
