Back to thrift, there was an earlier thread on this topic at http://mail-archives.apache.org/mod_mbox/spark-user/201411.mbox/%3CCABPQxsvXA-ROPeXN=wjcev_n9gv-drqxujukbp_goutvnyx...@mail.gmail.com%3E that may be useful as well.
On Sun Feb 22 2015 at 8:42:29 AM Denny Lee <denny.g....@gmail.com> wrote: > Hi Francisco, > > Out of curiosity - why ROLAP mode using multi-dimensional mode (vs > tabular) from SSAS to Spark? As a past SSAS guy you've definitely piqued my > interest. > > The one thing that you may run into is that the SQL generated by SSAS can > be quite convoluted. When we were doing the same thing to try to get SSAS > to connect to Hive (ref paper at > http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/MOLAP2HIVE_KLOUT.docx) > that was definitely a blocker. Note that Spark SQL is different than HIVEQL > but you may run into the same issue. If so, the trick you may want to use > is similar to the paper - use a SQL Server linked server connection and > have SQL Server be your "translator" for the SQL generated by SSAS. > > HTH! > Denny > > On Sun, Feb 22, 2015 at 01:44 Ashic Mahtab <as...@live.com> wrote: > >> Hi Francisco, >> While I haven't tried this, have a look at the contents of >> start-thriftserver.sh - all it's doing is setting up a few variables and >> calling: >> >> /bin/spark-submit --class org.apache.spark.sql.hive. >> thriftserver.HiveThriftServer2 >> >> and passing some additional parameters. Perhaps doing the same would work? >> >> I also believe that this hosts a jdbc server (not odbc), but there's a >> free odbc connector from databricks built by Simba, with which I've been >> able to connect to a spark cluster hosted on linux. >> >> -Ashic. >> >> ------------------------------ >> To: user@spark.apache.org >> From: forch...@gmail.com >> Subject: Spark SQL odbc on Windows >> Date: Sun, 22 Feb 2015 09:45:03 +0100 >> >> >> Hello, >> I work on a MS consulting company and we are evaluating including SPARK >> on our BigData offer. We are particulary interested into testing SPARK as >> rolap engine for SSAS but we cannot find a way to activate the odbc server >> (thrift) on a Windows custer. There is no start-thriftserver.sh command >> available for windows. >> >> Somebody knows if there is a way to make this work? >> >> Thanks in advance!! >> Francisco >> >