To all, I'm trying to connect Tableau to Hive (0.10.0) running Hiveserver2. The connection works ok, until I go to pull in the data. The resulting M/R job is attempting to connect to port 8021 on one of my data nodes--I've tried both Cloudera and Hortonworks ODBC in an effort to rule that out, and the query works fine running local to the cluster.
The Hive log is as follows: 2013-12-04 11:12:45,026 INFO org.apache.hadoop.hive.ql.Driver: Starting command: SELECT `fmc_free_text`.`msgtext` AS `msgtext` FROM `default`.`fmc_free_text` `fmc_free_text` 2013-12-04 11:12:45,027 INFO org.apache.hadoop.hive.ql.Driver: Total MapReduce jobs = 1 2013-12-04 11:12:45,027 INFO org.apache.hadoop.hive.ql.Driver: </PERFLOG method=TimeToSubmit start=1386173564991 end=1386173565027 duration=36> 2013-12-04 11:12:45,027 INFO org.apache.hadoop.hive.ql.Driver: Launching Job 1 out of 1 2013-12-04 11:12:45,029 INFO org.apache.hadoop.hive.ql.exec.Task: Number of reduce tasks is set to 0 since there's no reduce operator 2013-12-04 11:12:45,034 INFO org.apache.hadoop.hive.ql.exec.ExecDriver: Using org.apache.hadoop.hive.ql.io.CombineHiveInputFormat 2013-12-04 11:12:45,034 INFO org.apache.hadoop.hive.ql.exec.ExecDriver: adding libjars: file:///opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/lib/hive/lib/hive-builtins-0.10.0-cdh4.3.0.jar 2013-12-04 11:12:45,034 INFO org.apache.hadoop.hive.ql.exec.ExecDriver: Processing alias fmc_free_text 2013-12-04 11:12:45,034 INFO org.apache.hadoop.hive.ql.exec.ExecDriver: Adding input file hdfs://DEVHAD01.Devnet.corp:8020/user/hive/warehouse/fmc_free_text 2013-12-04 11:12:45,034 INFO org.apache.hadoop.hive.ql.exec.Utilities: Content Summary not cached for hdfs://DEVHAD01.Devnet.corp:8020/user/hive/warehouse/fmc_free_text 2013-12-04 11:12:45,152 INFO org.apache.hadoop.hive.ql.exec.ExecDriver: Making Temp Directory: hdfs://DEVHAD01.Devnet.corp:8020/tmp/hive-hive-hdfs/hive_2013-12-04_11-12-44_940_360291830025761971/-ext-10001 2013-12-04 11:12:46,160 INFO org.apache.hadoop.ipc.Client: Retrying connect to server: DEVHAD04.Devnet.corp/10.10.50.113:8021. Already tried 0 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS) Before eventually failing with: 2013-12-04 11:12:55,177 ERROR org.apache.hadoop.hive.ql.exec.Task: Job Submission failed with exception 'java.net.ConnectException(Call From DEVHAD03.Devnet.corp/10.10.50.112 to DEVHAD04.Devnet.corp:8021 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused)' Any thoughts are greatly appreciated. Thanks much, Joey
