Thursday, May 29, 2014

Pivot and Unpivot operations in Oracle 11g Release 2

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-51418703-1', 'ittektalk.blogspot.com'); ga('send', 'pageview'); This article shows how to use the new PIVOT and UNPIVOT operators in 11g release 2. PIVOT For starting, we need some data 1 2 3 4 5 ...

Wednesday, May 14, 2014

Ubuntu Server 14.04 - Install Sqoop 1.99.3

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-51418703-1', 'ittektalk.blogspot.com'); ga('send', 'pageview'); Following steps to install Apache Sqoop...

Ubuntu Server 14.04 - Install Hive 0.13.0

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-51418703-1', 'ittektalk.blogspot.com'); ga('send', 'pageview'); Following steps to install Hive 0.13.0 1. Download hive tar 1 hduser@ubuntu:~$ wget http://mirror.tcpdiag.net/apache/hive/hive-0.13.0/apache-hive-0.13.0-bin.tar.gz 2....