You can translate the question and the replies:

Text to decimal with Impala as source in Denodo

Hi, Im currently facing conversion challenge while using Impala as the source for denodo, while converting **text to decimal.** In teradata we are successfully using **to_number** for this conversion , but the same approach doesnt working with impala in denodo, as a result its giving error as :**"Failed to convert string to decimal"** error. could anyone recommend an alternative method for convertiing text to decimal in denodo when the source is impala? Thank you for you assistance

1 Answer

Hi, I understand that you want to convert text to decimal in Denodo for a view with source as impala. You could achieve it in a base view graphically by navigating to the Edit tab and by selecting decimal in the drop down in the Field Type column. Then, click on the pencil icon and select decimal as type. Additionally, you could refer to the [Modifying a Base View](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view#:~:text=To%20modify%20the,1000%27) documentation for modifying via ALTER statement. In a derived view, you could achieve this by using the [CAST](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/conversion_functions/conversion_functions#cast) function. Click on the pencil icon in the Field Name column and there in the field expression, give the expression as below: **Eg: cast(<column_name> as decimal)** If you still require assistance other than the above-provided details, and if you have valid support access, then you could raise a support case where we could assist you more. Hope this helps!
Denodo Team
17-01-2024 05:09:06 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here