...
Are HiveQL identifiers (e.g. table names, column names, etc) case sensitive?
No. Hive is case insensitive.
Executing:
SELECT * FROM MyTable WHERE myColumn = 3
is strictly equivalent to
select * from mytable where mycolumn = 3
What are the maximum allowed lengths for HiveQL identifiers?
...