RE: tableau spark sql cassandra

2014-11-21 Thread jererc
Hi! Sure, I'll post the info I grabbed once the cassandra tables values appear in Tableau. Best, Jerome -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/tableau-spark-sql-cassandra-tp19282p19480.html Sent from the Apache Spark User List mailing list archive

Re: tableau spark sql cassandra

2014-11-20 Thread jererc
Well, after many attempts I can now successfully run the thrift server using root@cdb-01:~/spark# ./sbin/start-thriftserver.sh --master spark://10.194.30.2:7077 --hiveconf hive.server2.thrift.bind.host 0.0.0.0 --hiveconf hive.server2.thrift.port 1 (the command was failing because of the --driv

Re: tableau spark sql cassandra

2014-11-20 Thread jererc
sr/bin/env bash export JAVA_HOME=/usr/lib/jvm/java-7-oracle export SPARK_HOME=/home/jererc/spark export SPARK_MASTER_IP=10.194.30.2 export SPARK_WORKER_CORES=2 export SPARK_WORKER_INSTANCES=4 export SPARK_MASTER_PORT=7077 export SPARK_WORKER_MEMORY=4g export MASTER=spark://${SPARK_MAS

Re: tableau spark sql cassandra

2014-11-20 Thread jererc
Hi! The hive table is an external table, which I created like this: CREATE EXTERNAL TABLE MyHiveTable ( id int, data string ) STORED BY 'org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler' TBLPROPERTIES ("cassandra.host" = "10.194.30.2", "cassandra.ks.name" = "test" ,

tableau spark sql cassandra

2014-11-19 Thread jererc
Hello! I'm working on a POC with Spark SQL, where I’m trying to get data from Cassandra into Tableau using Spark SQL. Here is the stack: - cassandra (v2.1) - spark SQL (pre build v1.1 hadoop v2.4) - cassandra / spark sql connector (https://github.com/datastax/spark-cassandra-connector) - hive - m