Hello,
I have a bunch of .gz that contain JSON that I am testing on a local on local
filesystem. If I rename them to json.gz, they are recognized.
How can I configure drill to treat to treat them as compressed JSON?
I've tried adding a "format" to my storage config that looks like this:
"gz": {
"type": "json"
}
But no luck:
0: jdbc:drill:zk=local> select distinct(schema) from
dfs.`/drill/data/rawgz/activity/`;
Jan 23, 2015 8:49:58 PM org.eigenbase.sql.validate.SqlValidatorException <init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table
'dfs./drill/data/rawgz/activity/' not found
Jan 23, 2015 8:49:58 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column 30 to
line 1, column 32: Table 'dfs./drill/data/rawgz/activity/' not found
Query failed: SqlValidatorException: Table 'dfs./drill/data/rawgz/activity/'
not found
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.
