@Dhanya Kumar Heballi Shivamurthy, assuming you have both arrays with the same size (per record): select c1, c21, c31, c4 from ( select 100 c1, split('Delta|Alpha|Beta','\\|') c2, split('Source|Varied|Volume','\\|') c3, 'AppData' c4 ) foo LATERAL VIEW posexplode(c2) n1 as c22, c21 LATERAL VIEW posexplode(c3) n2 as c32, c31 where c22=c32; If array lengths can be different, then you need to add more conditions: select c1, c222 c2, c333 c3, c4 from ( select c1, c22, c32, -- keep indices case when c32 < size(c2) then c21 else null end c222, case when c22 < size(c3) then c31 else null end c333, c4 from ( select 100 c1, split('Delta|Alpha|Beta','\\|') c2, split('Source|Varied|Volume|Owner','\\|') c3, 'AppData' c4 ) foo LATERAL VIEW posexplode(c2) n1 as c22, c21 LATERAL VIEW posexplode(c3) n2 as c32, c31 ) bar where c22=c32 or (c222 is null and c22=0) or (c333 is null and c32=0); Result: +------+--------+---------+----------+--+ | c1 | c2 | c3 | c4 | +------+--------+---------+----------+--+ | 100 | Delta | Source | AppData | | 100 | Alpha | Varied | AppData | | 100 | Beta | Volume | AppData | | 100 | Owner | NULL | AppData | +------+--------+---------+----------+--+ ... View more

@Mushtaq Rizvi, you can define tab delimited table. This will give you already 7 columns, without any regex for them. then, in order to extract particular parts from each product column use "(\d+):([^-\t]+)-(\d+)" as regex (except for the first one, which would be just "(\d+):([^-\t]+)"...) or you can also use split instead of regex. insert overwrite table recommendation SELECT regexp_extract(col_p, '(\d+):', 1) productId, regexp_extract(col_p, ':(.+)', 1) productName, regexp_extract(col_p1, '(\d+):', 1) productId1, regexp_extract(col_p1, ':([^-]+)', 1) productName1, regexp_extract(col_p1, '-(.+)', 1) productCount1, regexp_extract(col_p2, '(\d+):', 1) productId2, regexp_extract(col_p2, ':([^-]+)', 1) productName2, regexp_extract(col_p2, '-(.+)', 1) productCount2, regexp_extract(col_p3, '(\d+):', 1) productId3, regexp_extract(col_p3, ':([^-]+)', 1) productName3, regexp_extract(col_p3, '-(.+)', 1) productCount3, regexp_extract(col_p4, '(\d+):', 1) productId4, regexp_extract(col_p4, ':([^-]+)', 1) productName4, regexp_extract(col_p4, '-(.+)', 1) productCount4, regexp_extract(col_p5, '(\d+):', 1) productId5, regexp_extract(col_p5, ':([^-]+)', 1) productName5, regexp_extract(col_p5, '-(.+)', 1) productCount5, regexp_extract(col_p6, '(\d+):', 1) productId6, regexp_extract(col_p6, ':([^-]+)', 1) productName6, regexp_extract(col_p6, '-(.+)', 1) productCount6 from temp_recommendation; ... View more

@Anusha Akula, Let me start with #2. Number of mappers is defined by number of input splits. Since you have 21 partitions, you have not less than 21 files, which determines the number of mappers you get (actually, you have exactly 21 files: 1 under each partition). Regarding #1. Regex you are using, is a bit complicated... Try to reduce its complexity: SELECT REGEXP_EXTRACT((get_json_object(line, '$.result._raw')),'.*X_Requested_With=(\\w.+?)\\s',1) as X_INF_RequestID FROM tablename; ... View more