You can translate the question and the replies:

I use case when function, I got error message below

I am tring to create a new column using: case when MAR_ADDL_INFO.LINE = 1 then MAR_ADDL_INFO.ERX_ID else null end then I got error maessage: com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: The following fields cannot be projected: case(CONDITION((line,=,['1'])), erx_id, NULL) AS field4 thanks
AWS HIVE JDBI Connection URI
user
30-11-2022 11:49:45 -0500
code

1 Answer

Hi, The error “com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: The following fields cannot be projected” usually occurs during the usage of the incorrect syntax of functions. I found a similar case [here](https://community.denodo.com/answers/question/details?questionId=9060g000000TR8nAAG&title=Error+Computing+capabilities) so you may take a look at it. Hope this helps!
Denodo Team
01-12-2022 02:22:12 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here