Query gz compressed JSON files with Apache Drill

[Paul Pearcy]

Hello,
  New to drill, so hopefully am not missing something obvious. I have
Apache Drill querying uncompressed JSON files with no problem, but am
struggling with gz compressed JSON archives.

My understanding is that Drill uses the Hadoop file connector which I
believed had the ability to handle gz files, but it seems that that
Drill's JSON querying capabilities are always locked to .json files.
I've tried doing something like this:

"formats": {
  "gz": {
    "type": "json"
  }
}

However, receive a file not found error. Also tried this:

"formats": {
  "json": {
    "type": "json",
    "extensions": [
       "gz"
     ]
  }
}

Which results in an "invalid JSON mapping" error.

Thanks!
Paul

This email and any attachments may contain confidential and proprietary 
information of Blackboard that is for the sole use of the intended recipient. 
If you are not the intended recipient, disclosure, copying, re-distribution or 
other use of any of this information is strictly prohibited. Please immediately 
notify the sender and delete this transmission if you received this email in 
error.