How to process XML data files using Hive of Big Data

Copy your xml data file into your local folder

Now create hive table

Hive> create table xmltable(mystr string);

Load data into hive table from local xml file

Hive>load data local inpath ‘xmlfile’ into table xmltable;

Use XPath to convert the array data into normal hive table data

hive> SELECT xpath(xpathexpression)  FROM xmltable;

How to process JSON data file using HIVE in Big Data

Use Hive-JSON SerDe

Copy hive-json-serde.jar to the Hive server

Copy test,json file into your folder.

ADD JAR /path/to/hive-json-serde.jar;

Create a table

       CREATE TABLE test_json_table (
          field1 string, field2 int, field3 string
       )
       ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.JsonSerde'
       LOAD DATA LOCAL INPATH '/tmp/test.json' INTO TABLE


Write a simple SELECT statement to fetch the data

SELECT field1,field2,field3 FROM test_json_table;

Connecting to MySQL via Sqoop in Big Data

Syntax to import data from any relational database

sqoop import --connect <JDBC connection string> --table <tablename> --username <username> --password <password>

sqoop import --connect jdbc:mysql://ipaddress/db --username <enter user name> --password <enter password> --table tble

What is AngularJS

AngularJS is Javascript framework developed by Google.

Add the AngularJS libraries to your web page by adding the following

<script src="//ajax.googleapis.com/ajax/libs/angularjs/1.2.17/angular.min.js"></script>

Use directives to like ng-model dynamically display the content.

Advantages: 2 way data binding and huge directives for DOM manipulation.It follows MVC design pattern.

What is Xamarin

A powerful tool for building cross-platform mobile apps using C#.

Download Xamarin from http://xamarin.com/download

Launch Xamarin Studio and select Android -> Android Application for developing Android Apps

Launch Xamarin Studio and select IOS -> iPhone > Single View or Tabbed Application for developing IOS Apps.

ASP.NET WEB API 2

ASP.NET Web API is framework for building RESTful applications on the .NET Framework.

In Web API, a controller is an object that handles HTTP requests when you are creating MVC based applications.

Some of the features are

Attribute Routing, OData, etc..

How to Develop a Cross platform mobile application

We can develop cross platform Mobile Apps using PhoneGap and It is platform dependent

Download it from phonegap.com