Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
5 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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?
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Could I have a stack trace?