Modify prevalenceWithCriteria.sql to use temp tables for MPP compatibility

OHDSI / SkeletonCohortCharacterization

Apache License 2.0

2 stars 3 forks source link

Modify prevalenceWithCriteria.sql to use temp tables for MPP compatibility #12

Closed anthonysena closed 5 years ago

anthonysena commented 5 years ago

This PR aims to fix a problem detailed in OHDSI/WebAPI#1199 whereby custom prevalence features were failing on PDW. The approach is to use temp tables for the inserts since using CTE expressions with INSERT statements is not currently supported on PDW.