ODBC Hive error


 
Thread Tools Search this Thread
# 1  
ODBC Hive error

Hi ,

I am trying to setup HIVE ODBC with below setting
Code:
Host: Local host
port : 10000
Database : Default
Hive server type : Hive server 2
Mechanism: User

But getting below error:
Code:
Driver Version: V2.5.0.1001

Running connectivity tests...
Code:
Attempting connection
Failed to establish connection
SQLSTATE: HY000[Cloudera][Hardy] (34) Error from Hive: ETIMEDOUT.

TESTS COMPLETED WITH ERROR.

 netstat -nl | grep 10000
tcp        0      0 0.0.0.0:10000               0.0.0.0:*                   LISTEN

---------- Post updated 11-12-13 at 11:21 AM ---------- Previous update was 11-11-13 at 01:59 PM ----------

I am still struck with the issue and any help would be greatly appreciated.

Last edited by Scott; 11-11-2013 at 03:02 PM.. Reason: Use code tags, please...
# 2  
just a thought !

Quote:
Originally Posted by rakesh_411
Hi ,

I am trying to setup HIVE ODBC with below setting
Code:
Host: Local host
port : 10000
Database : Default
Hive server type : Hive server 2
Mechanism: User

But getting below error:
Code:
Driver Version: V2.5.0.1001

Running connectivity tests...
Code:
Attempting connection
Failed to establish connection
SQLSTATE: HY000[Cloudera][Hardy] (34) Error from Hive: ETIMEDOUT.

TESTS COMPLETED WITH ERROR.

 netstat -nl | grep 10000
tcp        0      0 0.0.0.0:10000               0.0.0.0:*                   LISTEN

---------- Post updated 11-12-13 at 11:21 AM ---------- Previous update was 11-11-13 at 01:59 PM ----------

I am still struck with the issue and any help would be greatly appreciated.
Hello,

2.Add the following section to the DM's corresponding odbc.ini:
[Hive]
Driver = <path_to_libodbchive.so>
Description = Hive Driver v1
DATABASE = Default
HOST = <Hive_server_address> >> put your host IP here <<
PORT = <Hive_server_port>
FRAMED = 0

Regards
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

6 More Discussions You Might Find Interesting

1. Programming

How to arhive hive external tables?

Hi Guys, Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)
Discussion started by: Master_Mind
10 Replies

2. Shell Programming and Scripting

Extract hive table structure

Hi, I need to extract only the create table structure with columns alone. for eg hive_table show create table hive_table: create table hive_table(id number,age number) OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs:/path/' I need only below ... (5 Replies)
Discussion started by: rohit_shinez
5 Replies

3. Shell Programming and Scripting

Perl ODBC error

my question (8 Replies)
Discussion started by: sauravrout
8 Replies

4. Shell Programming and Scripting

Cron job fails with [DataDirect][ODBC lib] Connection not open error

Hi, When run the script directly...it executes as expected. But when put it in crontab the job fails with this error: Connection not open 08003: Connection not open Unable to connect to the database... how come it is not able to connect when cron job fires?... Do I need to... (7 Replies)
Discussion started by: nuthakki
7 Replies

5. UNIX and Linux Applications

Permission ERROR: Unable to load the User's Hive

Hi all, Please help me solving the error that i get when i trigger the job from autosys. The job is failing after going to restart start and it is throwing an "exit code:128". Please help me understand whats this exit code and how to overcome this. And when i check the logs its giving me an... (4 Replies)
Discussion started by: Bharath V
4 Replies

6. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

Featured Tech Videos