Skip to content

Achilles DDL not working on Databricks Spark #2256

@TomWhite-MedStar

Description

@TomWhite-MedStar

Expected behavior

The DDL generated by the Achilles DDL WebAPI for spark should run properly.

Actual behavior

The generated DDL includes two WITH clauses within the same SQL statement, which throws an error.

Steps to reproduce behavior

  1. Generate DDL for spark from Achilles DDL WebAPI. - attached:
    achilles_ddl-spark.sql.txt
  2. The error is on line 99, which reads WITH insertion_temp AS (
  3. If that line is changed to , insertion_temp AS (, the query runs properly.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions