Repository navigation
Table aliases not supported? #28
Description
Are table aliases like a in FROM some_table a supported?
For example
> demoAllAnalyses "select a.x from some_table a"
Tables accessed:
public.some_table
Columns accessed by clause:
<unknown>.a.x SELECT
Joins:
no joins
Table lineage:
no tables modified
In this case, is it possible to resolve <unknown> to some_table?
Activity
h4v0kh3l1 commentedon Mar 13, 2018
Hey @tuulos ,
Yes, we intend to support resolving aliases in column access, we have table alias resolution but it looks like this particular case slipped under the radar.
This example provided will have different behavior, since
some_tabledoesn't exist in the catalog, and the resolve step reverts to defaulting. However, if you swap infoo, which is defined in the demo catalog, you'll get the same behavior.