for example if one of the datanode gets down and namenode didnt receive heartbeat untill 10 mins so it will copy all the data that datanode was containing to another datanode in order to maintain replication factor but suppose after 10 mins datanode gets up in that case the block will be over replicated ., so how will it maintain the replication factor?? Will it detect and delete that data automatically?? ... View more

I want to convert format of date from 01/05/2017 15:29:19.4980 to YYYY-MM-DD HH:MM:SS in pig. kindly help. ... View more

I am running below query: MERGE INTO college_for_mrg AS T USING college AS S ON clg_name = clg_name WHEN MATCHED AND clg_id > 5 THEN UPDATE SET clg_loc = "ind" WHEN NOT MATCHED THEN INSERT VALUES(2,"sd","dsd","dsfs"); Both the tables support acid properties. i have also tried table name as database_name.table_name in query but still its giving same error. error: FAILED: ParseException line 3:0 cannot recognize input near 'MERGE' 'INTO' 'college_for_mrg' please help. ... View more