John Omernik wrote:
Is there an easy way in drill to convert from an ARRAY or MAP to a string
representation of the same? I know this is an odd question, but I realized
I just was spinning my wheels because I thought I was doing something wrong
with JSON and KVGEN and FLATTEN but in reality, it
That seems to be what I am looking for, however, when I do
convert_from(flatten(kvgen(allias.`column`)), 'json') I get an error
"Missing function implementation (convert_fromjson, "map required") when I
do "convert_to(flatten(kvgen()), 'json') then I get what appears to be hex
encoded data...
Is there an easy way in drill to convert from an ARRAY or MAP to a string
representation of the same? I know this is an odd question, but I realized
I just was spinning my wheels because I thought I was doing something wrong
with JSON and KVGEN and FLATTEN but in reality, it was working fine, I
We don't implement casts on array or map, but we do have a convert function
that will convert a complex structure to json.
You can invoke it like this: convert_from( map_or_list_column_name,
'JSON')
This will return the data serialized into JSON in a varchar column.
On Mon, Oct 12, 2015 at
Yes Daniel - 2002 is Struct and 2003 is Array (I'm seeing both)
This is not a Drill problem but a squierrel problem, and an annoying one at
that, I've tried using the option to display unknown data types as strings,
now I just rather than the "Error Unknown Type (2003 or 2002)"
On Mon, Oct