Apache drill show a lot of CLOSE_WAIT states when we access https://ip address:8047

2018-06-26 Thread Ken Qi (Guangquan)
Hi Team, Hope all is good. We need your help. Here is the apache drill process which we installed in our server. drill19220 1 17 16:48 ?00:15:32 /usr/java/jdk/bin/java -Xms8G -Xmx8G -XX:MaxDirectMemorySize=96G -XX:ReservedCodeCacheSize=1024m -Ddrill.exec.enable-epoll=false

Re: Drill error

2018-06-26 Thread Vitalii Diravka
Hi Nitin, It happens in the process of reallocation of the size of buffers in the memory. It isn't a User Exception, so it looks like a bug, if you get it in some existed plugin. But to say you exactly, please describe your case. What kind of query did you perform, any UDF's, which data source?

Web console responsiveness under heavy load

2018-06-26 Thread Dave Challis
Are there any recommended Drill settings to configure in order to ensure that the web console (running on 8047) remains responsive even under heavy load? Currently, if I execute a large/complex query (that e.g. takes 5m to complete), all queries to 8047 just block until the query completes. I'd

Re: Drill Hangout tomorrow 06/26

2018-06-26 Thread Aman Sinha
Hangout attendees on 06/26: Padma, Hanumath, Boaz, Aman, Jyothsna, Sorabh, Arina, Bohdan, Vitalii, Volodymyr, Abhishek, Robert 2 topics were discussed: 1. Vitalii brought up the Travis timeout issue for which he has sent out an email in this thread; Actually Vitalli can you send it in a

Re: Drill Hangout tomorrow 06/26

2018-06-26 Thread Vitalii Diravka
Lately Drill Travis Build fails more often because of Travis job time expires. The right way is to accelerate Drill execution :) Nevertheless I believe we should consider excluding some more tests from Travis Build. We can add all TPCH tests ( TestTpchLimit0, TestTpchExplain, TestTpchPlanning,

Re: Drill 1.12 query hive transactional orc table

2018-06-26 Thread Vitalii Diravka
Hi, Thanks for your question. Drill started supporting queries on Hive ACID tables past DRILL-1.13.0 version[1]. Please do upgrade onto the last Drill version, then you will able to perform queries for Hive transnational tables. [1] https://drill.apache.org/docs/hive-storage-plugin/ Kind

Re: Drill Hangout tomorrow 06/26

2018-06-26 Thread Padma Penumarthy
Here is the link to the document. Any feedback/comments welcome. https://docs.google.com/document/d/1Z-67Y_KNcbA2YYWCHEwf2PUEmXRPWSXsw-CHnXW_98Q/edit?usp=sharing Thanks Padma On Jun 26, 2018, at 12:12 PM, Aman Sinha mailto:amansi...@gmail.com>> wrote: Hangout attendees on 06/26: Padma,

Re: Help with Apache Drill - S3 compatible storage connectivity

2018-06-26 Thread Paul Rogers
Hi Dummy ID, Have you tried getting Drill to work with the real S3? There were a few confusing bits in the S3 docs that Bridget graciously cleaned up. By trying to access the real S3 you'll ensure that you have gotten the config stuff right. The key missing bit of information was that you had

Re: Help with Apache Drill - S3 compatible storage connectivity

2018-06-26 Thread Parth Chandra
Drill uses HDFS to access S3, so if you have configured the EMC system to be usable by hadoop, it will be usable by Drill. Here's the documentation for an S3 compatible EMC system ( https://www.emc.com/collateral/TechnicalDocument/docu86295.pdf); chapters 6-11 are relevant. I'm not sure if this

Re: Help with Apache Drill - S3 compatible storage connectivity

2018-06-26 Thread dummy id
Can i get an update on this please? On Fri, Jun 15, 2018 at 11:36 AM, dummy id wrote: > *Team, * > > > > *I am not sure who can help me out with this, so just adding both of the > help community..I have followed your documentation on setting up drill and > i am able to query the files from

Re: Help with Apache Drill - S3 compatible storage connectivity

2018-06-26 Thread Saurabh Mahapatra
I mean seriously. Dummy id? Sent from my iPhone > On Jun 26, 2018, at 11:30 AM, dummy id wrote: > > Can i get an update on this please? > >> On Fri, Jun 15, 2018 at 11:36 AM, dummy id wrote: >> >> *Team, * >> >> >> >> *I am not sure who can help me out with this, so just adding both

Drill error

2018-06-26 Thread Nitin Pawar
Hi, Can someone help me understand below error? and how do I not let this happen ?? SYSTEM ERROR: IllegalStateException: Tried to remove unmanaged buffer. Fragment 0:0 [Error Id: bcd510f6-75ee-49a7-b723-7b35d8575623 on ip-10-0-103-63.ec2.internal:31010] Caused By: SYSTEM ERROR: