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
Category: Cloudera Impala
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
Get IP Address of Hadoop & Hive
This article will show you how to get the IP address of a Hadoop server or a Hadoop NameNode. If you are using Cloudera Quickstart
Big Data & SQL 