Monthly Archives: February 2016

Import MySQL data to HDFS through Sqoop

Create Database in MySQL [Database: adil] Create Table in MySQL Database [Table: employees] Insert some data Now try to import data from MySQL by using below command sqoop import –connect jdbc:mysql://192.168.1.7:3306/adil –username admin –password *********** –table employees -m 1 Successful

Posted in Big Data, Hadoop

How to Install Sqoop

Download latest Sqoop connector (ZIP file) from Apache site and Extract Now connect through FTP Create folder “sqoop” under “use/lib” and copy jar files to lib folder of Now move to sqoop folder Copy all files to sqoop folder

Posted in Big Data, Hadoop

SAP Fiori on cloud: Create a New Destination to a Public OData Provider

Access the SAP HANA Cloud Platform Cockpit via this link: https://account.hanatrial.ondemand.com/cockpit Click on “New Destination” Enter values as below and press “Save” Click on “Check Connection” Connection successful.

Posted in Fiori, SAP HANA

Installation and Configuration of JetBrains IDE’s for mongoDB

Download JetBrains IDE https://d1opms6zj7jotq.cloudfront.net/idea/ideaIC-15.0.3.exe Run EXE and Install Setup Run “IntelliJ IDEA Community Edition 15.0.3” Make sure “Mongo Plugin” install correctly. If not search and Install. Now Define the path of mongo executable and test. Now add Mongo Server and

Posted in Big Data, MongoDB

Install MongoDB on Windows 7 64bit

Download MongoDB https://www.mongodb.org/downloads?_ga=1.148407991.1803173613.1455436913#production Note: For Windows 7 64bit install Hot Fix from Microsoft before install MongoDB https://support.microsoft.com/en-us/kb/2731284 Run below code to install setup in background, in specific location and All Features msiexec.exe /q /i mongodb-win32-x86_64-2008plus-ssl-3.2.1-signed.msi ^ INSTALLLOCATION=”D:\mongodb” ^ ADDLOCAL=”all” Create

Posted in Big Data, MongoDB

Hadoop: How many people belong to each state, using Hue (Hive, PIG and Impala)

Login to Hue site Upload sample file to HDFS using File Browser Create folder using New à Directory option. I created “people” folder Now upload sample file to HDFS by using upload option. Select File File is uploaded to HDFS

Posted in Big Data, Hadoop