I am having a table called 'test_analysis' in that the values will be like following, ID NAME DOB LOCATION 1 bob 08/10/1985 NEW JERSEY 1 bob 08/10/1985 NEW YORK 1 bob 08/10/1985 NORTH CAROLINA 2 John 26/11/1990 OKLAHOMA i want output like, ID NAME DOB LOCATION 1 bob 08/1/1985 NEW JERSEY,NEW YORK,NORTH CAROLINA 2 John 26/11/1990 OKLAHOMA Please help me to form a hive query to get expected output. ... View more

So far i have created a directory called certification_tutorials through hue browser in my local sandbox and this is my path "/user/hue/certification_tutorials" when i try to access the same directory through putty it is always showing No such file or directories.i could not find the above directory when i use ls command. when i am trying to find i could. my present working directory is : /root i am able to redirected to /home directory after that i am not able to enter into /user/ directory please anyone help me on how to access "/user/hue/certification_tutorials" using putty. Thanks in advance ... View more