Skip to content

Cohort Pathways fails on Impala #1271

Description

@konstjar

Odysseus instance, analysis 143
Error:

org.ohdsi.webapi.exception.AtlasException: java.lang.RuntimeException: java.util.concurrent.ExecutionException: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [update synpuf_53_test_results.i1f0t2a2collapsed_dates_events set cohort_end_date = DATE_ADD(CASE TYPEOF(cohort_end_date ) WHEN 'TIMESTAMP' THEN CAST(cohort_end_date  AS TIMESTAMP) ELSE TO_UTC_TIMESTAMP(CONCAT_WS('-', SUBSTR(CAST(cohort_end_date  AS STRING), 1, 4), SUBSTR(CAST(cohort_end_date  AS STRING), 5, 2), SUBSTR(CAST(cohort_end_date  AS STRING), 7, 2)), 'UTC') END, 1) where cohort_start_date = cohort_end_date]; SQL state [HY000]; error code [500051]; [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Impala does not support modifying a non-Kudu table: synpuf_53_test_results.i1f0t2a2collapsed_dates_events
), Query: update synpuf_53_test_results.i1f0t2a2collapsed_dates_events set cohort_end_date = DATE_ADD(CASE TYPEOF(cohort_end_date ) WHEN 'TIMESTAMP' THEN CAST(cohort_end_date  AS TIMESTAMP) ELSE TO_UTC_TIMESTAMP(CONCAT_WS('-', SUBSTR(CAST(cohort_end_date  AS STRING), 1, 4), SUBSTR(CAST(cohort_end_date  AS STRING), 5, 2), SUBSTR(CAST(cohort_end_date  AS STRING), 7, 2)), 'UTC') END, 1) where cohort_start_date = cohort_end_date.; nested exception is java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Impala does not support modifying a non-Kudu table: synpuf_53_test_results.i1f0t2a2collapsed_dates_events
), Query: update synpuf_53_test_results.i1f0t2a2collapsed_dates_events set cohort_end_date = DATE_ADD(CASE TYPEOF(cohort_end_date ) WHEN 'TIMESTAMP' THEN CAST(cohort_end_date  AS TIMESTAMP) ELSE TO_UTC_TIMESTAMP(CONCAT_WS('-', SUBSTR(CAST(cohort_end_date  AS STRING), 1, 4), SUBSTR(CAST(cohort_end_date  AS STRING), 5, 2), SUBSTR(CAST(cohort_end_date  AS STRING), 7, 2)), 'UTC') END, 1) where cohort_start_date = cohort_end_date.
	at org.ohdsi.webapi.common.generation.TransactionalTasklet.execute(TransactionalTasklet.java:42)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)
	at org.sp

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions