Hi Team, Can someone help me with this?
On Tue, 13 Aug 2019 01:11 Anup Tiwari, <anupsdtiw...@gmail.com> wrote: > Hi All, > > I have a use case where i wanted to store multiple columns into a single > map data type column but while doing so i came across a use case where i > have mainly 2 type of column bigint and string so i stored them in a map > column defined as <string,string> and then i queried the key which hold > integer values in a map column. > > Case 1 :- when i am applying > , < conditional operator then returning > output is correct. > Case 2 :- Taking min/max on integer column and then it is giving me > incorrect output. > > Now i understood that it is due datatype of map column which is "string" > but just a question, why min/max is working on string and <,> conditions > failing ? > > Please note that the column which i am querying, will always contain int > value so let me know if you have any suggestions. > > Combining and storing value in map datatype is necessary because each row > can have different-different number of metadata depending upon event name. > > Please find table structure below :- > > CREATE TABLE `anup.test_map`( > `SID` string, > `eventName` string, > `timestamp` timestamp, > `merge` map<string,string>) > STORED AS PARQUET; > > Regards, > Anup Tiwari >
