Hi, I was trying to setup an EC2 instance to practice Hortonworks practical exam. I followed the steps mentioned in the guide. I am at step 13, where it mentioned that, I should download VNC client to connect to EC2 instance. I used public dns followed by :5901 and I am getting timeout error. Looks like it's not able to reach EC2 instance. Please let me know if any one faced the same issue. Thanks.. ... View more

Hello Friends, I am new to Hadoop and Hive. Created a simple table with one column as ID and loaded data into this table from a file that's located in local filesyste with 6 (one with NULL) records with command as "load data local inpath '/home/edureka/Desktop/data' into table emp;" Did select and it's show 5 records. Later manually changed the source file and removed all those 5 records and added 5 new records and loaded these new records without using the OVERWRITE with command "load data local inpath '/home/edureka/Desktop/data' into table emp;" Data load was successful. This time if I do select * then I am getting 18 records. 1st set is repeating twice. I don't know why it's showing like this. Am I missing any command ? pls help me to understand. Pls refer the screenshot. Thankscapture.png ... View more