Thursday 11 September 2014

Escape Reserved Words in Hive Fields

Below reserved words can't be used as field names in Hive table.

id, date, datetime, timestamp range, location, key, etc.

To escape these reserved works, use `words`


Otherwise, you will see errors:
FAILED: Parse Error: line 1:0 mismatched input ''location'' expecting Identifier near ',' in column specification

No comments:

Post a Comment