Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive naming limits

avatar
Expert Contributor

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.

1 ACCEPTED SOLUTION

avatar
Super Guru
3 REPLIES 3

avatar
Super Guru

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

avatar
Expert Contributor

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.