If you’re working on a numeric/integer column and decided to substitute null values with zero, there’s a straight forward function that solves the issue. The
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.
NVL vs NVL2 Functions in Apache Impala
Many of the functions that are present in Apache Hive and Impala are close to the functions of conventional frameworks such as Oracle SQL*Plus and
Apache Impala – Export Query Results To A File
Similar to traditional relational systems, it is possible to export the results of the query to a file in Apache Impala. This can be with
A Common Mistake In Defining File Format In Hive
Often the written code is parsed, often an error is not returned from the table generated with file formats, however it is obvious that even
Apache Impala – Executing SQL file in non-Interactive Mode
The purpose of this article is to explore non-interactive mode of execution of the local file to retrieve records from Impala through the command line
Is Complex Data Really Complex To Handle?
Let’s split the title-question into two. What is the complex data and how complex it is to handle. First, let’s see what complex data is.
Big Data & SQL 