ExposuresProvider / icees-api

MIT License
2 stars 8 forks source link

Can not run feature_association2 endpoint #174

Open Sharma05 opened 3 years ago

Sharma05 commented 3 years ago

Got the error below while @xu-hao and I were running query (below) to debug why icees api at port 16399 was still giving us incorrect count using feature_association2.

curl -XPOST https://icees.renci.org:16339/patient/cohort/COHORT:65/feature_association2 -d '{"feature_a": {"feature_name": "MEDIANHOUSEHOLDINCOME_cut", "feature_qualifiers": [{"operator": "=", "value": 1}, {"operator": "=", "value": 2}, {"operator": "=", "value": 3}, {"operator": "=", "value": 4}], "year": 2010}, "feature_b": {"feature_name": "RoadwayDistanceExposure2", "feature_qualifiers": [{"operator": "=", "value": 1}, {"operator": "=", "value": 2}, {"operator": "=", "value": 3}, {"operator": "=", "value": 4}, {"operator": "=", "value": 5}, {"operator": "=", "value": 6}], "year": 2010}}' -H "Content-Type: application/json"


table tmp already exists\n[SQL: CREATE VIEW tmp AS SELECT * FROM patient WHERE \"RESPONDER_STATUS\" = Neither AND \"PM25_ANNUAL_AVERAGE_cut\" = 4]\n(Background on this error at: https://sqlalche.me/e/14/e3q8)"}%