Latest Activity
Hi, I'm super new to VQL stored procedure. I'd like to convert the following selct statement to a VQL stored procedure. But I run into issues. I'm wondering what's the correct syntax for the store procedure, please? Here is the select statement: SELE...
Hi there, I'm trying to convert a field of data type 'text' to 'integer' in denodo. The below is my sample operation. select column1, column2, column3 from bv_sample order by cast(field1 as integer) ; I get the below error: "Error converting data t...
I want to stripe-off special character when i query the column. is there a special funtion to do this. e.g. i have characters like ~ @ in the data. so if have value@like, i want to select valuelike. if i have panda~, i want to select panda.
I am not getting desired results from below query group_concat(distinct product_type) e.g. if i have product_type cat, dog, cat Need to get cat,dog
I need to execute output of a query, what is the best approach. e.g. select x into var from <table>, which returns VQL statement/s, then i need to run these VQL statements through a command. e.g. execute @var