July | 2012 | AkbarAhmed.com

Install RazorSQL on Ubuntu 12.04 LTS x64

akbarsahmed

July 26, 2012

Introduction RazorSQL is a GUI tool for working with Postgresql. Install RazorSQL First, create the razorsql directory. mkdir ~/Downloads/razorsql Download RazorSQL into the ~/Downloads/navicat directory. Open a web browser to http://www.razorsql.com/download_linux.html. Click Download next to Linux (64-bit). After the download completes, open a command prompt and enter the following commands. I have assumed that you …

Enable TCP/IP Connections to Postgresql 9.1

akbarsahmed

no comments

July 26, 2012

Introduction The default installation of Postgresql does not allow TCP/IP connections, which also means JDBC connections wont’ work. Enable TCP/IP Connections cd /etc/postgresql/9.1/main Let’s make a backup of the original config file. sudo cp postgresql.conf postgresql.conf.org sudo vi postgresql.conf Find the line that contains #listen_addresses = ‘localhost’ and change it to: listen_addresses = ‘localhost’ If …

Initial Configuration of Postgresql on Ubuntu 12.04 LTS

akbarsahmed

no comments

July 26, 2012

Introduction After installing Postgresql on Ubuntu, you will need to complete a few basic setup steps. Set the Password for the postgres User The first step is to update the password for the postgres user. sudo -u postgres psql postgres Then enter the following command at the postgres=# prompt. \password postgres Create a Database If …

Install Postgresql on Ubuntu 12.04 LTS

akbarsahmed

1 comment

July 25, 2012

Introduction Postgresql is an open source object relational database. It is often thought of as an alternative to MySQL. In this post I’ll provide the steps required to install Postgresql on a developer laptop, assuming that work will be done in both SQL and Python. You can learn more at: Postgresql web site Postgresql on …

How to write professional emails (Top 10 list)

akbarsahmed

no comments

July 22, 2012

I was going through my old notes as I’m cleaning our my closet. I came across the following notes, that I like a lot, on how to write a professional email. Use email macros to both improve your efficiency in replying to email, and to improve quality. End each sentence with the correct punctuation. Write …

How to add numbers with Pig

akbarsahmed

no comments

July 20, 2012

Introduction We’re going to start with a very simple Pig script that reads a file that contains 2 numbers per line separated by a comma. The Pig script will first read the line, store each of the 2 numbers in separate variables, and will then add the numbers together. Create the Sample Input File cd …

Install Pig 0.9.2 for CDH4 on Ubuntu 12.04 LTS x64

akbarsahmed

no comments

July 20, 2012

Introduction Installing Pig is drop dead simple. Installation sudo apt-get install pig Check the Pig version. pig –version Setup the Environment We’re going to set the environment variables system-wide for Pig programming. sudo vi /etc/environment Paste the following environment variables into the environment file. HADOOP_MAPRED_HOME=”/usr/lib/hadoop-mapreduce” PIG_CONF_DIR=”/etc/pig/conf” source /etc/environment That’s it. You can now start to …

Install Pentaho Analysis Services (Mondrian) 3.4.1 with MySQL on Ubuntu 12.04 LTS

akbarsahmed

4 comments

July 19, 2012

Introduction Pentaho Analysis Services is called Mondrian, which is the name I’ll use for the remainder of this post. Mondrian is Pentaho’s OLAP server. In this post I’ll provide step-by-step instructions on how to install Mondrian 3.4.1 Ubuntu Linux 12.04 LTS x64. We’ll use MySQL as the database. Download Let’s first create a directory to …

How to view files in HDFS (hadoop fs -ls)

akbarsahmed

no comments

July 15, 2012

Introduction The hadoop fs -ls command allows you to view the files and directories in your HDFS filesystem, much as the ls command works on Linux / OS X / *nix. Default Home Directory in HDFS A user’s home directory in HDFS is located at /user/userName. For example, my home directory is /user/akbar. List the …

hdfs dfsadmin -metasave

akbarsahmed

no comments

July 15, 2012

Introduction hdfs dfsadmin -metasave provides additional information compared to hdfs dfsadmin -report. With hdfs dfsadmin -metasave provides information about blocks, including> blocks waiting for replication blocks currently being replication total number of blocks hdfs dfsadmin -metasave filename.txt Run the command with sudo -u hdfs prefixed to ensure you don’t get a permission denied error. CDH4 …

AkbarAhmed.com

Engineering Leadership

Month: July 2012

Install RazorSQL on Ubuntu 12.04 LTS x64

Enable TCP/IP Connections to Postgresql 9.1

Initial Configuration of Postgresql on Ubuntu 12.04 LTS

Install Postgresql on Ubuntu 12.04 LTS

How to write professional emails (Top 10 list)

How to add numbers with Pig

Install Pig 0.9.2 for CDH4 on Ubuntu 12.04 LTS x64

Install Pentaho Analysis Services (Mondrian) 3.4.1 with MySQL on Ubuntu 12.04 LTS

How to view files in HDFS (hadoop fs -ls)

hdfs dfsadmin -metasave