Introduction Creating a database in MySQL is exceptionally as you only have to execute one SQL statement after logging in. Step-by-Step Open a terminal and run the following commands. mysql -u root -p This will open the mysql> prompt. CREATE DATABASE mytest;
What is the Google Wallet Android app? I have finally had an occasion to use the Google Wallet app on my Galaxy Nexus. So what is the Google Wallet Android app? It’s basically an Android app that acts like a digital credit card that you can use to purchase coffee at Peet’s, medicine at CVS …
Introduction I had installed JDK 6.0 update 31 in an earlier post. However, I now need to write a Java application that requires the features available in JDK 7. In this post, I will install JDK 7 update 5 as a secondary JDK, while JDK 6.0 u31 will be the primary JDK. It’s perfectly normal …
Introduction Creating a DB connection from Kettle to MySQL involves creating a MySQL use who can access the DB in question, installing the JDBC driver, and creating a connection. Install the MySQL JDBC driver Download the MySQL JDBC driver from http://dev.mysql.com/downloads/connector/j/. Login to mysql.com, then click Download. cd ~/Downloads tar -xzf mysql-connector-java-5.1.20.tar.gz cd mysql-connector-java-5.1.20 cp …
Introduction Sakila is an example database for MySQL. It is often used for training purposes. Installation cd ~/Downloads wget http://downloads.mysql.com/docs/sakila-db.tar.gz tar -xzf sakila-db.tar.gz cd sakila-db mysql -u root -p < sakila-schema.sql mysql -u root -p < sakila-data.sql
Introduction Open Kettle cd ~/bin/data-integration To run Spoon: ./spoon.sh Create a new repository Run the following in a terminal. mkdir ~/kettle The steps below are performed within the PDI UI. In the Repository Connection dialog box, click the small green plus symbol. In the Select the repository type dialog box, select Kettle file repository. Click …
Introduction Installing the MySQL package on Ubuntu is extremely simple. Installation Open a terminal and enter the following commands. sudo apt-get install mysql-client mysql-navigator mysql-server Type Y to accept the additional packages. Press Enter. After downloading and during installation, the MySQL configuration dialogs will display in the terminal. In the first dialog, press Enter. Enter …
Introduction If you are running Hadoop on a development machine, then it’s likely that you’ll run into a situation where multiple services require port 8080. I recently ran into this issue where both the Pentaho User Console and the Hadoop MapReduce ShuffleHandler were trying to use port 8080. One solution is to change the port …
Introduction Sqoop is a tool to import data from an SQL database into Hadoop and/or export data from Hadoop into an SQL database. Sqoop can import/export from HDFS, HBase and Hive. It’s extremely common to use SQL databases as part of the setup in for Hadoop. Often, a SQL database will serve as an upstream …
Introduction These instructions cover a manual installation of the Cloudera CDH4 packages on Ubuntu 12.04 LTS and are based on my following the Cloudera CDH4 Quick Start Guide (CDH4_Quick_Start_Guide_4.0.0.pdf). Installation prerequisites sudo apt-get install curl Verify that Java is installed correctly First, check that Java is setup correctly for your account. echo $JAVA_HOME The output …
AkbarAhmed.com 