search

databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse
Other
21 stars 13 forks source link

TSQL: Simplifies named table tableSource, implements columnAlias list #512

Closed jimidle closed 1 month ago

jimidle commented 1 month ago

The ANTLR grammar for tableSource is simplified and rationalized such that named tables are dealt with in only one place.

Additionally, column alias list is correctly parsed and implemented in IR.

Table hints are collected and processed, and a new Relation is created, TableWithHints. Some hints may have direct counterparts in the Catalyst optimizer, some we may use to comment the translated code as an aid to migration.

In general, query optimizations are best left to the plan optimizer, but it is possible that some interventions in TSQL were useful and may also be useful within Databricks SQL.

github-actions[bot] commented 1 month ago

Coverage tests results

394 tests   355 :white_check_mark:  4s :stopwatch:   2 suites    2 :zzz:   2 files     37 :x:

For more details on these failures, see this check.

Results for commit bdd95ae1.

:recycle: This comment has been updated with latest results.