Read Excel File using MapReduce

The below code is used for reading excel files using MapReduce API. Entire source code has been taken from this link.   ExcelDriver.java https://gist.github.com/milindjagre/84cc1c230ffd10b7ec0b5db5a47f4c80 ExcelInputFormat.java https://gist.github.com/milindjagre/a8f2f35908ad0ce2d0d63a0725e3de4f ExcelMapper.java https://gist.github.com/milindjagre/3a77b5430111ead3eb3f538a5db72210 ExcelParser.java https://gist.github.com/milindjagre/34966d289da2e6d33dfbf0f76fc75271 ExcelRecordReader.java https://gist.github.com/milindjagre/d45935abc259d594e1ed495ca2a67d7a pom.xml https://gist.github.com/milindjagre/f95e366cf4766070652608c05783be0f If you clean and build above project, it will create two jar files, out of which we have to use the jar file … Continue reading Read Excel File using MapReduce

NetBeans IDE Installation on Ubuntu 14.04

Download NetBeans IDE through web browser from https://netbeans.org/downloads/ open new terminal window cd Downloads sudo chmod +x netbeans* ./netbeans* Above command will open a GUI which will guide you to install netbeans step by step.  

RECORD INSERTION IN MYSQL TABLE

We are going to insert the data into mysql table ‘sample’. We will use Java programming language for doing the same.   In case you missed how to connect your database with the JAVA programming language, you should refer this link below. https://milindjagre.wordpress.com/2014/04/25/mysql-database-connection-through-java/   Once you establish the connection with MySQL database, all you need … Continue reading RECORD INSERTION IN MYSQL TABLE

MYSQL DATABASE CONNECTION THROUGH JAVA

MySQL can be connected with the help of JAVA programming language. For this we require a driver which will enable us to create a connection to connect to MySQL database. A connection object is created with the help of getConnection() method of DriverManager class. The standard syntax of this getConncetion() method contains one, two and … Continue reading MYSQL DATABASE CONNECTION THROUGH JAVA

COMMAND LINE ARGUMENTS

  The concept that we are going to talk today is about printing i.e. accessing the elements or arguments that we enter on the command line in the runtime. There are plenty of ways to implement this thing. For naïve programmers, we can use the simple editor and then run the program on the command … Continue reading COMMAND LINE ARGUMENTS