Q&A BY TAG 'ARRAY'
How to select distinct elements of an array column in a view
answered
24-02-2021 06:23:52 -0500
I need to select distinct values from few array columns in a view. My view consists few Array columns and I cannot group by them. SELECT * from {view} where {parameter} = '03645' Parameter Column 2 Column 3 Column 4 ...
Answers:
2
Compound data type error
answered
20-08-2020 01:55:38 -0400
I am trying to create an array data type, I tried the following syntax shared in the below link https://community.denodo.com/docs/html/browse/7.0/vdp/vql/defining_other_elements_of_the_catalog/defining_a_data_type/defining_a_data_type#defining-a-data-...
Answers:
3
JSON Data Source Array Issue
answered
17-07-2020 11:25:32 -0400
Hi, I am trying to create a Base View for a JSON based Data Source : [{"a":1, "b":2, "c":3}, {"a":11, "b":22, "c":33}, {"a":111, "b":222, "c":333}, {"a":1111, "b":2222, "c":3333}, {"a":11111, "b":22222, "c":33333}] If I create the view using the defau...
Answers:
2
Denodo alternative for TSQL "STUFF.... FOR XML PATH"
answered
04-10-2019 02:35:33 -0400
Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...
Answers:
2
How to flatten an unknown hierarchy
answered
22-01-2018 12:52:33 -0500
I have a JSON datasource which returns a hierarchy along the lines of the JSON below. The key thing here is that from one web service call to the next the folder structure can differ i.e. each folder is an array and can contain different numbers of sub...
Answers:
1
nest function fails when field contains null as values
answered
21-09-2015 12:34:22 -0400
Hi, I Have a problem while returning an array over a set of fileds where some of them might contain null (This is a valid value) inside a stored procedure In the stored procedure i have the return value as below new StoredProcedureParameter( "ord...
Answers:
1
String Processing to array to last item in 1 swoop
answered
30-06-2015 01:35:20 -0400
I have a data source with multiple columns being a uri. I need to process it to get the last "item". We can simply create one for the sake of this question & try it out using the VQL shell. select split('/', 'http://server:9090/denodo-restfulws/tutori...
Answers:
2