In a previous post, we talked you how to generate and update statistics in Apache Impala. In Apache Hive, you can perform the same thing.Â
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.
SQL-92 and SQL-89 Joins
SQL-92 and SQL-89 joins are supported by most RDBMSs, including Apache Impala. This article will explain how the syntax is written in both ways and
Query: SQL vs Apache Pig
SQL Queries are used to get data from tables by using SELECT statements with suitable filters and sorting. In this post, I’ll attempt to illustrate
Show Files Statement in Impala
This post will show you how to retrieve a list of the files that make up a certain table, or a partition inside a partitioned
Column Statistics in Apache Impala
Along with the “Table Statistics”, the statistics about the table columns used by the Impala query planner. This post will show you how to retrieve
Table Statistics in Apache Impala
Statistics about whole tables and partitions may be used by the Impala query planner. Physical characteristics such as the number of rows, the number of
Big Data & SQL 