str_to_map returns map<string,string>. How to make it return map<string,int>?

Question

I am using str_to_map as:-

hive> select str_to_map("A:1,B:1,C:1");
OK
{"C":"1","A":"1","B":"1"}

As you can notice it is returning object of type map < string,string>. I want object of type map. Is there any way out? Can we typecast it in some way to map< string,int>?

MichaelChirico · Accepted Answer · 2019-03-01 02:26:31Z

2

I stared at this and looked around for a while and didn't see much, but turns out it's quite simple -- just use cast:

select cast(str_to_map("A:1,B:1,C:1") as map<string, int>)
-- {'A': 1, 'B': 1, 'C': 1}

answered Mar 1, 2019 at 2:26

MichaelChirico

34.9k17 gold badges122 silver badges209 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dhiraj Over a year ago

fails with syntax error:- FAILED: ParseException line 1:41 cannot recognize input near 'map' '<' 'string' in primitive type specification

MichaelChirico Over a year ago

Hmm it's working perfectly well for me in Spark SQL which I had assumed is equivalent to HiveQL...

Dhiraj Over a year ago

looks like it's not that similar, there might be subtle differences

xqliang · Accepted Answer · 2020-12-10 13:30:05Z

0

You can try to use map_remove_keys UDF:

> add jar hdfs:///lib/brickhouse-0.7.1-SNAPSHOT.jar;
> create temporary function map_remove_keys as 'brickhouse.udf.collect.MapRemoveKeysUDF';
> select map_remove_keys(map("", 0), array(""));
+------+
| _c0  |
+------+
| {}   |
+------+

answered Dec 10, 2020 at 13:30

xqliang

3973 silver badges4 bronze badges

Collectives™ on Stack Overflow

str_to_map returns map<string,string>. How to make it return map<string,int>?

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related