使用beeline或hive2 jdbc驱动程序时的Datastax连接异常（表）

Question

我已经在我的开发虚拟机(Centos7)上安装了DataStaxEnterprise2.8。安装顺利进行，单节点群集运行良好。但是，当我试图使用beeline或hive2 jdbc驱动程序连接到集群时，我会遇到如下所示的错误。我的主要目标是使用Datastax企业驱动程序或Spark Sql驱动程序连接Tableau。

观察到的错误是：

cluster_name:“cluster1”

num_tokens:256

hinted_handoff_enabled:true hinted_handoff_throttle_in_kb:1024 max_hints_delivery_threads:2

分区程序:org.apache.cassandra.dht.murmur3partitioner

data_file_directories:-/var/lib/cassandra/data

commitlog_directory://var/lib/cassandra/commitlog

key_cache_size_in_mb:

key_cache_save_period:14400

ROW_CACHE_SIZE_IN_MB:0

commitlog_sync:周期commitlog_sync_period_in_ms:10000

commitlog_segment_size_in_mb:32

SEED_PROVIDER:-CLASS_NAME:org.apache.cassandra.locator.SimpleSeedProvider参数：-SEEDS：“10.33.1.124”

index_summary_resize_interval_in_minutes:60

trickle_fsync:false trickle_fsync_interval_in_kb:10240

storage_port:7000

rpc_address:10.33.1.124

rpc_port:9160

rpc_keepalive:true

AUTO_SNAPSHOT:true

tombstone_warn_threshold:1000 tombstone_failure_threshold:100000

column_index_size_in_kb:64

read_request_timeout_in_ms:5000 range_request_timeout_in_ms:10000 write_request_timeout_in_ms:2000 counter_write_request_timeout_in_ms:5000 cas_contention_timeout_in_ms:1000 truncate_request_timeout_in_ms:60000 request_timeout_in_ms:10000

cross_node_timeout:false

endpoint_snitch:com.datastax.bdp.snitch.dsesimpleSnitch

request_scheduler:org.apache.cassandra.scheduler.noScheduler

server_encryption_options:internode_encryption:none keystore:resources/dse/conf/.keystore keystore_password:cassandra truststore:resources/dse/conf/.truststore truststore_password:cassandra

client_encryption_options:enabled：false可选：false keystore：resources/dse/conf/.keystore keystore_password:cassandra

INTER_DC_TCP_NODELAY:false

concurrent_counter_writes:32

counter_cache_size_in_mb:

counter_write_request_timeout_in_ms:5000

当与beeline连接时，我得到错误：

dse beeline beeline版本0.12.0.11 by Apache Hive beeline>！连接jdbc:hive2://10.33.1.124:1000010毫秒内扫描完成连接到jdbc:hive2:/10.33.1.124:10000:输入用户名为jdbc:hive2:/10.33.1.124:10000:cassandra输入密码为jdbc:hive2:/10.33.1.124:10000:**********错误：无效URL:jdbc:hive2:/10.33.1.124:10000(state=08S01，code=0)0:jdbc:hive2:/10.33.1.124:10000>！连接124:10000连接到jdbc:hive2://10.33.1.124:10000输入jdbc:hive2://10.33.1.124:10000:输入jdbc:hive2://10.33.1.124:10000:错误：无效URL:jdbc:hive2://10.33.1.124:10000(state=08S01,code=0)1:jdbc:hive2://10.33.1.124:10000>

我在通过tableau连接时也看到类似的错误。

Answer 1

JDBC驱动程序连接到SparkSql节俭服务器。如果不启动它，就无法连接到它。

dse spark-sql-thriftserver
/Users/russellspitzer/dse/bin/dse:
usage: dse spark-sql-thriftserver <command> [Spark SQL Thriftserver Options]

Available commands:
  start                             Start Spark SQL Thriftserver
  stop                              Stops Spark SQL Thriftserver