OHDSI Home | Forums | Wiki | Github

Achilles doesn't create/populate concept_hierarchy

(Chris Wallace) #1

When I run Achilles it doesn’t create the concept_hierarchy table. I’m sure I’m using the most recent version of Achilles, but it won’t create or populate this table (I ran the ddl manually), and if I try to include the ‘conceptHierarchy = TRUE’ parameter when running Achilles it just gives me an error that the parameter doesn’t exist.

(Chris Knoll) #2

I think that parameter is out of date, since the concept hierarchy table is not really used in Achilles, so it was moved to WebAPI where the reporting is performed.

You can translate this script into your dialect to create the table. Note, this script depends on indexes that will allow searching vocabulary tables faster.