drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divya Gehlot <divya.htco...@gmail.com>
Subject change in data fields in json file
Date Mon, 15 Jan 2018 09:09:01 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message