The CONCAT() function joins the input strings or different column values and returns as a single string. However, if we need to concatenate rows of
Category: Apache Impala
Get Character Length in Apache Impala
Apart from the LENGTH() function, CHAR_LENGTH function can also be used to get the length of a string. Both leading and trailing spaces at the
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
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 