Tag Archives: postgreSQL

Import RDBMS table to HDFS with sqoop from postgreSQL

Steps: 1. Download JDBC driver      2. Copy:    3. Configure:  file. You need to allow the IP/host of machine running Hadoop. Restart postgreSQL using    4. Run sqoop: Open the terminal on machine running hadoop and type the below command.     Enter password:   prerequisites: Cloudera hadoop VM distribution or any other machine running… Read More »

PostgreSQL useful tips

I am posting some of the PostgreSQL commands which I use frequently. Create a new database name testdb # createdb <dbname> e.g: Remove a PostgreSQL database # dropdb <dbname> e.g: Backing up a PostgreSQL database Restoring PostgreSQL database from back up dump Writing query output to a CSV file: After this operation all the query results… Read More »