Denodo equivalent of collect_set, named_struct in Hive
I have a query which is in Hive as follows
Select
acc,
collect_set(named_struct ( ‘acc’, acc,
‘name’, name,
‘age’, age))
group by acc
Denodo VQL TO_DATE function returning ORA-1830
I am having trouble figuring out the date string format convention for the Denodo VQL TO_DATE function. For the following query: