Aastha Agrrawal

Implement CoralRelNodeToCoralSqlNodeTransformer for lateral views

3

Adding a transformer class to convert the intermediate Coral RelNode representation to Coral SqlNode representation for lateral views. Ideally, this transformer should be in the coral-common module. However, the transformer...

Currently during hive -> spark/trino Sql translations, coral creates a relNode plan. The tableScan relNode has a representation: LogicalTableScan(table=[[hive, dbName, tableName]]). When this relNode is translated to a SqlNode, "hive"...

Append 2 AS operators in SqlNode representation for LATERAL VIEWS

1

For RelNode -> SqlNode translations for SQLs with LATERAL VIEW UNNEST(..), Coral only appends one (inner) AS operator. The output SqlNode generated looks like - `SELECT t0.ccol .... LATERAL VIEW...

For a given Hive SQL with Lateral View, the RelNode representation generated has LogicalCorrelate / LogicalJoin depending on input SQL's syntax. For Input hive SQL - `SELECT col FROM (SELECT...

This Pr implements an enhancement in the CI GitHub Action by enabling Release Publishing for `li-trino-hotfix` Branch ### What changes are proposed in this pull request, and why are they...

### What changes are proposed in this pull request, and why are they necessary? During translations, Coral generates SQL where each table name is appended with an alias and this...

PR https://github.com/linkedin/coral/pull/409 enabled the conversion of single union type hive field schema, such as `uniontype`, to `array` in Coral's SqlNode & RelNode representation. However, it breaks `extract_union` contract of returning...

Some valid input trino SQLs like: 1. `select * from unnest(array[1, 2, 3])` 2. `select x from unnest(array[1, 2, 3]) t(x)` 3. `select * from unnest(array[1, 2, 3]) with ordinality`...

Currently, Coral supports unnesting an operand into a single row type. Ex: For a table `default.struct` defined as - `default.struct(a int, b array` input query: `SELECT * from default.struct cross...

Update the CoralRelNode -> Trino SQL translation path to use `CoralRelToSqlNodeConverter`. Added `CoralSqlNodeToTrinoSqlNodeConverter` to enable conversion from CoralSqlNode to TrinoSqlNode. Testing: (1) Updated / Added tests in HiveToTrinoConverterTest to validate...