Re: Running Spark SQL on Spark Thrift Server with Ignite

2017-08-12 Thread ravi 
Hi Val,
  Thanks for the reply. Can you share some example or sample code snippet
for the steps you have explained?. The link you have shared doesn't explain
mapping Hive/Spar RDD to Ignite RDD context?

Regards
Ravi.P



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Running-Spark-SQL-on-Spark-Thrift-Server-with-Ignite-tp16087p16153.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Apache Ignite JDBC Support for SAP BOXI or Other BI tools

2017-08-12 Thread ravi 
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.