OHDSI Achilles 설치시 where 구문오류나는 경우

OHDSI Achilles 설치시 where 구문오류나는 경우 

PostgreSQL 사용중 where 오류입니다. 

조치방법 : 

R을 실행하고 아래 명령어를 실행합니다. 

>library(devtools)

>install_github("ohdsi/Achilles", repos="http://cran.rstudio.com/", ref="v1.5.0")

DBMS:

postgresql

Error:

org.postgresql.util.PSQLException: 오류: 구문 오류, "where" 부근

  Position: 461

SQL:

insert into results.ACHILLES_results_derived (statistic_value,stratum_1,measure_id)

select

  CAST(100.0*st.val/statistic_value AS NUMERIC) as statistic_value,

  CAST('Procedure' AS VARCHAR(255)) as stratum_1, CAST(  'UnmappedData:byDomain:Percentage' AS VARCHAR(255)) as measure_id

from results.achilles_results_derived

join (select statistic_value as val from results.achilles_results_derived where measure_id = 'UnmappedData:ach_601:GlobalRowCnt') as st

where measure_id ='ach_601:GlobalRowCnt'

R version:

R version 3.4.4 (2018-03-15)

Platform:

x86_64-redhat-linux-gnu

Attached base packages:

- stats

- graphics

- grDevices

- utils

- datasets

- methods

- base

Other attached packages:

- Achilles (1.5)

- rjson (0.2.18)

- DatabaseConnector (2.1.0)

- SqlRender (1.4.10)

- devtools (1.13.5)