select * from ( SELECT * from JSON_TABLE(get_clob_from_file('/smedoc/ute/DEPE/gmaps.json'), '$' COLUMNS( origin_addresses VARCHAR(30) PATH '$.origin_addresses' ) ) as x ) cc cross join table ( SELECT ROW_NUMBER() OVER () rownumber, a.* from JSON_TABLE(get_clob_from_file('/smedoc/ute/DEPE/gmaps.json'), '$.rows.elements' COLUMNS( distance_text VARCHAR(30) PATH '$.distance.text', distance_value VARCHAR(30) PATH '$.distance.value', duration_text VARCHAR(30) PATH '$.duration.text', duration_value VARCHAR(30) PATH '$.duration.value', statust VARCHAR(30) PATH '$.status' ) ) as a ) aa join table ( SELECT ROW_NUMBER() OVER () rownumber, b.* from JSON_TABLE(get_clob_from_file('/smedoc/ute/DEPE/gmaps.json'), '$.destination_addresses' COLUMNS( Destination_addressess VARCHAR(30) PATH '$' ) ) as b ) bb on aa.rownumber=bb.rownumber ;