Using database.table in queries

In Hive, table references using dot notation require backticks around the database and table names.

Hive rejects `db.table` in SQL queries. The dot (.) is not allowed in table names. To reference the database and table in a Hive table name, enclosed both in backticks as follows: `db`.`table` .

Impala table references do not require backticks.

Create a table using dot notation to refer to the database and table.

Hive example:

CREATE TABLE `math`.`students` (name VARCHAR(64), age INT, gpa DECIMAL(3,2));

Impala example:

CREATE TABLE math.students (name VARCHAR(64), age INT, gpa DECIMAL(3,2));