The Data Studio

Hive: Over-permissive Naming

This is a more subtle gotcha but important. In Hive 0.13 and later, column names can contain any Unicode character. This is a very bad idea.

On my projects the rule is that all table and column names must use only alphabetic characters, numeric digits and underscores. Nothing else!

For the user interface we want a rich experience; for table and column names in a database we should be "on rails".