Hi,
I’m trying to connect my tableau to spark sql. Using this guide
https://community.tableau.com/docs/DOC-7638.
Then I’m try start thrift server (or $SPARK_HOME/sbin/start-thriftserver.sh
--master spark://data01:7077 --driver-class-path $CLASSPATH --hiveconf
hive.server2.thrift.bind.host 127.0.0.1 --hiveconf hive.server2.thrift.port
10001) its starts without any problem, but state changing to KILLED after
~10sec.
My hive-site
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jcd sp
dbc:mysql://127.0.0.1:3306/metastore_db?createDatabaseIfNotExist=true</value>
<description>metadata is stored in a MySQL server</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>MySQL JDBC driver class</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hiveuser</value>
<description>user name for connecting to mysql server </description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive123</value>
<description>password for connecting to mysql server </description>
</property>
</configuration>
stderr log
Using Spark's default log4j profile: org/apache/spark/log4j-defaults.properties
16/01/13 17:10:36 INFO CoarseGrainedExecutorBackend: Registered signal handlers
for [TERM, HUP, INT]
16/01/13 17:10:37 WARN NativeCodeLoader: Unable to load native-hadoop library
for your platform... using builtin-java classes where applicable
16/01/13 17:10:37 INFO SecurityManager: Changing view acls to: hduser
16/01/13 17:10:37 INFO SecurityManager: Changing modify acls to: hduser
16/01/13 17:10:37 INFO SecurityManager: SecurityManager: authentication
disabled; ui acls disabled; users with view permissions: Set(hduser); users
with modify permissions: Set(hduser)
16/01/13 17:10:41 WARN ThreadLocalRandom: Failed to generate a seed from
SecureRandom within 3 seconds. Not enough entrophy?
16/01/13 17:10:41 INFO SecurityManager: Changing view acls to: hduser
16/01/13 17:10:41 INFO SecurityManager: Changing modify acls to: hduser
16/01/13 17:10:41 INFO SecurityManager: SecurityManager: authentication
disabled; ui acls disabled; users with view permissions: Set(hduser); users
with modify permissions: Set(hduser)
16/01/13 17:10:42 INFO Slf4jLogger: Slf4jLogger started
16/01/13 17:10:42 INFO Remoting: Starting remoting
16/01/13 17:10:42 INFO Remoting: Remoting started; listening on addresses
:[akka.tcp://[email protected]:42412]
16/01/13 17:10:42 INFO Utils: Successfully started service
'sparkExecutorActorSystem' on port 42412.
16/01/13 17:10:42 INFO DiskBlockManager: Created local directory at
/tmp/spark-f3208756-f443-487a-8b5d-84c78956d47c/executor-b8f6ff53-e4f0-4e1f-a57f-e9275e0c9acb/blockmgr-89d68d63-2df7-4ae4-a451-6091e7e6ef95
16/01/13 17:10:42 INFO MemoryStore: MemoryStore started with capacity 511.5 MB
16/01/13 17:10:42 INFO CoarseGrainedExecutorBackend: Connecting to driver:
spark://[email protected]:49076
16/01/13 17:10:42 INFO WorkerWatcher: Connecting to worker
spark://[email protected]:41507
16/01/13 17:10:42 INFO CoarseGrainedExecutorBackend: Successfully registered
with driver
16/01/13 17:10:42 INFO Executor: Starting executor ID 0 on host localhost
16/01/13 17:10:42 INFO Utils: Successfully started service
'org.apache.spark.network.netty.NettyBlockTransferService' on port 54055.
16/01/13 17:10:42 INFO NettyBlockTransferService: Server created on 54055
16/01/13 17:10:42 INFO BlockManagerMaster: Trying to register BlockManager
16/01/13 17:10:42 INFO BlockManagerMaster: Registered BlockManager
16/01/13 17:10:45 INFO CoarseGrainedExecutorBackend: Driver commanded a shutdown
16/01/13 17:10:45 INFO MemoryStore: MemoryStore cleared
16/01/13 17:10:45 INFO BlockManager: BlockManager stopped
16/01/13 17:10:45 INFO RemoteActorRefProvider$RemotingTerminator: Shutting down
remote daemon.
16/01/13 17:10:45 WARN CoarseGrainedExecutorBackend: An unknown
(localhost:49076) driver disconnected.
