Cloudera Hive Connection

One Star

Cloudera Hive Connection

In Componen section what is the configuration for single node CDH 4.2 installation.
This is what I have put under Basic Setting:
Distribution: Cloudera Hive Version: Cloudera CDH 4
Connection Mode: Standalone Hive Server: Hive 2
Host: localhost Port: <BLANK>
Database: "default" and also tried without ""
Username: root Password: <PASSWORD> (I dont have hive username/password)
Both Hadoop properties are uncheck
Following errors
1) localhost cannot be resolved to a variable
2) The operator + is undefined for the argument type(s) String
3) root cannot be resolved to a variable
4) password cannot be resolved to a variable
Thanks
Employee

Re: Cloudera Hive Connection

Hello,
I think there are a lot of errors here.
The first error is: Everything you write in the Talend parameters, which is written in quotes by default, has to be put in quotes ("localhost" and not localhost).
The second is: If you don't have username/password, please leave them empty (I mean empty string, so leave "").
The blank port is not good. By default, Hive and Hive2 in standalone mode use the port 10000, so please use this port.
I recommend you tu use the namenode and the jobtracker parameters, they will allow you to execute your job against the Hadoop cluster and to avoid some configuration errors.
Please let me know the result,
HTH,
Rémy.
One Star

Re: Cloudera Hive Connection

i have configured with hostname and given port as 10000
it simply says connection failed
i am using cloudera chd4
i have give name node uri hostname:50070
job tracker URI hostname:50030
where i went wrong?
Employee

Re: Cloudera Hive Connection

The ports are wrong for your JT and your NN.
The ports are not 50070 and 50030 but 8020 and 8021. 50030 and 50070 are the web port.
One Star

Re: Cloudera Hive Connection

Hi rdubois,
I have changes the the namenode uri, job traker uri to hostname:8020 and hostname:8021
but no success.
is there any other thing to check
Employee

Re: Cloudera Hive Connection

Could I have a stack trace?