Hi Calcite Dev,

What is the recommended way to analyze SQL queries with default
catalog/database names?

For example, for query like "SELECT * FROM foo" where foo maps to a table
in hive.my_database.

In Project Coral
<https://github.com/linkedin/coral/blob/master/coral-hive/src/main/java/com/linkedin/coral/hive/hive2rel/parsetree/ParseTreeBuilder.java#L579>,
the code tries to add catalog/database names right after the parsing stage,
but that would not work for cases like "WITH foo AS (SELECT * FROM mytable)
SELECT * from foo" in which case there is no need to prepend.

-- 
Zheng

Reply via email to