question Re: Is there any way to cast string to map? in Support Questions

Is there any way to cast string to map?

HareshAmin — Fri, 19 Nov 2021 10:30:04 GMT

Is there any way to cast string to map in Impala?

e.g:

select cast("A:1,B:1,C:1") as map<string, int>

Re: Is there any way to cast string to map?

mszurap — Mon, 22 Nov 2021 15:06:38 GMT

Hi, the complex MAP data type is supported, however it may not be as usable as other simple types. Please see:
https://docs.cloudera.com/runtime/7.2.10/impala-sql-reference/topics/impala-map.html

and

https://docs.cloudera.com/runtime/7.2.10/impala-sql-reference/topics/impala-complex-types.html#complex_types/complex_sample_schema

There is a similar "GET_JSON_OBJECT" built-in UDF, which may help you - depending what you need to achieve, please see:

https://docs.cloudera.com/runtime/7.2.10/impala-sql-reference/topics/impala-misc-functions.html#misc_functions__get_json_object

Re: Is there any way to cast string to map?

VidyaSargur — Wed, 01 Dec 2021 06:28:30 GMT

@HareshAmin, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.