Re: Apache Drill Query Planning Performance

2017-04-26 Thread Jinfeng Ni
Try to increase config `hive.metastore.cache-ttl-seconds`. The default is 60 seconds. I guess the reason you saw long planning time after another query is probably the cache from the first run expired. 1. https://drill.apache.org/docs/hive-metadata-caching/ On Wed, Apr 26, 2017 at 3:47 PM, rahu

Re: Apache Drill Query Planning Performance

2017-04-26 Thread rahul challapalli
If your hive metastore contains a lot of metadata (many databases, tables, columns etc), then drill might spend a significant time in fetching the metadata the first time. It caches the metadata, so subsequent runs should be faster. The fact that other queries are run in-between the first and secon

Apache Drill Query Planning Performance

2017-04-26 Thread Ivan Kovacevic
Dear Sir or Madam, I would like to ask a question regarding query planning, since I am writing a chapter about Apache Drill in my master thesis. My DrillBit is installed within a Cloudera VM, and there is a separate VM with MongoDb installed. At the time of writing, I'm performing analysis on the

ODBC error with v1.3.0.1009 (64-bit)

2017-04-26 Thread Rick Fanta
Hi, Have just installed the MAPR 64-bit driver v1.3.0.1009 on Windows and a Test connection succeeded. However, after launching the Drill Explorer, I get the following message no matter what query is run from drill explorer: ERROR [08S01] [MapR][Drill] (1040) Drill failed to execute the query: S

Re: Quoting queries

2017-04-26 Thread Ted Dunning
David, Did the jdbc driver that Kunal recommended solve your problem? On Wed, Apr 26, 2017 at 12:29 AM, Lane David (ST-ESS/MKP3.2) < david.l...@de.bosch.com> wrote: > Hi all, > > just to bump this, is there anything that can be done here? At the moment > I am reduced to executing queries on th

Last chance: ApacheCon is just three weeks away

2017-04-26 Thread Rich Bowen
ApacheCon is just three weeks away, in Miami, Florida, May 15th - 18th. http://apachecon.com/ There's still time to register and attend. ApacheCon is the best place to find out about tomorrow's software, today. ApacheCon is the official convention of The Apache Software Foundation, and includes t

AW: Quoting queries

2017-04-26 Thread Lane David (ST-ESS/MKP3.2)
Hi all, just to bump this, is there anything that can be done here? At the moment I am reduced to executing queries on the command line and scraping the data together afterwards which is partly very time consuming. Mit freundlichen Grüßen / Best regards David Lane -Ursprüngliche Nachrich