Using Apache Hive
Also available as:
PDF

Escape table names in dot notation

The database name and the table name must be enclosed in backticks when using dot notation.

HDP 3.1.4 and later rejects `db.table` in SQL queries. The database name and the table name must be enclosed in backticks as follows: `db`.`table`; otherwise, Hive interprets the entire db.table string as the table name.