search

ohdsi-studies / PioneerWatchfulWaiting

This study is part of the joint PIONEER - EHDEN - OHDSI studyathon in March 2021, and aims to advance understanding of clinical management and outcomes of watchful waiting in prostate cancer.
Apache License 2.0
7 stars 18 forks source link

Maximum number of expressions in a list is 1000 tips (java.sql.SQLSyntaxErrorException: ORA-01795) #11

Closed scossin closed 3 years ago

scossin commented 3 years ago

45/58: Instantiation cohort Mutations (320.sql)

INSERT INTO OMOP_TEMP.na5vj98tCodesets (codeset_id, concept_id)
SELECT 0 as codeset_id, c.concept_id FROM (SELECT distinct I.concept_id FROM (SELECT concept_id FROM OMOP.CONCEPT   WHERE concept_id in (35960740,36726633,36726634,....

Too many concept_id given

scossin commented 3 years ago

I'm trying this: https://github.com/scossin/PioneerWatchfulWaiting/commit/9132bc98efa54a3e4763eb37340d051cf640ce97