You can translate the question and the replies:

I can able to execute the table but unable execute the specific column of the table

I can able to execute the table but unable execute the specific column of the table. error message Finished with error: Field not found 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CHANNEL_ENGAGEMENT_AGG_001.start_date' in view 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CHANNEL_ENGAGEMENT_AGG_001'
user
04-01-2021 03:33:17 -0500

1 Answer

Hi, In general, this error means that you are trying to query a non existent field in your selection. Besides, since you mentioned that the view execution was successful, it could be that you are querying a case sensitive field. Hence, I would suggest you take into account if you are using the **identifier charset Unicode **(case sensitive). For instance, if you have created a view and its field name with charset Unicode, then the name of fields should be surrounded by double quotes (" ") while executing it using select statement. Otherwise you will get an error. You may take a look at the section [Unicode Mode](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/server_configuration/identifiers_charset/identifiers_charset#unicode-mode) for more information. If you still need help and if you are a user with valid support access then you can raise a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team can help you. Hope this helps!
Denodo Team
04-01-2021 05:51:58 -0500
You must sign in to add an answer. If you do not have an account, you can register here