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

Reply via email to