Finding the length of a string – Apache Hive & Apache Impala

Apache Hive, Apache Impala, Cloudera Impala 4 comments

The LENGTH() function returns the length of a string. Both leading and trailing spaces at the begin and end of the string is included when calculating the length. 

  • Note: The below specified function is common in both Apache Hive & Apache Impala.

Syntax: LENGTH(String)
This accepts both characters and numbers in the input but returns INT value.

Examples:
length function in hive

4 comments

  1. Pingback: Apache Hive Functions – Big Data and SQL
  2. Pingback: Apache Hive Course Contents – Big Data and SQL
  3. Pingback: Apache Impala Built-in Functions – Big Data and SQL
  4. Pingback: Apache Impala – Step by Step – Big Data and SQL

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s