Hi, I am processing json data files in Apache Drill. Earlier the format of files were
{ "field2": [ "296dOmWrTK-dunFoei2gQg" ], "field3": { "name": "SE_21", "count": 0 }, "field1_old": "Qsa87PoaTgCIEab0z8VmgQ", "timestamp": 1514105922659 } Later the files format changes to { "field1_renamed": "OiJ4FeiMEeexdAaIPcVKTA", "filed2": [ "kwj5GD3EQYa1joxIWrPWEw" ], "filed3": { "name": "SE_16", "count": 0 }, "timestamp": 1515545336591 The only change in the files data is field1_old and field1_renamed I know I can process the files in two queries and name field 1_old and field _renamed as field1 I am looking for better ideas to process these files in one query . Thanks, Divya