S02059

In the query on a DFS table or a table joined by table joiners, this error occurs when a wildcard "*" is used in a table name (e.g. "tableName.*") in the select statement, but that table is not included in the from clause. For example:

t1 = table(`a as id)
t2 = table(`b as id)
t3 = table(`c as id)

dbName = "dfs://test"
if (existsDatabase(dbName)) {
    dropDatabase(dbName)
}
db = database(dbName, VALUE, `a`b)
pt = db.createPartitionedTable(t1, `pt, `id)
pt.append!(t1)

select t3.* from pt
select t3.* from ej(t1, t2, `id) => Cannot recognize table name or alias 't3'.

When using a wildcard in a table name in the select statement, ensure that the corresponding table is also specified in the from clause.

select t3.* from ej(t1, t3, `id)