Re: [Drill 1.12.0] : RESOURCE ERROR: Not enough memory for internal partitioning and fallback mechanism for HashAgg to use unbounded memory is disabled

Hi Kunal, Please find below link :- https://drive.google.com/open?id=13NVDqSgDD-Pe6H0smAkvzqktgXURgZF4 SQL File contains platform details and log files contains success/failure logs of query. On Wed, Mar 14, 2018 7:51 PM, Kunal Khatua ku...@apache.org wrote: Hi Anup Can you share this

Re: hive connection as generic jdbc

Hi Asim, I was able to connect to Hive 1.2 using jdbc storage plugin with two below jars. You may give it a try with these jars. http://central.maven.org/maven2/org/apache/hive/hive-service/1.1.1/hive-service-1.1.1.jar http://central.maven.org/maven2/org/apache/hive/hive-jdbc/1.1.1/hive-jdbc-1.

Channel closed exception

Hi, At times my drill query throws channel closed exception. then next one works fine . Here is the stacktrace of the error : > java.sql.SQLException: Error when getting server meta > at > org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getServerMeta(DrillDatabaseMetaDataImpl.java:17

Re: Different output for the same date field

I will file a Jira issue for this problem with a more detailed description. https://issues.apache.org/jira/browse/DRILL-6242 I put some solution possibilities in the Jira. Someone with more knowledge can take a look at see if any of the solution approach makes sense first. Thanks. -- Jiang

Re: Single (embedded) drillbit as a service

We use an upstart (http://upstart.ubuntu.com/getting-started.html) script to launch drill-embedded as a service. It works fine on local Ubuntu machines and AWS ec2 instances. The command used inside the upstart script is similar to what you have: exec /bin/sh "a script that eventually calls d

Re: [Drill 1.12.0] : RESOURCE ERROR: Not enough memory for internal partitioning and fallback mechanism for HashAgg to use unbounded memory is disabled

Hi Anup Can you share this as a file ? There seems to be some truncation of the contents. Share it using some online service like Google Drive or Dropbox, since the mailing list might not allow for attachments. Thanks ~ Kunal On Tue, Mar 13, 2018 at 11:44 PM, Anup Tiwari wrote: > JSON Profil

Re: [Drill 1.10.0/1.12.0] Query Started Taking Time + frequent one or more node lost connectivity error

Hi Anup It helps if you can share the profile (*.sys.drill / *.json files) to help explain. I don't think the user mailing list allows attachments, so you could use an online document sharing service (e.g. Google Drive, etc) to do the same. Coming back to your description, it seems like you are t

Re: [Drill 1.10.0/1.12.0] Query Started Taking Time + frequent one or more node lost connectivity error

Also i have observed one thing, the query which is taking time is creating ~30-40 fragments and 99.9% of record is getting written into only one fragment. On Wed, Mar 14, 2018 1:37 PM, Anup Tiwari anup.tiw...@games24x7.com wrote: Hi Padma, Please find my highlighted answer w.r.t. your

Re: [Drill 1.10.0/1.12.0] Query Started Taking Time + frequent one or more node lost connectivity error

Hi Padma, Please find my highlighted answer w.r.t. your question :- Connection loss error can happen when zookeeper thinks that a node is dead becauseit did not get heartbeat from the node. It can be because the node is busy or you havenetwork problems. Q) Did anything changed in your network ? A

Re: hive connection as generic jdbc

Looks like hive-jdbc-1.1.1-standalone.jar has 'slf4j-log4j' bundled.You may try cloning below repo for hive uber jar that tried earlier. It does not include above the jar. You can try removing 'org.apache.httpcomponents:httpclient' and 'httpcore' from artifact include list and build new jar. h