I have had much better luck with the Cloudera driver, especially since you are using the cloudera dist.
Can you send the logs from /var/log/hive/hive-server2.out and hive-server2.log? Thanks! On Wed, Dec 4, 2013 at 8:26 AM, Joseph D Antoni <jdant...@yahoo.com> wrote: > 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 > > > >
