SQL Query Set Analyzer

2018-07-25 Thread Zheng Shao
Hi, We are thinking about starting a project to analyze huge number of SQL queries (think millions) to identify common patterns: * Common sub queries * Common filtering conditions (columns) for a table * Common join keys for table pairs Are there any existing projects on that direction using Calc

Analyzing SQL queries with default catalog/database names

2021-08-16 Thread Zheng Shao
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