Hive naming limits

[#1]

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.

[#2 · Accepted solution]

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.s...

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

[#3]

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

[#4]

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.