search

OHDSI / ARTEMIS

Apache License 2.0
0 stars 1 forks source link

writeOutputs error #2

Open dimshitc opened 4 months ago

dimshitc commented 4 months ago

writeOutputs(output_all, output_processed= processedAll, processedEras = processedEras, connectionDetails = connectionDetails, cdmSchema = cdmSchema, regGroups = regGroups, regStats = regStats, stringDF = stringDF, con_df = con_df)

then when running it on redshift database, it says:

i Generating cohort level stats... Connecting using Redshift driver Using Category, Gender as id variables Error in collect(): ! Failed to collect lazy table. Caused by error in value[[3L]](): ! com.amazon.redshift.util.RedshiftException: ERROR: syntax error at or near "," Position: 37 Run rlang::last_trace() to see where the error occurred.

laurencelawrencearcher commented 4 months ago

Thanks for this, I'll look into it and get access to a redshift server for testing.

In the meantime, I've added an option to skip generating these additional summary statistics in the writeOutputs function, skipSummaryStats.