Re: How to specify Drill JDBC connection timeout or JDBC Query timeout

You should fill a JIRA asking for this to be implemented. At least this will be visible to the developers. Thanks On Fri, Jun 3, 2016 at 1:01 PM, Hao Zhu wrote: > Thanks Hakim. > Seems the test framework is using JAVA Thread level timeout. > Is there any chance we implement

Settings in Drill that could affect other users.

As I was thinking about Drill last night, I put on my information security hat and realized there may be some settings we need a bit more control around. I haven't tested this yet, I am trying to figure out ways to do this, however, my theory was this: There are some variables that could

Re: CTAS on MySQL*

MySQL storage plugin is indeed read only, you cannot create a table on mysql through Drill. Thanks On Fri, Jun 3, 2016 at 10:05 AM, Shankar Mane wrote: > As we know, we can able to read MySQL data using drill mysql storage > plugin. But it seems it is Read Only and

Re: Query execution in Drill

On Fri, Jun 3, 2016 at 7:41 AM, Sebastian Hamann wrote: > Hi, > Iam currently trying to write a shell script to automatically setup drill > (embedded for now) and execute queries on it. > 1. Is there an option to execute SQL from command line or file, like in > Hive? > (I mean

Re: Query execution in Drill

Try this and see if it works for you: https://community.mapr.com/docs/DOC-1570 On Friday, June 3, 2016, Sebastian Hamann wrote: > Hi, > Iam currently trying to write a shell script to automatically setup drill > (embedded for now) and execute queries on it. > 1. Is there an

Re: Query execution in Drill

You can pass the -e or -q options to drill-embedded. Does the following work? [root@ip-172-16-2-147 apache-drill-1.6.0]# bin/*drill-embedded -e 'select count(*) from (values(1));'* Jun 03, 2016 10:46:32 AM org.glassfish.jersey.server.ApplicationHandler initialize INFO: Initiating Jersey

Query execution in Drill

Hi, Iam currently trying to write a shell script to automatically setup drill (embedded for now) and execute queries on it. 1. Is there an option to execute SQL from command line or file, like in Hive? (I mean the hive -e 'sql statement' or hive -f ) 2. If not: What is a good way to simulate