question Re: Hive naming limits in Archives of Support Questions (Read Only)

Hive naming limits

ebeb — Fri, 16 Sep 2022 13:44:05 GMT

Hello, anyone know the max table name and column name limits in Hive and Impala? I could not find any Hive database limits specifications which is found in most other databases. Thanks.

Re: Hive naming limits

EricL — Thu, 20 Sep 2018 22:46:51 GMT

If you look at the latest Hive code,

Table name is 256 characters:
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/hive-schema-2.3.0.mysql.sql#L586

And column name is 767 characters:
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/hive-schema-2.3.0.mysql.sql#L55

Re: Hive naming limits

ebeb — Thu, 20 Sep 2018 23:05:55 GMT

Great! Thanks so much, would be good if Hive community documented the Database limits which most major databases have in the manuals.

Re: Hive naming limits

ebeb — Wed, 06 Apr 2022 20:04:13 GMT

Found some new info in latest Cloudera CDP guides for Impala. It would be nice if they made Hive and Impala more similar for SQL standard syntax but unfortunately it is not same:

https://docs.cloudera.com/runtime/7.2.14/impala-sql-reference/topics/impala-identifiers.html

Impala identifiers

Provides information about using Identifiers as the names of databases, tables, or columns when creating the objects.

The following rules apply to identifiers in Impala:

The minimum length of an identifier is 1 character.
The maximum length of an identifier is currently 128 characters, enforced by the Metastore database.