Ask Your Question
1

Error while running pipeline with run time parameters

asked 2018-09-23 22:52:28 -0500

jay1988 gravatar image

I have a run time parameter defined in pipeline as $query.I want to pass runtime parameter to this query using a cmd command.The run time query is like select * from table a where date > ‘2018-01-01’ and date <=‘2018-01-31’.But when we pass this query as run time parameters And run using the functionality of run the pipeline with parameters the quotes infront of date is not getting recognized and query is changing as select * from table a where date > 2018-01-01 and date <=2018-01-31.Our source is oracle and it is causing to fail.

edit retag flag offensive close merge delete

Comments

Any help on this problem is appreciated

jay1988 gravatar imagejay1988 ( 2018-09-24 14:19:14 -0500 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-24 15:49:00 -0500

iamontheinet gravatar image

Hi!

This works for me:

image description

Where QUERY is defined as pipeline parameter.

image description

image description

Also note that starting the pipeline using curl with the same param works as well:

curl -u admin:admin -X POST http://192.168.142.213:18630/rest/v1/pipeline/MySQLf8e2a23-f672-4dba-a107-aad3856e841f/start -H "X-Requested-By:sdc" -H "Content-Type: application/json" -d "{\"QUERY\": \"select * from orders where order_date between '2013-07-25' and '2013-07-26' order by order_date\"}"

Cheers, Dash

edit flag offensive delete link more

Comments

1

Thanks.The solution worked for us.

jay1988 gravatar imagejay1988 ( 2018-09-24 19:31:13 -0500 )edit

Great and you're welcome!

iamontheinet gravatar imageiamontheinet ( 2018-09-25 13:03:09 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-23 22:52:28 -0500

Seen: 73 times

Last updated: Sep 24