Hi @Srikanth You can try using the below approach : create table test1(store id, items STRING); insert into table test1 values(22, '1001 abc, 1002 pqr, 1003 tuv'); insert into table test1 values(33, '1004 def, 1005 xyz'); I have created a sample table in Hive and executed below query to get the expected result. select store, split(item,' ')[0] as item_id,split(item,' ')[1] as item_name from test1 lateral view explode(split(items,', ')) vExplodeTbl as item; ... View more

@Shu How is number of Mappers/reducers decided for a given query will be decided in runtime ? Is it dependet on how many number of Joins or group by or order by clauses that are used in the query ? If yes, then please let me know how many mappers and reducers are launched for the below query. select name, count(*) as cnt from test group by name order by name; ... View more

@Jordan Moore Thanks for the update !!! We are also working in the same fashion as you said, but I thought that other companies might be following agile/scrum methodologies for the Hadoop Development. Also, I have one more question; How is stand-up meetings or client interaction process done in big Data projects ? ... View more

@Jordan Moore Thanks for the suggestion. Can you please let me know how log from different sever collected in real-time projects ? If you know any link, you can share. ... View more

Thanks for the clarification @Shu ... View more

@Shu I have one doubt - If we change the contents of a file, will this affect to the metadata information stored on the Namenode. what happens if we keep on appending the data to the same file on daily basis? Also, what if we append large files, will this reduces performance ? Do you recommend to appending data the existing file or creating the new file ? Thanks, ... View more