Thanks a lot for your response and the clarification. ... View more

Thanks Vini. Based on your suggestion I am able to connect. Thanking you Santanu ... View more

Thanks @Shu for the explanation. I really appreciate it. ... View more

Thanks Geoffrey for your response. Yes, I did that and now the issue is resolved. It seems, only the EC2 instance of N.Virginia region works fine for hdpcd practice exam. Not sure about the reason. But when I changed the region from drop down and created a new instance, I was able to connect from VNC Viewer. I hope that problem will not appear again. If so then I will reach out to you guys. Thanking you Santanu ... View more

Thanks Rahul ... View more

Thanks @Aditya Sirna for your response. It's working. I used this command. relation_1 = ORDER relation_0 BY <col_2> DESC PARALLEL 3; Thanking you Santanu ... View more

Thanks @rtrivedi for your help and response. It is now resolved. Also, I made a small modification to my sqoop code. I changed --input-null-string '\\N' instead of --input-null-string 'Unknown' (used previously). I am mentioning the entire sqoop code. sqoop export --connect jdbc:mysql://localhost:3306/my_db --username root --password-file /user/cloudera/textdata/sq_pwd_1.txt \ --export-dir /user/cloudera/hivedata/employee --table employee --staging-table employee_stg --clear-staging-table \ --input-null-string '\\N' --input-null-non-string '\\N' --input-fields-terminated-by "," --input-lines-terminated-by "\n" -m 1 Thanking you Santanu ... View more

@Santanu Ghosh Please make sure tat you use the correct SSH port for sandbox which is 2222 (not default 22). So please try the following command to do SSH to Sandbox: # ssh root@127.0.0.1 -p 2222 . OR # ssh maria_dev@127.0.0.1 -p 2222 Enter Password: maria_dev . ... View more