Created a simple script
CREATE OR REPLACE PYTHON SCALAR SCRIPT fruits_list(fruit varchar(20000) , price decimal(18,2))
RETURNS VARCHAR(200000) AS
Its giving error
SQL Error : VM error: SyntaxError: invalid syntax (FRUITS_LIST, line 1) (Session: 1672016243267889055)
Solved! Go to Solution.
Good to see you were able to sort this out - and thank you for this contribution!
Even though the issue you mentioned is something Python-specific (and we don't aim to teach Python in the first place), we actually pointed out this sensitivity in the very first video clip that talks about UDF scripts (UDF scripts in Exasol), saying:
"As it is Python, it is very important to indent the lines of code within the function."