Re: [ANNOUNCE] New PMC Chair of Apache Drill

Congratulations Charles ! Looking forward for much better Drill and more addition in your book as well :) Thanks , Divya On Fri, 23 Aug 2019 at 12:07 PM, Bhargava Vadlamani wrote: > Congratulations Charles !! > > On Thu, Aug 22, 2019, 8:56 PM Abhishek Girish wrote: > > > Congratulations,

Re: Documentation for maths operations between different types?

; great to review the function tables in the book and apply any missing > information to the Drill documentation. > > Thanks, > - Paul > > > > On Friday, August 16, 2019, 08:25:14 AM PDT, Divya Gehlot < > divinediv...@gmail.com> wrote: > > Can we add thi

Re: Documentation for maths operations between different types?

Can we add this as part of Drill Function docs , will be useful for other ppl as well ? I can help to add , unsure if I have access to edit Drill doc Thanks , Divya On Fri, 16 Aug 2019 at 01:04, Paul Rogers wrote: > Hi Dave, > > As it turns out, improving the detail in function documentation

Re: Heap memory - leak

Can you share the more details . Query profile and other aspects like data size and all to have better view what’s happening Thanks , Divya On Fri, 7 Jun 2019 at 4:13 PM, Dweep Sharma wrote: > Data is in JSON format. > > On Fri, Jun 7, 2019 at 1:39 PM Dweep Sharma > wrote: > > > Hi, > > > >

Re: Drill Meetup @ Santa Clara (Wednesday)

Thank you so much for sharing this as off-site people like me would be benefited :). Just a quick suggestion can we create a tab “Drill talks and presentation” in Apache Drill website and share all the presentation links there . Allow folks to upload there talks/presentation. Even I have presented

Re: Apache Drill & LDAP

Hi Alaa , Yes Drill works with LDAP dierctly once you have the PAM configuration in your drill-overide,conf Here is the link : https://drill.apache.org/docs/using-libpam4j-as-the-pam-authenticator/ Thanks, Divya On Wed, 12 Dec 2018 at 09:36, Alaa Salmo wrote: > Hi All, > > Can apache Drill

Re: Apache Drill Meetup on Nov 14th!

Hi , Can we have the link of recorded video for the audience who cannot attend in person ? Thanks, Divya On Mon, 5 Nov 2018 at 06:46, Pritesh Maker wrote: > Hello, Drillers! > > We are restarting meetups for Apache Drill! The next meet up will be on Nov > 14th at 6:30 PM at the MapR

Re: Query hung in Cancelled_Requested state

bh > > On Thu, Oct 25, 2018 at 10:49 PM Kunal Khatua wrote: > > > What is the Drillbit's JStack? You can try seeing the /threads webpage. > > > > On 10/25/2018 8:16:06 PM, Divya Gehlot wrote: > > Hi, > > I am using Dril 1.10 and I have query running for days

Query hung in Cancelled_Requested state

Hi, I am using Dril 1.10 and I have query running for days and when I click on cacel the query through Drill Web UI . It hung in Cancellation_Requested state . Is there any way to cancel the query using query id though terminal ? Appreciate your help ! Thanks, Divya

Drill UDFs doc

Hi, Can anybody guide me to the page/git hub repo where all the Drill UDFs are available so that users can check it first before writing their own. Appreciate the help ! Thanks, Divya

Re: [HANGOUT] [new link] Topics for October 02 2018

Can we have the recordings of the talk for the benefit of the other drill users in the community or it is a closed affair ? Thanks, Divya On Sat, 29 Sep 2018 at 05:13, Karthikeyan Manivannan wrote: > Hi, > > We will have a Drill Hangout on October 2 2018 at 10 AM Pacific Time. > Please

Re: Performance issue while fetching the latest data in multi directory hierarchy env

apologies on MAXDIR syntax The correct syntax is MAXDIR( 'schema_name','./path/to/directory/') On Thu, 11 Oct 2018 at 15:40, Divya Gehlot wrote: > Hi, > I have data in below hierarchy > Date\ >Hour of the day \ > 04 > 08 > 12 >

Performance issue while fetching the latest data in multi directory hierarchy env

Hi, I have data in below hierarchy Date\ Hour of the day \ 04 08 12 . 60 I used the query like below Select * from `schema_name`.`./path/to/directory/` where dir0 = MAXDIR( `schema_name`.`./path/to/directory/`) and its taking 3-5 minutes

Re: ERROR is reading parquet data after create table

.`load_pos_sales_detail_tbl/1_9_1.parquet`; > > > On Tue, Oct 2, 2018 at 4:44 PM Herman Tan wrote: > > > Hi Divya and everyone, > > > > The problem has disappeared. > > Drill was not restarted. > > This appears to be intermittent. > > Before I submitted the error

Re: Drill Log file plugin not working in Drill 1.14

cs update. Charles and Bridget can review it. > Example of the PR - https://github.com/apache/drill/pull/1479 < > https://github.com/apache/drill/pull/1479> > > Kind regards, > Arina > > > On Oct 8, 2018, at 9:45 AM, Divya Gehlot > wrote: > > > > Thank y

Re: Failed to create schema tree when running Drill View Query

the filesystem. > > Can you try if (1) username is passed when launching your client such as > Sqlline, (2), the user (with same UID) exists on all nodes on the cluster. > > > On Wed, Oct 10, 2018 at 8:07 PM Divya Gehlot > wrote: > > > Hi , > > At times I get bel

Re: Kafka Plugin in Drill 1.14

ur system. > Location depends on your settings, for Windows in could be in tmp folder on > one of your disks. Stop Drill, delete drill folder with its content and > start Drill. > > Kind regards, > Arina > > > On Oct 8, 2018, at 10:09 AM, Divya Gehlot > wrote: > >

Failed to create schema tree when running Drill View Query

Hi , At times I get below error when running the View query which fetches the whole data set org.apache.drill.common.exceptions.UserRemoteException: RESOURCE ERROR: Failed to create schema tree. The Strange behaviour is if I wait for sometime for say 2-3 minutes and run the query again it works

Re: Kafka Plugin in Drill 1.14

configured Kafka storage plugin is available > on the Storage page in the Drill Web Console. Once you enable and configure > the storage plugin, you can query Kafka from Drill. > > Thanks, > Khurram > > On Wed, Oct 3, 2018 at 7:25 PM Divya Gehlot > wrote: > > > H

Re: Drill Log file plugin not working in Drill 1.14

7aa2baa1fc6cbd85fb614b5d975/exec/java-exec/src/main/java/org/apache/drill/exec/store/log/README.md > > > > You’ll find that the newer version is A LOT easier to use than that! > > > @Bridget, could you please take a look at this and update the docs? > Thanks! > > >

Drill Log file plugin not working in Drill 1.14

Hi, I am using Drill 1.14 and followed these instructions to read log files of any format in drill. When I insert the log plugin in the storage plugin , it is complaining that its is not valid JSON , though I already verified it through JSON

Kafka Plugin in Drill 1.14

Hi, I installed Drill in embedded mode and I don't see Kafka plugin under Storage plugin in Web UI . Do I need to create or its available by default? Thanks, Divya

Re: ERROR is reading parquet data after create table

Hi Herman, Just to ensure that your parquet file format is not corrupted , Can you please query a folder like just 2001 or some of the files underneath .Instead of querying the whole data set at once . Thanks, Divya On Wed, 26 Sep 2018 at 15:35, Herman Tan wrote: > Hi Kunal, > > > That

Re: Possible to limit the amount of files produced by Drill when running CREATE TABLE statements?

Even I looked for it and I couldn't find it . Only workaround for now which even I implemented is to merge the files using hadoop commands hadoop fs -merge /path/to/files /path/to/mergedfile and if your data contain headers then you might have to look to this

Apache Drill meetup session ideas

Hi , I will be delivering an Apache Drill Meet up session including hands on workshop. Would like to get help ideas and advise from the community members based on their Enterprise Experience Like what all the core components of the Drill I should highlight ? The Drill strong points which I could

Re: trim special character in table column

? > > Thanks. > > Karthik > > On Mon, Sep 17, 2018 at 2:27 AM Divya Gehlot > wrote: > > > Hi, > > I am using Drill 1.10 > > My apologies if My query is naive . > > One of the table column field has special character like '/' > > when

trim special character in table column

Hi, I am using Drill 1.10 My apologies if My query is naive . One of the table column field has special character like '/' when I am doing RTRIM on it to just get the data before the '/' , it's not working :( Appreciate if anybody know how it works in Apache Drill ! Thanks, Divya

Re: Drill Tableau Live connection issue

cause issues pending the > underlying data. > > > > > > Andries Engelbrecht > Senior Solution Architect > Alliances and Channels Engineering > MapR > > aengelbre...@mapr.com > > > On Sep 12, 2018, at 9:31 PM, Divya Gehlot wrote: > > Hi, > I am facing

Drill Tableau Live connection issue

Hi, I am facing a strange issue with Tableau Apache Drill live connection Tableau Version : 10.4 MapR Drill Driver : MapRDrill_odbc_v1.3.13.1037 OS : Windows Server 2012 I have few numeric values in the view I connected and When I describe it I get "The Single value is null" even for all the

Re: Session handling with multiple drillbits

Hi , I do use alter session for change the store format and it all works well . I have scheduled ETL running but at times I have a use case to provide the file in csv format so I use sqlline to do so. and It doesnt even affect my other scheduled ETLs too. For me drill set up distributed through

Re: java pointer error in drill log

Khatua wrote: > Is there a stack trace? Does the Drillbit crash, because that might have > generated a log as well (hs_error_ ) ? > > On 8/28/2018 12:47:57 AM, Divya Gehlot wrote: > Hi, > I could see java pointer error in drill logs as beow > *** Error in > > `/usr/lib/j

java pointer error in drill log

Hi, I could see java pointer error in drill logs as beow *** Error in `/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.181-3.b13.el7_5.x86_64/jre/bin/java': free(): invalid pointer: 0x7f503088 *** What could be possible reasons for the error - Is it caused by Drill or its the java issue ?

Login Failure investigation

Hi , Appreciate the help on login failure issues . which login configuration should I enable to get the RCA of some of the users login failures ? Thanks, Divya On Tue, 7 Aug 2018 at 16:41, Divya Gehlot wrote: > Hi, > I have distributed drill (6 nodes) connected to AD and some of the

how to investigate PAM login issues

Hi, I have distributed drill (6 nodes) connected to AD and some of the users are able to connect to drill after multiple tries whereas some are able to connect in first attempt itself . Can anybody please share the best practice to investigate this kind of issue ? Thanks, Divya

Re: Failure finding Drillbit on host

reported? It might be that the node/Drillbit is > overloaded and not responding to the scheduler, causing it to be marked as > "skipped for affinity", so nothing will be scheduled on that. > > > On 7/3/2018 7:43:08 AM, Divya Gehlot wrote: > Hi, > Can anybody help me wit

Re: Best Practice to check Drillbit status(Cluster mode)

| grep -i drillbit' and then a kill -9) > on nodes where you suspect issues and restart Drillbits? > > -Abhishek > > On Tue, Jul 10, 2018 at 7:16 PM Divya Gehlot > wrote: > > > Hi , > > select * from sys.drillbits; > > What does above query shows if drillbits pr

Re: Best Practice to check Drillbit status(Cluster mode)

ONLINE. > > select * from sys.drillbits; > > - Khurram > > On Tue, Jul 10, 2018 at 12:24 AM, Divya Gehlot > wrote: > > > Hi, > > I would like to know the best practice to check the Drillbits status in > > cluster mode. > > I have encountered the scenario

Best Practice to check Drillbit status(Cluster mode)

Hi, I would like to know the best practice to check the Drillbits status in cluster mode. I have encountered the scenario when check Drillbits process running fine and When check in Drll WebUI , some of the Drillbits are down. When do RCA(root cause analysis) , got to know due to some reason

Re: difference between cast as timestamp and to_timestamp

+ > | EXPR$0 | > ++ > | 2018-07-03 00:00:00.0 | > ++ > 1 row selected (0.297 seconds) > 0: jdbc:drill:> > > Thanks, > > Arjun > > > From: Divya Gehlot > Sent: Tue

Re: need understanding of drill affinity configurations

errors. > > So, what is the problem you have ? > > Thanks > Padma > > > > On Tue, Jul 3, 2018 at 9:00 PM, Divya Gehlot > wrote: > > > Hi, > > I would like to understand below configurations : > > work: { > > max.width.per.endpoint: 5, > >

difference between cast as timestamp and to_timestamp

Hi, Below gives me different values Query 1: select CAST(1530601200049 AS TimeStamp) from (values(1)); EXPR$0 2018-07-03T07:00:00.049-05:00 Query 2: select TO_TIMESTAMP(1530601200049) from (values(1)); Apache Drill 50472-10-26T11:00:49.000-05:00 Query 3 : select

Failure finding Drillbit on host

Hi, Can anybody help me with the cause of below error : 2018-07-03 04:08:47,783 [pool-245-thread-4] INFO > o.a.d.e.s.schedule.BlockMapBuilder - Failure finding Drillbit running on > host . Skipping affinity to that host. > 2018-07-03 04:08:47,783 [pool-245-thread-13] INFO >

Re: unable to read timestamp when create CSV file wheras parquet can read

Has anybody this issue between CSV and parquet files ? Really appreciate the help ! On Mon, 2 Jul 2018 at 17:51, Divya Gehlot wrote: > Hi, > I am getting error when I creating the CSV files > The part of the query throwing error is as below, the input data comes in > unix time fo

Re: CTAS AccessControlException

; usermod -u 5000 user1 > groupmod -g 5000 user1 > > > > Regards, > Abhishek > > On Mon, Jul 2, 2018 at 2:58 AM Divya Gehlot > wrote: > > > Hi Abhishek, > > Thanks for the prompt response ! > > Yes I have Big Data Cluster and Apache Drill is part of it and s

Re: CTAS AccessControlException

nd let us know? > > Regards, > Abhishek > > On Sun, Jul 1, 2018 at 7:16 PM Divya Gehlot > wrote: > > > Hi, > > When I checked the error in Profile section of the ran query : > > > > Apache Drill > > > > "error": "SYSTEM ERROR:

unable to read timestamp when create CSV file wheras parquet can read

Hi, I am getting error when I creating the CSV files The part of the query throwing error is as below, the input data comes in unix time format CAST(FROM_UNIXTIME(t.`timestamp`/1000) AS TIMESTAMP) AS `datetime` Apache Drill org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:

Default schema error

Hi, I am getting a default schema error Error: VALIDATION ERROR: Schema [.default] is not valid with respect to either root schema or current default schema. Current default schema: No default schema selected [Error Id: 9bea38af-6a82-4d71-a937-25169905fcac on :31010] (state=,code=0) All of

Re: CTAS AccessControlException

work.fragment.FragmentExecutor.run():226 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 Thanks, Divya On Fri, 29 Jun 2018 at 18:41, Divya Gehlot wrote: &g

Re: CTAS AccessControlException

> On 6/29/2018 3:42:17 AM, Divya Gehlot wrote: > Hi, > At times I am getting error whlile CTAS and it doesn't happen all the time > like next run for 18 hours it will create the table . > Here are the details : > ls -ltr /path/to/directory/parquetfiles/2018_06_29 > total 9 &g

CTAS AccessControlException

Hi, At times I am getting error whlile CTAS and it doesn't happen all the time like next run for 18 hours it will create the table . Here are the details : ls -ltr /path/to/directory/parquetfiles/2018_06_29 total 9 drwxrwxr-x 2 1 Jun 28 12:05 00 drwxrwxr-x 2 1 Jun 28 13:05 01 Error Logs :

unable to login to Drill as admin user all other login works fine

Hi, I am unable to login to Drill through admin user , although all other users able to login . Case: 00066100 ~ Customer Portal Caused by: org.apache.drill.exec.rpc.NonTransientRpcException: javax.security.sa sl.SaslException: Authentication failed unexpectedly. [Caused by java.util.concu

Re: strange access control exception

.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:155) > [drill-java-exec-1.10.0.jar:1.10.0] > ... 5 common frames omitted > 2018-06-18 01:57:23,291 [BitServer-2] INFO > o.a.drill.exec.work.foreman.Foreman - Failure while trying communicate > query result to initiating cl

strange access control exception

Hi, I am running a drill query in loop by passing Month,Day and hour as parameter . The query runs fine all the time except at some times where I get below error : Error: SYSTEM ERROR: AccessControlException: User (user id 829131620) does not have access to

Re: Which perform better JSON or convert JSON to parquet format ?

gt; > But Parquet will be faster during a scan. > > Faster may be better. Or other things may be more important. > > You have to decide what is important to you. The great virtue of drill is > that you have the choice. > > > > On Mon, Jun 11, 2018 at 11:06 AM Divya G

Re: UnsupportedOperationException: Unsupported type LIST

> > > > On Monday, June 11, 2018, 10:31:57 AM PDT, Kunal Khatua < > ku...@apache.org> wrote: > > I'm wondering if this JIRA is related the issue you are facing: > https://issues.apache.org/jira/browse/DRILL-2241 > On 6/11/2018 9:44:32 AM, Kunal Khatua wrote: > C

UnsupportedOperationException: Unsupported type LIST

Hi , I am trying to convert the complex json format to Parquet and I am getting below erro : SYSTEM ERROR: UnsupportedOperationException: Unsupported type LIST Fragment 0:0 JSON File format as below : { "results":[ { "_id":"5b1a3374fb4365076b4d48a8",

Re: Which perform better JSON or convert JSON to parquet format ?

Thanks to all for your opinions ! As Drill has been popularised as complex JSON reader as compare to other tools in space . Was wondering does drill works better for JSON rather than parquet.

explain - Polygon shapes and MultiPolygon shapes

Hi, Can anybody help me by explaining below : Drill cannot handle the intermixed Polygon shapes and MultiPolygon shapes. Workaround: None, per se, but if you avoid querying the multi-polygon lines (120 of them), Drill works fine on the entire remainder Thanks, Divya

Which perform better JSON or convert JSON to parquet format ?

Hi, I am looking for the advise regarding the performance for below : 1. keep the JSON as is 2. Convert the JSON file to parquet files My JSON files data is not in fixed format and file size varies from 10 KB to 1 MB. Appreciate the community users advise on above ! Thanks, Divya

Re: Apache Drill and Tableau connectivity issue

17/01/25/drill-best-practices-for-bi-and-analytical-tools > > > > Drill Best Practices for BI and Analytical Tools | MapR ...< > https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools > > > community.mapr.com > Below are a number o

OS user and AD user works simultaneously in Drill

Hi , I have query regarding authenticate OS user as Drill user. Here is how my drill is being set up -It is configured with PAM configurations and it’s connected to AD .All the users login using AD credentials .Admin of the drill is OS user . Now my query is if I would like OS user(not admin ) to

Re: Read complex json file gives list type doesn't support different data types

2018, 8:29:11 PM PDT, Padma Penumarthy < > ppenumar...@mapr.com> wrote: > > yes, that is correct. > You can try setting the option “exec.enable_union_type” for that to work > with the caveat that > union type is not fully supported in drill. > > Thanks > Padma > > >

Re: How to Start Drill Service From Linux Non-root user

tmp work space. > > Best regards, > _ > Tilak Surneni > > -Original Message- > From: Divya Gehlot [mailto:divya.htco...@gmail.com] > Sent: Thursday, May 31, 2018 3:58 PM > To: user@drill.apache.org > Subject: Re: How to Start Drill

Re: How to Start Drill Service From Linux Non-root user

on.com/ > NSC-TEST/stk/tpcdsView/web_returns (exists=false, > cwd=file:/usr/local/drill/bin) > > > Best regards, > _ > Tilak Surneni > > -----Original Message- > From: Divya Gehlot [mailto:divya.htco...@gmail.com] > Sent: Thursday

Re: running embedded mode under windows

Can share the steps you followed ? On Thu, 31 May 2018 at 11:54 AM, Bo Qiang wrote: > Hi, > > Sorry for this newbie question. I have been following the documentation to > start drill in embedded mode. But so far, I have no luck. I also tried on > two different machines, the error happened. > >

Re: How to Start Drill Service From Linux Non-root user

: > Hi Divya, > > I am writing to local file system, So I should use file:/// ; But I tried > the option that you have mentioned it's not working. > > > > Best regards, > _ > Tilak Surneni > > -Original Message- > From: Divya

Re: Read complex json file gives list type doesn't support different data types

o work > with the caveat that > union type is not fully supported in drill. > > Thanks > Padma > > > > On May 30, 2018, at 7:56 PM, Divya Gehlot > wrote: > > > > Hi, > > I am reading a complex json file, I am getting format doesn'

Re: Error Joining Two Tables In Apache Drill

; > > > This message has been marked as CONFIDENTIAL on Wednesday, May 30, 2018 @ > 3:57:36 PM > > -Original Message- > From: Divya Gehlot > Sent: Wednesday, May 30, 2018 3:44 PM > To: user@drill.apache.org > Subject: Re: Error Joining Two Tables In Apache Drill &

Re: How to Start Drill Service From Linux Non-root user

>From the plugin information it looks like you are using mapr cluster . Can you change below : "connection": "maprfs:///", Everything else looks good. Thanks, Divya On 31 May 2018 at 16:42, Surneni Tilak wrote: > Hi Sorabh, > > Please find the attached storage plugin information. I am

how to read nested array with different data types in complex json file

Hi , I have complex file json file and I am able to query as below : SELECT `t`.`results`.`_id` as `_id`,`t`.`results`.`Session` as `Session`,`t`.`results`.`Gateway` as `Gateway`,`t`.`results`.`Device` as `Device`,`t`.`results`.`Client` as `Client`,`t`.`results`.`Category` as `Category`,

Read complex json file gives list type doesn't support different data types

Hi, I am reading a complex json file, I am getting format doesn't support while reading below : "Coordinates":[ [ 23.53, 4.99, 11 ], [ 35.09, 7.7, 16 ] ]

Re: Is Drill site down ?

Looks like the issue has been resolved. I am able to browse website now :) On Wed, 30 May 2018 at 5:17 PM, Ted Dunning wrote: > https://drill.apache.org/ works for me. > > What URL were you trying? > > Can you ping that host? > > > On Wed, May 30, 2018 at 10:03

Re: Error Joining Two Tables In Apache Drill

What is the data type of the joining data column views ? Are both columns in views have same data types ? Thanks , Divya On Mon, 28 May 2018 at 11:33 PM, Peter Edike < peter.ed...@interswitchgroup.com> wrote: > Hallos everyone > > > > I have the following query that attempts to join the result

Is Drill site down ?

Hi, I am getting 404 error when opening the drill page. Has any body else facing the issue ? Thanks, Divya

Re: Apache Drill in 10 Minutes - Problems

hi David , Can you try with Drill 1.10 or Drill 1.11 version? Both works fine and I have tested it . Thanks, Divya On 23 May 2018 at 16:11, Richardson, David wrote: > Hi folk. > > > > My self and a colleague have both (independently) been trying the Apache >

Apache Drill and Tableau connectivity issue

Hi, I am facing tableau and Apache Drill connectivity issue recently , which was all working fine for long time (for more than 9+ months ) I did tested couple of scenarios, sharing below : *Driver Version* - MapR Driver Version 1.3.0 *Scenario 1 : Tableau 10.2 - Apche Drill Connection -

Re: is there any way to download the data through Drill Web UI?

ST API to send a query and receive the > results > >> back through http(s) (pending on how you configured Drill. > >> https://drill.apache.org/docs/rest-api/ > >> > >> --Andries > >> > >> > >> > >> On 5/14/18, 1:20 AM, "Divya Gehlot" <divya.htco...@gmail.com> wrote: > >> > >>Hi, > >>Can I download the select query data through Drill Web UI or any > other > >>means ? > >> > >> > >>Thanks, > >>Divya > >> > >> > >> >

is there any way to download the data through Drill Web UI?

Hi, Can I download the select query data through Drill Web UI or any other means ? Thanks, Divya

Re: no current connection error when accessing drill in sql line in distributed mode

:drill:zk=xx.xx.xx.x:5181,xx.xx.xx.x:5181,xx.xx.xx.x:5181" > Also make sure you're not picking up a different script called sqlline. > > On Wed, May 9, 2018 at 8:52 PM, Divya Gehlot <divya.htco...@gmail.com> > wrote: > > > Hi, > > I am trying to access Drill

no current connection error when accessing drill in sql line in distributed mode

Hi, I am trying to access Drill through Sqlline ,I am getting below error : [mapr@usazprdmapr-dn1 bin]$ sqlline –u > jdbc:drill:zk=xx.xx.xx.x:5181,xx.xx.xx.x:5181,xx.xx.xx.x:5181 > OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; > support was removed in 8.0 > –u (No such file

Re: tableau drill connection - handshake time out error

g-tracing-options?view=sql-server-2017 > > > Thanks, > Sorabh > > > > -- > *From:* Divya Gehlot <divya.htco...@gmail.com> > *Sent:* Tuesday, May 8, 2018 3:05 AM > *To:* user@drill.apache.org; Sorabh Hamirwasia > > *Subject:* Re: tableau drill connection - handsh

permission denied error in drillbit.out

Hi, I can see below entry in drillbit.out although user has permission. > 2018-05-08 04:52:37,1456 ERROR JniCommon > fs/client/fileclient/cc/jni_MapRClient.cc:2572 Thread: 2454 readdirplus > failed for dir /Data/Users/AP/, error = Permission denied(13) Can anybody help me interpret above error

Re: tableau drill connection - handshake time out error

; version ? > > > Thanks, > Sorabh > > ____ > From: Divya Gehlot <divya.htco...@gmail.com> > Sent: Wednesday, May 2, 2018 9:23:45 PM > To: user@drill.apache.org > Subject: Re: tableau drill connection - handshake time out error > > H

Re: tableau drill connection - handshake time out error

at 22:06, Andries Engelbrecht <aengelbre...@mapr.com> wrote: > Check the health of your storage plugins on the drillbit/server/cluster > side. > Run a show schemas in sqlline on the drillbit and see how long it takes to > get back. > > > --Andries > > On 5/2/18, 3:

Re: tableau drill connection - handshake time out error

hould appear when you try to > connect. Add HandshakeTimeout= in the AdvancedProperties field. > > If you are using the Apache Drill connector in Tableau: > Then you would need to create a custom settings file for Tableau > to pick up this information. > > Best regards

tableau drill connection - handshake time out error

Hi , I am connecting Apache Drill through Tableau 10.X version . I was able to connect successfully for this while Now all of sudden I am getting handshake timeout error when I try connect drill through tableau. Error : [MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while trying to

Re: Apache Drill.

Unfortunately ,Apache Drill doesnt support distributed installation on windows Machines However it does supports embedded installation which is nothing but standalone installation On 22 March 2018 at 21:50, Robert Smith wrote: > Hi Apache, > > I wonder if

Re: Channel closed exception

well, since beefier machines might not have the same > problem. > > On 3/19/2018 3:57:33 AM, Divya Gehlot <divya.htco...@gmail.com> wrote: > Hi , > The file size is quite small in KBs only . > If you could tell me few scenarios when it happens will help me debug it

Re: Channel closed exception

thrown. What kind of a load are you running on your Drillbits? > > There might be resources in the mailing list archives that have touched > upon solutions for this, so you could look up there as well. > > On Wed, Mar 14, 2018 at 11:09 PM, Divya Gehlot <divya.htco...@gmail.com> &

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 >

change in data fields in json file

Hi, I am processing json data files in Apache Drill. Earlier the format of files were { "field2": [ "296dOmWrTK-dunFoei2gQg" ], "field3": { "name": "SE_21", "count": 0 }, "field1_old": "Qsa87PoaTgCIEab0z8VmgQ", "timestamp": 1514105922659 } Later the files format changes

Re: convert epoch time stamp to timestamp

t; | 2018-01-09 19:48:56.0 | > ++ > 1 row selected (0.461 seconds) > > > Thanks, > > Arjun > > > > From: Divya Gehlot <divya.htco...@gmail.com> > Sent: Monday, January 15, 2018 12:46 PM > To: user@dri

Re: convert epoch time stamp to timestamp

When I SELECT CAST(FROM_UNIXTIME(t.`timestamp`) AS TIMESTAMP) AS `timestamp` FROM path/data/file t limit 10 ; 49995-02-13T19:51:48.000Z 49995-04-22T15:47:05.000Z 49996-09-06T03:21:25.000Z 49997-03-05T01:20:19.000Z I get these values . Thanks, Divya On 15 January 2018 at 15:09, Divya Gehlot

convert epoch time stamp to timestamp

Hi , One of field in my data file is in epoch time stamp . The values would be similar like 1515545336591 How can I convert this to '-MM-DD HH:mm:ss' format . Thanks, Divya

Re: Azure Data lake Connectivity

Hi, Reading data from blob storage would be sinilar to AWS s3 . You need to add the blob storage plugin. This link might help you Happy to Help !! Thanks, Divya On 4

Re: Proposed Slack Channel for Drill Users & Devs

yes most needed On 5 January 2018 at 00:10, Charles Givre wrote: > Hello everyone, > I’m curious, if I were to start a Slack channel for Drill users and Devs, > would there be interest? > — C

Illegal Argument Exception while convert unix date format to drill timestamp

Hi, Does Drill supprts to convert Unix date format to Drill timstamp ? Unix TimeStamp : Thu Dec 14 03:40:50 UTC 2017 When I Cast to Drill time stamp I get Illegal Argument Exception. Thanks, Divya

read physical plan for sql query

Hi , Is there any KB which helps a beginner to read or what to look in physical plan of the query ? Thanks, Divya

Best Practices - Drill with tableau

Hi , Posting this to know the best practices community members for a hourly refresh real time dashboard in tableau with almost 8 worksheets with different calculative analytics in the Dashboard including Map Reports too. My Use case : 1) 2 years worth of data aggregation on one of the dashboard

Re: RPC error when accesing Drill through tableau

l via ODBC, use Drill Explorer as example. > > Also look at some Drill Best Practices for BI Tools > https://community.mapr.com/community/exchange/blog/2017/ > 01/25/drill-best-practices-for-bi-and-analytical-tools > > > —Andries > > > > > On Nov 3, 2017, at 1

  1   2   >