You can translate the question and the replies:

Fetching Column issue in VQL

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwing error "column not found" Finished with error: Field not found 'bv_XXX' in view 'bv_XXX'
04-01-2021 08:38:11 -0500

1 Answer

Hi, I would use the following steps to verify if the column name is present in the view: 1. Right click on the view > execute > this opens up in VQL shell. Here, you can see all the columns of that view. 2. By checking the field names here, you can verify that the field name you are using in your original query is valid. Hope this helps!
Denodo Team
05-01-2021 05:39:50 -0500
You must sign in to add an answer. If you do not have an account, you can register here