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
