We utilize the “Println” command in Spark SQL using Scala to display the result-set on the screen, and you’ll see how to use it in
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.
Bucketing in Apache Hive Part-2
Please see my previous post on bucketing and bucketed tables for more information. Bucketed Sorted Tables will be explored in this post. As discussed in
Transactional Tables in Apache Hive
It is now possible to create transactional tables that enable operations with ACID semantics in Hive 4.0 (HIVE-18453). These transactional tables are used for data
Accessing Part of the Date – Apache Impala
The most critical and significant column is always the date/time in the data. A date/time dimension provides all the information you need for a given
Integrity Constraints in Apache Hive
Since Hive 2.1.0, non-validated primary and foreign key constraints have been supported. When constraints are provided, several SQL tools generate more efficient queries. Since these
Add or Subtract Days to a Date – Apache Impala
There are plenty of built-in functions available in Apache Impala that helps in analyzing the data and business logic implementations. It relieves a developer’s worries
Big Data & SQL 