Re: Drill error

That could be a possibility. See if you can skip that value in the column... try using a filter condition with a such as  NOT LIKE '%'  On 6/27/2018 11:25:10 PM, Nitin Pawar wrote: Could this cause an issue if one of the field in concat function has large text ? On Thu, Jun 28, 2018 at 11:10

Re: Drill error

Thank you, Nitin Kind regards Vitalii On Thu, Jun 28, 2018 at 6:04 PM Nitin Pawar wrote: > created https://issues.apache.org/jira/browse/DRILL-6551 > > On Thu, Jun 28, 2018 at 7:43 PM, Vitalii Diravka < > vitalii.dira...@gmail.com> > wrote: > > > Hi Nitin, > > > > This is definitely the

Re: Drill error

created https://issues.apache.org/jira/browse/DRILL-6551 On Thu, Jun 28, 2018 at 7:43 PM, Vitalii Diravka wrote: > Hi Nitin, > > This is definitely the regression. Could you please post the Jira ticket > with details of your case, data and workaround [1]. > It will help for developers to solve

Re: Drill error

Hi Nitin, This is definitely the regression. Could you please post the Jira ticket with details of your case, data and workaround [1]. It will help for developers to solve this issue. [1] https://issues.apache.org/jira/projects/DRILL Thanks. Kind regards Vitalii On Thu, Jun 28, 2018 at 10:50

Re: Drill error

I was able to fix this issue by doing concat(string1, ' ', string2) instead of concat(string1, string2) Not sure how adding a separator helps but it solved the problem On Thu, Jun 28, 2018 at 11:55 AM, Nitin Pawar wrote: > Could this cause an issue if one of the field in concat function has

Re: Drill error

Could this cause an issue if one of the field in concat function has large text ? On Thu, Jun 28, 2018 at 11:10 AM, Nitin Pawar wrote: > Hi Khurram, > > This is a parquet table. > all the columns in the table are string columns (even date column is > stored as string) > > I am currently using

Re: Drill error

Hi Khurram, This is a parquet table. all the columns in the table are string columns (even date column is stored as string) I am currently using drill 1.13.0. Same query used to work fine on drill 1.8.0 Thanks, Nitin On Thu, Jun 28, 2018 at 12:17 AM, Khurram Faraaz wrote: > Hi Nitin, > > Can

Re: Drill error

Hi Nitin, Can you please share the description of the table (i.e. column types) ? Is this a parquet table or JSON ? Also please share the version of Drill and the drillbit.log Thanks, Khurram On Wed, Jun 27, 2018 at 9:45 AM, Nitin Pawar wrote: > here are the details > > query: > > select

Re: Drill error

here are the details query: select Account Account,Name Name,CONCAT(DateString , string2) Merged_String from dfs.tmp.`/nitin/` t1 There is no custom UDF in this query; On Wed, Jun 27, 2018 at 2:22 PM, Nitin Pawar wrote: > Hi Vitalii, > > Thanks for the description. > I will try to get the

Re: Drill error

Hi Vitalii, Thanks for the description. I will try to get the log for this but as this is happening in production and drill log gets overwritten in our case very fast. Also I will get the query for the same while getting the log I will get the details and update the thread Thanks, Nitin On

Re: Drill error

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?

Drill error

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:

RE: Apache Drill- Error setting up remote intermediate fragment execution

Drill- Error setting up remote intermediate fragment execution Sent too soon. Hi Surneni, This looks to be an issue with your network setup. The address or hostname known to a Drillbit about another Drillbit is not resolved correctly while trying to make connection. Nodes with failure

Re: Apache Drill- Error setting up remote intermediate fragment execution

) ~[netty-common-4.0.48.Final.jar:4.0.48.Final] Thanks, Sorabh From: Sorabh Hamirwasia Sent: Wednesday, April 11, 2018 9:04 AM To: user@drill.apache.org Subject: Re: Apache Drill- Error setting up remote intermediate fragment execution Hi Surneni, This looks

Re: Apache Drill- Error setting up remote intermediate fragment execution

; Sent: Wednesday, April 11, 2018 8:30 AM To: user@drill.apache.org Subject: FW: Apache Drill- Error setting up remote intermediate fragment execution Hi Team, I have successfully launched a Drill cluster on 3 docker containers with Zoo keeper Quorum and accessing data from a remote node on

FW: Apache Drill- Error setting up remote intermediate fragment execution

Hi Team, I have successfully launched a Drill cluster on 3 docker containers with Zoo keeper Quorum and accessing data from a remote node on which Drill is not installed . I am able to list all the drill bits from each node and run queries on a single drill bit , But I am facing issue when

Re: Apache drill : Error while creating storage plugin for Oracle DB

;<>:<" > } > > Thanks, > > Arjun > > ____ > From: Arjun kr <arjun...@outlook.com> > Sent: Wednesday, November 1, 2017 11:20 AM > To: user@drill.apache.org > Subject: Re: Apache drill : Error while creating storage plug

Re: Apache drill : Error while creating storage plugin for Oracle DB

-drill-1.11.0", zk.connect: "<>:<" } Thanks, Arjun From: Arjun kr <arjun...@outlook.com> Sent: Wednesday, November 1, 2017 11:20 AM To: user@drill.apache.org Subject: Re: Apache drill : Error while creating storage plugin for Or

Re: Apache drill : Error while creating storage plugin for Oracle DB

r.com> > Sent: Wednesday, November 1, 2017 11:12 AM > To: user@drill.apache.org > Subject: RE: Apache drill : Error while creating storage plugin for Oracle > DB > > Could you file a JIRA for this? I see the potential sources where the bug > originated and there

Re: Apache drill : Error while creating storage plugin for Oracle DB

: user@drill.apache.org Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB Could you file a JIRA for this? I see the potential sources where the bug originated and there doesn’t seem to be sufficient logging, so it gets hard to narrow it down. -Original Message

RE: Apache drill : Error while creating storage plugin for Oracle DB

To: user@drill.apache.org Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB Hi Arjun/Kunal, Just to add to my previous mail I am using *Apache Drill version 1.11.0.* Thanks, Akshay On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <joshiakshay0...@gmail.com> wrote:

Re: Apache drill : Error while creating storage plugin for Oracle DB

" -d >> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver": >> "oracle.jdbc.driver.OracleDriver", >> "url":"jdbc:oracle:thin:/@> server>:/" }}' http:/

Re: Apache drill : Error while creating storage plugin for Oracle DB

quot;: > "oracle.jdbc.driver.OracleDriver", > "url":"jdbc:oracle:thin:/@ server>:/" }}' http://< > drill_server>:8047/storage/oracle1.json > > Please refer to this blog for curl command if you have HTTPS enabled. > > http://www.openkb.inf

Re: Apache drill : Error while creating storage plugin for Oracle DB

this connection URL using any other jdbc application. Thanks, Arjun From: Kunal Khatua <kkha...@mapr.com> Sent: Tuesday, October 31, 2017 11:57 PM To: user@drill.apache.org Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB There are

RE: Apache drill : Error while creating storage plugin for Oracle DB

To: user@drill.apache.org Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB Hi Arjun, No error message getting logged in drillbit.log once I click on "create" button. Thanks, Akshay On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr <arjun...@outlook.com> wrote:

Re: Apache drill : Error while creating storage plugin for Oracle DB

> > Thanks, > > Arjun > > > From: Akshay Joshi <joshiakshay0...@gmail.com> > Sent: Tuesday, October 31, 2017 11:10 PM > To: user@drill.apache.org > Subject: Re: Apache drill : Error while creating storage plugin for Oracle > DB > > Hi Arjun, > > Ye

Re: Apache drill : Error while creating storage plugin for Oracle DB

Do you see any specific error message in drillbit.log ? Thanks, Arjun From: Akshay Joshi <joshiakshay0...@gmail.com> Sent: Tuesday, October 31, 2017 11:10 PM To: user@drill.apache.org Subject: Re: Apache drill : Error while creating storage plugin for Ora

Re: Apache drill : Error while creating storage plugin for Oracle DB

odes and restarted drillbits ? > > > Thanks, > > > Arjun > > > > From: Akshay Joshi <joshiakshay0...@gmail.com> > Sent: Tuesday, October 31, 2017 9:46 PM > To: user@drill.apache.org > Subject: Apache drill : Error whil

Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Akshay, Did you copy jdbc driver to all the drill nodes and restarted drillbits ? Thanks, Arjun From: Akshay Joshi <joshiakshay0...@gmail.com> Sent: Tuesday, October 31, 2017 9:46 PM To: user@drill.apache.org Subject: Apache drill : Error while cr

Apache drill : Error while creating storage plugin for Oracle DB

Hi Team, I have configured drill on 4 node cluster and getting error while creating storage plugin for Oracle DB. Error : Please retry: error (unable to create/ update storage) Oracle DB Version : *12.1.0.2.0* Following steps followed to create storage plugin: 1. copied ojdbc7.jar to

RE: drill error connecting to Hbase

: drill error connecting to Hbase Hi Kunal, I am assisting Shai with the drill, I followed you instructions but once I am running maven with the profile of cloudera aka 'cdh' I am receiving this [dor@dor-fedora64 drill]$ mvn -U -DskipTests clean install -Pcdh [INFO] Scanning for projects

RE: drill error connecting to Hbase

o:kkha...@mapr.com] Sent: יום ה 03 אוגוסט 2017 20:53 To: user@drill.apache.org Subject: RE: drill error connecting to Hbase The failure appears to be coming from this: Caused by: java.lang.IllegalAccessError: Class org/apache/hadoop/hbase/zookeeper/MetaTableLocator illegally accessing "packa

RE: drill error connecting to Hbase

Attached the relevant part from the sqlline.log, Hope it helps Thanks, Shai -Original Message- From: Shai Shapira Sent: Thursday, August 03, 2017 11:04 AM To: kkha...@mapr.com Cc: user@drill.apache.org Subject: RE: drill error connecting to Hbase Hi, My versions are: Hbase - 1.2.0

RE: drill error connecting to Hbase

ailto:kkha...@mapr.com] Sent: Wednesday, July 26, 2017 8:58 PM To: user@drill.apache.org Subject: RE: drill error connecting to Hbase The bundled projects (HBase, Hive) in CDH have their own versions. I'm wondering if that is what is the difference. Drill has been tested with HBase 1.1.1 and

RE: drill error connecting to Hbase

see in the SQLLine session... there is a complete stack trace in the Drill logs. Can you share that stack trace as well? -Original Message- From: Shai Shapira [mailto:shai.shap...@amdocs.com] Sent: Wednesday, July 26, 2017 5:50 AM To: user@drill.apache.org Subject: RE: drill error

RE: drill error connecting to Hbase

It is CDH 5.8.2 I believe it is reliable versions, isn't it? Thanks, Shai -Original Message- From: Kunal Khatua [mailto:kkha...@mapr.com] Sent: Monday, July 24, 2017 8:50 AM To: user@drill.apache.org Subject: RE: drill error connecting to Hbase This means that the connectivity with ZK

RE: drill error connecting to Hbase

, 2017 2:58 AM To: user@drill.apache.org Cc: Shai Shapira <shai.shap...@amdocs.com> Subject: RE: drill error connecting to Hbase Hi, I installed Drill and started to work with it, my goal is to use it to connect to Hbase. I checked it a bit locally, csv files, Json files, works great. Whe

RE: drill error connecting to Hbase

ssage: stud SQL Query null [Error Id: f0a6591d-9068-4490-95c0-b0aea41365b4 on illin4620:31010] (state=,code=0) Thanks, Shai From: Shai Shapira Sent: Sunday, July 23, 2017 12:49 PM To: Shai Shapira <shai.shap...@amdocs.com> Subject: drill error connecting to Hbase Shai Shapir

Re: Apache Drill Error

Thanks, that fixed the problem for me on Mac with Drill 1.8. I had the same error as OP (Unable to locate an executable at "/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1)) $ diff drill-config.sh drill-config.sh.bak 395c395 < #export JAVA_HOME --- > export JAVA_HOME On 21

Re: Apache Drill Error

Sorry, I meant Try (not Trying) > On Sep 21, 2016, at 10:08 AM, Padma Penumarthy > wrote: > > Trying commenting out the following line in > distribution/target/apache-drill-1.9.0-SNAPSHOT/apache-drill-1.9.0-SNAPSHOT/bin/drill-config.sh > > export JAVA_HOME > >

Re: Apache Drill Error

Trying commenting out the following line in distribution/target/apache-drill-1.9.0-SNAPSHOT/apache-drill-1.9.0-SNAPSHOT/bin/drill-config.sh export JAVA_HOME Thanks, Padma > On Sep 20, 2016, at 7:17 PM, Rajasimman Selvaraj > wrote: > > Hi , > I am getting the

Apache Drill Error

Hi , I am getting the following error while starting the drill in Mac OS for the first time. Unable to locate an executable at "/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1) I have the java JDK installed in my machine as listed below.

Re: IllegalStateException: Memory was leaked by query - Drill error on wide table, but OK on a narrow but longer table.

I don't know if it is related, but our /tmp files were filled up. I will try to search, but our machines got hosed up from the problem (queries were running over the last weekend), so I am not sure if I can recover or if I can easily replicate. Will try. On Saturday, March 26, 2016, Abdel Hakim

Re: IllegalStateException: Memory was leaked by query - Drill error on wide table, but OK on a narrow but longer table.

Hey Edmon, Can you search the logs for the errorId displayed with this error ? I've seen a similar issue when external sort fails to spill to disk (no space left on disk), it would leak memory and display this error message instead of the original issue (problem spilling to disk). I will open a

IllegalStateException: Memory was leaked by query - Drill error on wide table, but OK on a narrow but longer table.

We are converting some raw CMS data from csv to parquet using Drill, and using partitioning as we go. Query 1 runs OK on a narrower file: size: 13G Mar 16 18:20 out_revenuej_lds_100_201412.csv (Month 12 file) 13G Mar 16 16:37 out_claimsj_lds_100_2014_q1.csv (Quarter 1 file) q1 has 198 columns;

RE: Drill error with large sort

Thanks for this, these parameters fixed it! ---Paul -Original Message- From: Abdel Hakim Deneche [mailto:adene...@maprtech.com] Sent: Thursday, February 25, 2016 5:32 PM To: user <user@drill.apache.org> Subject: Re: Drill error with large sort Not so short answer: In Drill

Re: Drill error with large sort

finish if u add a limit / top clause? >> # what do the logs say? >> >> >> From: Paul Friedman <paul.fried...@streetlightdata.com> >> Sent: Thursday, February 25, 2016 7:07:12 PM >> To: user@drill.apache.org >> Subject: Dri

Re: Drill error with large sort

<paul.fried...@streetlightdata.com> Sent: Thursday, February 25, 2016 7:07:12 PM To: user@drill.apache.org Subject: Drill error with large sort I’ve got a query reading from a large directory of parquet files (41 GB) and I’m consistently getting this error: Error: RESOURCE ERROR: One or more nod

Drill error with large sort

I’ve got a query reading from a large directory of parquet files (41 GB) and I’m consistently getting this error: Error: RESOURCE ERROR: One or more nodes ran out of memory while executing the query. Unable to allocate sv2 for 1023 records, and not enough batchGroups to spill.