我已经使用redshift traslator在teiid中配置了一个红移数据源。但是,在使用teiid时,redshift中的一些SQL函数不支持。例如,我在部署VDB时遇到了fallowing错误
TEIID30068 The function 'nvl2(v_skey, c_skey, s_key)' is an unknown form. Check that the function name and number of arguments is correct.
11/29/2017 12:13:01 PM[Server:server-one] 06:43:01,886 WARN [org.teiid.RUNTIME] (Worker25_async-teiid-threads41) TEIID40073 The metadata for the VDB ReportRedshift.1 is loaded, however it is not valid. Check models for errors to correct the metadata and re-deploy: ReportRedshift其他一些Redshift SQL结构,如'ISNULL‘也不起作用
https://stackoverflow.com/questions/47548590
复制相似问题