ORDER BY in HiveQL is similar to ORDER BY in SQL language, both in syntax and functionality. Order by is a clause that we use
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.
Terminate Query Execution in Apache Hive & Impala
In some instances, we may need to abort the query execution. The reason might be because an erroneous query was executed, a change of mind,
Change Location of Managed Table in Hive
Internal tables are similar to regular database tables in that data may be stored and queried on them. When the data is either temporary or
Exploring Input File Formats – Part-2
Before reading the below article, first read File Formats and Compression in Apache Hive & Exploring Input File Formats – Part-1. It’s a follow-up post
Working with variables in Apache Hive
The purpose of this tutorial is to demonstrate how to work with variables in Apache Hive. Because Apache Hive does not function in the same
Exploring Input File Formats – Part-1
This blog aims to provide practical knowledge on Apache Hive’s input file formats. After reading this article, you would have a clearer idea of how
Big Data & SQL 