mysql의 경우 reserved word를 table의 컬럼명으로 쓰인다면 back quote(`)을 사용해야 한다.
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
The identifier quote character is the backtick (`
):
mysql> SELECT * FROM `select` WHERE `select`.id > 100;
마찬가지로 hive에서도 reserved word를 table의 컬럼명으로 쓰인다면 back quote(`)을 사용해야 한다.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select
Any column name that is specified within backticks (`
) is treated literally.
hive> select * from googleplus_log where `date`='2037-08-23' and label='birthday' and `to`='11935385';