ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ravi <meetraviparamasi...@gmail.com>
Subject Apache Ignite JDBC Support for SAP BOXI or Other BI tools
Date Sun, 13 Aug 2017 05:44:32 GMT
 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.

   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?

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.

View raw message