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
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)
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)
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)
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)
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)