The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments. If the first
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Hive Internal vs External Tables
This article offers a summary of the situations in which you would need to create internal (managed) tables and external tables in Apache Hive. Create “External” tables when: the data is being used outside the Hive. The data files are read and
Big Data: Apache Hive & Impala Data Types Quick Reference
This article offers an overview of the various data types that are available both in Apache Hive & Impala. TINYINT – 1 byte Range: -128 to 127 SMALLINT – 2 bytes Range: -32,768 to 32,767
TOP, LIMIT, ROWNUM vs DENSE_RANK
What would you do if you were asked to identify top-ten products based on their prices? In SQL Server, using a TOP clause with a
Sqoop Complete Tutorial Part-7
This is the continuation part of “Sqoop Complete Tutorial”. If you want to read – Part-1, please click here. Part-2, please click here. Part-3, please
Sqoop Complete Tutorial Part-6
This is the continuation part of “Sqoop Complete Tutorial”. If you want to read – Part-1, please click here. Part-2, please click here. Part-3, please
Big Data & SQL 