I am getting intermittent issue in one of the clusters where datanodes aren't responding to namenodes. If they are not able to respond to namenodes withing 30 secs, then namenode is marking them as stale. What could be the possible issue and what can be the possible way I can overcome this? Thanks in advance. ... View more

I have a string like "I want the reverse case for every LETTER in this string". I want to convert the case of the words in this string in a way that I get letters in lower case in upper case and vice versa.I want my output to read " i WANT THE REVERSE CASE FOR EVERY letter IN THIS STRING" . I want to do this using PIG and HIVE, both. Can I achieve it without using a UDF. Can somebody help me out here ? ... View more

Hello , I am trying to configure squirrel SQL into my machine. I am following this document: https://community.hortonworks.com/content/supportkb/49452/how-to-set-up-squirrel-sql-for-hive-which-is-integ.html However, I am stuck at step no. 4 (If krb5.ini location is not a default location, also add -Djava.security.krb5.conf="C:\Some\Papth\To\krb5.ini) . I am not able to find krb5.ini in squirrel-sql.sh . can anyone please help me with this step? I am not able to proceed further. ... View more

I am trying to connect squirrel SQl to hiveserver2. According to one of the documents in the hortonworks forum (https://community.hortonworks.com/content/supportkb/49452/how-to-set-up-squirrel-sql-for-hive-which-is-integ.html) , Can anyone explain me on how to execute the 3rd step in detail (Download JCE jars and copy into %JAVA_HOME%\jre\lib\security) ? The java version i am using is "1.8.0_131" . ... View more

on trying to install SquirrelSql, i am facing certain issues. When trying to add connection in the aliases tab , I have provided url of one of the hosts in our cluster and provided username and password of one of the technical users. when i test the connection , i get something like this: test connection: Access denied for user 'ta50001q'@'nlvhpraab01805.solon.prd' (using password: YES) class java.sql.SQLException: Access denied for user 'ta50001q'@'nlvhpraab01805.solon.prd' (using password: YES) is it because the connection cannot be done between my localhost and the cluster this way.? also, if i provide the localhost connection, i need a username and password without which I wont be able to connect successfully. Is there any default value for username and password that i can use ? Can anyone help me out here with regards to both the cases mentioned above? ... View more

I want to install hue for my environment. can anyone please let me know if hue compulsorily uses webhdfs ? If no, how can i configure it for my environment ? ... View more

can anyone suggest any tool to generate test data of large sizes (atleast 1gb) for hive? Looking for simpler tools unlike testbench. ... View more

Hello, I want to enable SSL and TLS for communication between the components installed in my cluster. I havent done this before. Can anyone suggest me the steps to enable SSL and TLS in detail ? If it has to be done using CLI, are there particular commands to do the same ? If yes, what is the command ? Thanks in advance. ... View more

A particular worker node region server is getting down very frequently. Restarting the service also doesn't resolve issue. can anyone give me an idea of what might be the issue or what things i need to look for in logs? ... View more