Hi,
I have a data format like this: F1 \t F2 \t F3 \t K1=V1 \t K2=V2 \t K3=V3\n
I've tried to create a table using:
CREATE TABLE test ( f1 STRING, f2 STRING, f3 STRING, kv MAP<STRING,
STRING> )
DELIMITED FIELDS TERMINATED BY '\t' MAP KEYS TERMINATED BY '=';
After I load the data into test, f1, f2 and f3 looks good. However, the kv
column only contains {K1:V1}, I was hoping it would contain {K1:V1, K2:V2,
K3:V3}.
I think that's because Hive sees a '\t' char between K1=V1 and K2=V2 (same
situation between K2=V2 and K3=V3) then it treat it as a new Field begin so
kv only stores {K1:V1}. Since the test table doesn't have more columns
after kv, then K2=V2 and K3=V3 is ignored.
Is there any way besides to write a custom SerDe so that I could have the kv
column to store more than one key-value pair? (I could change the file
format)
thanks,
C.H.
