When trying to connect remote postgresql server with pgAdmin, leads to "Unable to connect" error.

To enable pgAdmin to connect, edit the following configuration in the server:

$ sudo vim /etc/postgresql/9.3/main/postgresql.conf
   listen_address = '*'

$ sudo vim /etc/postgresql/9.3/main/pg_hba.conf
   local    all     postgresql          trust …

The following link provides an extensive guide on setting up a multi-node cluser with Hortonworks HDP2 on EC2.

Multi-node cluster installation guide

Though setting up single-node cluster from this guide is quite obvious, I'm documenting here those few so called obvious deviations.

The operating system I choose to install is …

I was getting the below mentioned exception on my Java client which is trying to establish URL connection to a server.

javax.net.ssl.SSLProtocolException: handshake alert: unrecognized_name

The Java client was actually trying to get an XML from the the URL and store it locally in a file as …

PyTypeObject is a structure that defines the basic building blocks of Python, Types.

The definition as found in Include/Object.h file:

typedef struct _typeobject {
    PyObject_VAR_HEAD
    const char *tp_name; /* For printing, in format "<module>.<name>" */
    Py_ssize_t tp_basicsize, tp_itemsize; /* For allocation */

    /* Methods to implement standard operations */

    destructor …

I'm starting to read the Core Python Programming book. Over past few months I've already started to program in python, like developing web apps with django and data analytics with pandas. I started to like the language, so wanted to go back to the basics of it and I'm begining …

We would be getting data from different sources for doing data analysis. Most common being from files, we might even source from databases.

This post will show how to load data from postgres database to pandas DataFrame. pandas is a python based data analysis tool.

import psycopg2 as pg
import …

We have to configure hibernate, if we require the application to create the table when it doesn't already exists. Else, we would end up with the below mentioned exception.

ERROR: ERROR: relation "mytable" does not exist
  Position: 13
org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception …

IMDB top 250 movies visualized with d3js

While trying Cloudera CDH quickstart VM in my Windows 7 machine, I was facing issues to start it with VMware player.

I was getting the following error message.

The import failed because D:\VirtualMachines\cloudera-quickstart-vm-4.3.0-vmware\cloudera-quickstart-vm-4.3.0-vmware.ovf did not pass OVF specification conformance …

Last week I've attended a Django Session in PyCon India 2013 presented by Arun Ravindran. It was a good session which covered the basics. I started learning Django by doing a considerably big application, and now I'm uncovering the basics step by step. In certain cases I required a very …