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