search

OHDSI / WebAPI

OHDSI WebAPI contains all OHDSI services that can be called from OHDSI applications
Apache License 2.0
128 stars 166 forks source link

Achilles DDL not working on Databricks Spark #2256

Closed TomWhite-MedStar closed 12 months ago

TomWhite-MedStar commented 1 year ago

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.
konstjar commented 12 months ago

Closing since the issue was addressed in https://github.com/OHDSI/WebAPI/pull/2269 and merged.