Hi all,

I want to calculate n√X (n root of X) in Teiid query.

S= n√X Where n= 1.89 & x is any input value

Looking at internet article I wrote below query Nth root of a number

SELECT POWER(Convert(27,bigdecimal),Convert(1/1.89,bigdecimal))

SELECT POWER(27,1/1.89)

for both of the queries I am getting same error. Any thoughts how we can execute above formula ?