merge output files after reduce phase

HadoopMapreduce

Hadoop Problem Overview


In mapreduce each reduce task write its output to a file named part-r-nnnnn where nnnnn is a partition ID associated with the reduce task. Does map/reduce merge these files? If yes, how?

Hadoop Solutions


Solution 1 - Hadoop

Instead of doing the file merging on your own, you can delegate the entire merging of the reduce output files by calling:

hadoop fs -getmerge /output/dir/on/hdfs/ /desired/local/output/file.txt

Note This combines the HDFS files locally. Make sure you have enough disk space before running

Solution 2 - Hadoop

No, these files are not merged by Hadoop. The number of files you get is the same as the number of reduce tasks.

If you need that as input for a next job then don't worry about having separate files. Simply specify the entire directory as input for the next job.

If you do need the data outside of the cluster then I usually merge them at the receiving end when pulling the data off the cluster.

I.e. something like this:

hadoop fs -cat /some/where/on/hdfs/job-output/part-r-* > TheCombinedResultOfTheJob.txt

Solution 3 - Hadoop

That's the function you can use to Merge Files in HDFS

public boolean getMergeInHdfs(String src, String dest) throws IllegalArgumentException, IOException {
	FileSystem fs = FileSystem.get(config);
	Path srcPath = new Path(src);
	Path dstPath = new Path(dest);
	
	// Check if the path already exists
	if (!(fs.exists(srcPath))) {
		logger.info("Path " + src + " does not exists!");
		return false;
	}
	
	if (!(fs.exists(dstPath))) {
		logger.info("Path " + dest + " does not exists!");
		return false;
	}
	return FileUtil.copyMerge(fs, srcPath, fs, dstPath, false, config, null);
}

Solution 4 - Hadoop

For text files only and HDFS as both the source and destination, use the below command:

hadoop fs -cat /input_hdfs_dir/* | hadoop fs -put - /output_hdfs_file

This will concatenate all the files in input_hdfs_dir and will write the output back to HDFS at output_hdfs_file. Do keep in mind that all the data will be brought back to the local system and then again uploaded to hdfs, although no temporary files are created and this happens on the fly using UNIX pe.

Also, this won't work with non-text files such as Avro, ORC etc.

For binary files, you could do something like this (if you have Hive tables mapped on the directories):

insert overwrite table tbl select * from tbl

Depending on your configuration, this could also create more than files. To create a single file, either set the number of reducers to 1 explicitly using mapreduce.job.reduces=1 or set the hive property as hive.merge.mapredfiles=true.

Solution 5 - Hadoop

The part-r-nnnnn files are generated after the reduce phase designated by 'r' in between. Now the fact is if you have one reducer running, you will have an output file like part-r-00000. If the number of reducers are 2 then you're going to have part-r-00000 and part-r-00001 and so on. Look, if the output file is too large to fit into the machine memory since the hadoop framework has been designed to run on Commodity Machines, then the file gets splitted. As per the MRv1, you have a limit of 20 reducers to work on your logic. You may have more but the same needs to be customised in the configuration files mapred-site.xml. Talking about your question; you may either use getmerge or you may set the number of reducers to 1 by embedding the following statement to the driver code

job.setNumReduceTasks(1);

Hope this answers your question.

Solution 6 - Hadoop

You can run an additional map/reduce task, where map and reduce don't change the data, and partitioner assigns all data to a single reducer.

Solution 7 - Hadoop

Besides my previous answer I have one more answer for you which I was trying few minutes ago. You may use CustomOutputFormat which looks like the code given below

public class VictorOutputFormat extends FileOutputFormat<StudentKey,PassValue> {

	@Override
	public RecordWriter<StudentKey,PassValue> getRecordWriter(
			TaskAttemptContext tac) throws IOException, InterruptedException {
		//step 1: GET THE CURRENT PATH
		Path currPath=FileOutputFormat.getOutputPath(tac);
		
		//Create the full path
		Path fullPath=new Path(currPath,"Aniruddha.txt");
		
		//create the file in the file system
		FileSystem fs=currPath.getFileSystem(tac.getConfiguration());
		FSDataOutputStream fileOut=fs.create(fullPath,tac);
		return new VictorRecordWriter(fileOut);
	}

}

Just, have a look at the fourth line from the last. I have used my own name as the output file name and I have tested the program with 15 reducers. Still the File remains the same. So getting a single out file instead of two or more is possible yet to be very clear the size of the output file must not exceed the size of the primary memory i.e. the output file must fit into the memory of the commodity machine else there might be a problem with the output file split. Thanks!!

Solution 8 - Hadoop

Why not use a pig script like this one for merging partition files:

stuff = load "/path/to/dir/*"

store stuff into "/path/to/mergedir"

Solution 9 - Hadoop

If the files have header, you can get rid of it of by doing this:

hadoop fs -cat /path/to/hdfs/job-output/part-* | grep -v "header" > output.csv

then add the header manually for output.csv

Solution 10 - Hadoop

> . Does map/reduce merge these files?

No. It does not merge.

You can use IdentityReducer to achieve your goal.

> Performs no reduction, writing all input values directly to the output.

public void reduce(K key,
                   Iterator<V> values,
                   OutputCollector<K,V> output,
                   Reporter reporter)
            throws IOException

>Writes all keys and values directly to output.

Have a look at related SE posts:

https://stackoverflow.com/questions/10630447/hadoop-difference-between-0-reducer-and-identity-reducer

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionShahryarView Question on Stackoverflow
Solution 1 - HadoopdiliopView Answer on Stackoverflow
Solution 2 - HadoopNiels BasjesView Answer on Stackoverflow
Solution 3 - HadoopMervynView Answer on Stackoverflow
Solution 4 - HadoopGaurav KumarView Answer on Stackoverflow
Solution 5 - HadoopAniruddha SinhaView Answer on Stackoverflow
Solution 6 - HadoopadamaxView Answer on Stackoverflow
Solution 7 - HadoopAniruddha SinhaView Answer on Stackoverflow
Solution 8 - HadoopIanView Answer on Stackoverflow
Solution 9 - HadoopMasihView Answer on Stackoverflow
Solution 10 - HadoopRavindra babuView Answer on Stackoverflow