Error while running Memsql pipeline with transform using python script

Help
1

ERROR 1953 (HY000): Leaf Error (127.0.0.1:3306): Leaf Error (memsql-leaf-0:3306): Transform for pipeline pl_test exited with nonzero exit code. Stderr:
2020-02-21 18:03:01.137 ERROR: Subprocess /usr/memsql_datadir/data/./transforms/814fa4bfd6991eee4dc30c8306082132de3135a7/1021d1a76dcc7f433b6be8dbd7db40c6d0b13320/a6a3d42346e9edd9327d72b61d718ab2f9544d80/3509f1fd8a4b9ebc9400781f58c1877f85dd1507_transform exited with failure result (13 : Permission denied)

CREATE PIPELINE my_pipeline
AS LOAD DATA FS ‘/home/asahoo/transform/csv/*’
WITH TRANSFORM(‘file://localhost/home/asahoo/transform/transform_test.py’,’’,’’)
INTO TABLE emp
FIELDS TERMINATED BY ’ ';

2

Hi asahoo

Please ensure that your Python file has execute permission transform_test.py

Also you may want to go over this doc link as well SingleStoreDB Cloud · SingleStore Documentation

Let us know how it goes.

Thanks,