Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created 11-19-2021 02:30 AM
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>
Created 11-22-2021 07:06 AM
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
There is a similar "GET_JSON_OBJECT" built-in UDF, which may help you - depending what you need to achieve, please see:
Created 11-22-2021 07:06 AM
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
There is a similar "GET_JSON_OBJECT" built-in UDF, which may help you - depending what you need to achieve, please see:
Created 11-30-2021 10:28 PM
@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.
Regards,
Vidya Sargur,