Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

nikoo28/ExcelRecordReader

Open more actions menu

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ExcelRecordReader

excel input format reader for hadoop

Check the file in src/test/resources/Sample.xlsx for a demo file

  1. Clone the project in any directory
  2. Navigate to the directory and use the command 'mvn clean install' to create the required jars.
  3. Include the jar file ExcelRecordReaderMapReduce-0.0.1-SNAPSHOT-jar-with-dependencies.jar in your environment.

You may test the jar using the command hadoop jar ExcelRecordReaderMapReduce-0.0.1-SNAPSHOT-jar-with-dependencies.jar input_directory output_directory

After the job has completed, check the output created on HDFS

hadoop fs -cat out/part*

0 Buffet Jimmy Somewhere on the Beach Key West FL
1 Bush George 1600 Pennsylvania Ave Washington DC
2 Cartman Eric 84 Bigboned Way South Park CO
3 Crockett Davey The Alamo San Antonio TX
4 Doe Jane 821 Zimbabwe Ave DC
5 Gates Bill 1 Microsoft Way Redmond WA

About

excel input format reader for hadoop

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages

Morty Proxy This is a proxified and sanitized view of the page, visit original site.