Re: Not able to update storages

2015-10-27 Thread Kristine Hahn
I don't know what you mean by "using screen". You cannot use the wildcard asterisk in the query afaik. You can query a directory of files, but I believe the files need to meet the conditions mentioned in http://drill.apache.org/docs/querying-directories/. I could not query a GZ file unless I used

Re: Not able to update storages

2015-10-27 Thread Tomer Shiran
On Tue, Oct 27, 2015 at 1:55 AM, Assaf Lowenstein wrote: > Hi, > > I'm trying to setup a drill server, running in embedded mode, so users will > be able to access a centralized location and I need assistance/confirmation > on the following: > >1. As it's a server, I need

Re: Not able to update storages

2015-10-27 Thread Kristine Hahn
> > You'll want the extension of the file to be .json.gz. You can > place multiple .json.gz files in a directory, and then query that directory > SELECT * FROM dfs.`/mnt/drill-work/XXX/XXX/` Renaming the file to .json.gz will work with the default dfs storage plugin, but you don't have to change

Re: Not able to update storages

2015-10-27 Thread Andries Engelbrecht
Assaf, If you want to use Drill as a Server vs Embedded mode, you may be better off to install ZK (Zookeeper) on the node (assuming you run Linux) and then just run Drill as a single node cluster/distributed mode. Opens up your options to scale to multiple nodes easily in the future as well.