Correcting `db.table` in Queries
For ANSI SQL compliance, Hive 3.x rejects `db.table` in SQL queries. A dot (.) is not allowed in table names.
You need to change queries that use such `db.table` references to prevent Hive from interpreting the entire db.table string as the table name. You enclose the database name and the table name in backticks.