hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brad Ruderman <bruder...@radiumone.com>
Subject Re: Hive ODBC Error
Date Wed, 04 Dec 2013 19:13:31 GMT
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 <jdanton1@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
>
>
>
>

Mime
View raw message