I came across one issue.
Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am passing through GET request when i am calling REST API.
Consider that the below given is my SQL query.
Select name,mobile from TestTable where uname IN ('test1', 'test2', 'test3').
Now here i am given the values ('test1', 'test2' ,'test3') at the time of view creation. it works fine.
But I want that to be parameterised so i will pass value through querystring in GET request.
So i have made my SQL query as:
Select name,mobile from TestTable where uname IN ('@username').
When i am executing above query to create view it gives me error.
So i want to know that how can declare array of string as variable in SQL query for creating Denodo view so that it work perfect.
Eventhhough I remove quotes from the @username, it gives me error as it consider values as a attribute.
So please help me with this issue.