unable to read text file on windows embedded mode

Hi, I am unbale to *.txt* file on drill on windows embedded mode . Getting following error : > 0: jdbc:drill:zk=local> SELECT * FROM > dfs.`installedsoftwares/ApacheDrill/apache-drill-1.10.0.tar/apache-drill-1.10.0/sample-data/2017-02-020024.txt`; > Jul 21, 2017 12:16:54 PM > org.apache.calcite.s

CTAS and save as parquet last column values are shown as null

Hi , I am facing as weird issue when I CTAS and save the csv file as parquet it displays the last column values as null . This is not the case with one file . If I take any csv file with even with any data type and do a select column1,column2,column3 from table.parquet it shows the column3 values a

Re: CTAS and save as parquet last column values are shown as null

ld be an issue with delimiters. > > [1] > https://drill.apache.org/docs/querying-plain-text-files/#columns[n]-syntax > On Sun, Jul 23, 2017 at 8:44 PM Divya Gehlot > wrote: > > > Hi , > > I am facing as weird issue when I CTAS and save the csv file as parquet > it > >

Re: CTAS and save as parquet last column values are shown as null

FROM TABLE (dfs.`PublicHoliday.csv`(type => 'text',fieldDelimiter => ',', > extractHeader => true)) Thanks, Divya On 24 July 2017 at 13:20, Abhishek Girish wrote: > Unfortunately, the attachments / pictures haven't come through. Mailing > lists sometime

Re: CTAS and save as parquet last column values are shown as null

sday | 26/1/2016 | null | | Monday| 7/3/2016 | null | | Friday| 25/3/2016 | null | | Friday| 1/4/2016 | null | | Friday| 8/4/2016 | null | | Thursday | 14/4/2016 | null | | Tuesday | 19/4/2016 | null | | Sunday| 1/5/2016 | null | | Monday| 9/5/2016 | null | +-

Re: CTAS and save as parquet last column values are shown as null

t; "csv" > ], > "lineDelimiter": "\r\n", > "extractHeader": true, > "delimiter": "," > } > > On Sun, Jul 23, 2017 at 10:37 PM, Divya Gehlot > wrote: > > > 0: jdbc:drill:zk=local&g

Re: CTAS and save as parquet last column values are shown as null

Any best practices guide if any body could share would be great On 24 July 2017 at 14:52, Divya Gehlot wrote: > Thank you so much it worked > > Can you please provide me the pointer to the documentation where updation > for different format type are mentioned . > > As I

Drill and Tableau

Hi, As a naive user would like to know the benefitsof Apache Drill with tableau ? As per my understanding we to visualize we need to push the data to tableau for granular visualization . Would like to understand few features of Drill in terms of visualtion or data retrieval : 1, Metadata Caching

append data to already existing table saved in parquet format

Hi, I am naive to Apache drill. As I have data coming in every hour , when I searched I couldnt find the insert into partition command in Apache drill. How can we insert data to particular partition without rewriting the whole data set ? Appreciate the help. Thanks, Divya

regex replace in string

Hi, I have a CSV file where column values are "This is the column,one " "This is column , two" column3 column4 When I try to regex_replace it throws error org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IllegalArgumentException: reallocation size must be non-negative Frag

Re: append data to already existing table saved in parquet format

t; (there are known issues causing this) between the client and drillbit > after > > executing the "DROP" statement, then your partition data is lost forever. > > And since drill doesn't support transactions, the mentioned approach is > > dangerous. > > > &

Re: regex replace in string

, the SQL query and the version of > Drill that you are on. So someone can take a look and try to reproduce the > error that you are seeing. > > > > > > Thanks, > > > > Khurram > > > > > > From: Divya Gehlot > &

Re: append data to already existing table saved in parquet format

y start failing in the > > future with Drill or otherwise. > > > > Sizing and testing. Just do it. > > > > Thanks, > > Saurabh > > > > > > > > On Wed, Jul 26, 2017 at 2:52 AM, Divya Gehlot > > wrote: > > > >> The data siz

Re: regex replace in string

REGEXP_REPLACE(CAST(`Column1` AS VARCHAR(100)), '[,".]', '') FROM dfs.`installedsoftwares/ApacheDrill/apache-drill-1.10.0.tar/apache-drill-1.10.0/sample-data/sample_data.csv` EXPR$0 P.S. As advised all the above queries I ran on Drill 1.11 Appreciate the help . Thanks, Divya On 27 July

Re: regex replace in string

utes as > Table Function Parameters”. > > - Paul > > [1] https://drill.apache.org/docs/plugin-configuration-basics/ > > > On Jul 26, 2017, at 8:22 PM, Divya Gehlot > wrote: > > > > The another thing which I observed is when I run below query > > SELECT

Re: append data to already existing table saved in parquet format

gt; historical data that came from the OLTP world. You do not want to touch it > once you created it. You want to have a strategy where you batch the recent > data, create the historical data and move on. > > > > My 2 cents. > > > > Saurabh > > > > On Jul

created parquet table using with partition ddint create the partition directories

Hi, I have created the parquet table using CTAS PARTITION BY (Partition1,.) but it didnt created the partition directories , all the parquet files are under directory . Am I missing something ? Appreciate the help. Thanks, Divya

Re: Drill and Tableau

unctions-introduction/ > > But you should also be aware of nesting operations as well: > https://drill.apache.org/docs/nested-data-limitations/ > > and of course there are UDFs: > https://drill.apache.org/docs/adding-custom-functions-to- > drill-introduction/ > > Plea

delimiter in column values

Hi, I have data set which has delimeter in first column value when I read the data set It provides the output below : col_Column1 Column2 Column3 Column4 Column5 "This col6 data" coltwodata6 -33.869732 151.203 "This col7 data yes." coltwodata7 1.2845045 103.8482739 Chifley coltwodata5 coloned

Re: delimiter in column values

g. > > Is there a reason why the single word strings cannot be in quotes as well? > > -Original Message- > From: Divya Gehlot [mailto:divya.htco...@gmail.com] > Sent: Tuesday, August 01, 2017 3:04 AM > To: user@drill.apache.org > Subject: delimiter in column values &g

Re: delimiter in column values

uot; "-35.2793885" "149.1233503" "134" Thanks, Divya On 1 August 2017 at 22:39, Kunal Khatua wrote: > I think you need quotes around the single word datasets as well, because > the quotes act as String delimiters and help in indicating the start and > e

Re: delimiter in column values

ill is that advanced > as to interpret the list of column headers across multiple lines, while > the actual data is in a single line per row. > > Typically text data is in CSV (or other delimiters similar to the comma) > and can have the first line representing a header. > >

Re: delimiter in column values

in 1.11 fixes this case; > 1.10 and earlier have problems if trailing columns are missing.) > > Thanks, > > - Paul > > > On Aug 1, 2017, at 11:51 PM, Divya Gehlot divya.htco...@gmail.com>> wrote: > > Hi, > My column headers are in single line only i.e. > Column1,Co

pass parameters to Drill query in file

Hi, how to pass parameters to Drill query in file? Thanks, Divya

unable to run drill sql in shell script

Hi, I have installed Drill on windows Embedded mode. Have a git Bash installed and I am trying to start the sqlline through the shell script Below is script which I am using : > SQLLINE="/c/ApacheDrill/apache-drill-1.11.0.tar/apache-drill-1.11.0/bin/drill-localhost > -u \"jdbc:drill:zk=localhost:2

Re: delimiter in column values

| > | ["colonedata4","coltwodata4","-33.8724176","151.2067579",""] | > | ["colonedata5","coltwodata5","","",""] | > | ["This, col6 dat

Re: unable to run drill sql in shell script

On 3 August 2017 at 12:18, Padma Penumarthy wrote: > Did you look at this link ? > > https://drill.apache.org/docs/starting-drill-on-windows/ > > > It says, to start drill on windows, do this: > sqlline.bat -u "jdbc:drill:zk=local" > > > Try that and see

Re: pass parameters to Drill query in file

> > This opens a session, and runs all the queries (separated by a semi-colon). > > The force flag is meant for ensuring that in the event a query within the > file fails, it will still continue to execute the following queries in the > file. > > > -Original Message-

Drill JDBC connection on windows in embedded node

Hi, I followed the this link to connect to drill in JDBC mode . *Have installed drill 1.11 on windows 10 in embedded mode .* Configurations which I used : *JDBC Driver* : apache-drill-1.11.0.tar\apache-drill-1.11.0\jars\jdbc-dr

Re: delimiter in column values

t; > I'll try this in a Windows machine in the meanwhile. > > > > From: Divya Gehlot > Sent: Wednesday, August 2, 2017 11:14:56 PM > To: user@drill.apache.org > Subject: Re: delimiter in column values > > Hi , > This is my output when run in sqlline

Re: Drill JDBC connection on windows in embedded node

ct: Re: Drill JDBC connection on windows in embedded node > > Try jdbc:drill:drillbit=localhost > > Since embedded mode doesn’t use ZK you need to connect directly to the > drillbit itself. > > --Andries > > On 8/6/17, 7:37 PM, "Divya Gehlot" wrote: > > Hi

[ERROR]:unable to start drill in distributed mode in windows server 2012

Hi, I have installed Drill 1.11 in dustributed mode in windows server 2012 *Below are confiiguration of my drill-overide.conf file :* drill.exec: { > cluster-id: "drilldistmode", > zk.connect: "NameNode:2181,DataNode1:2181,DataNode2:2181" > } *Start Drill * *Start mode* : git bash command l

error starting sqline in distributed mode on windows server 2012

Hi, C:\apache-drill-1.11.0\bin>sqlline.bat -u > "jdbc:drill:zk=:2181,:2181,:2181" > DRILL_ARGS - " -u jdbc:drill:zk=:2181,:2181,:2181" > HADOOP_HOME not detected... > HBASE_HOME not detected... > Calculating Drill classpath... > No active Drillbit endpoint found from ZooKeeper. Check connection >

set up Apache Drill on Windows server in distributed mode

Hi, Has anybody set up Apache Drill cluster in Windows machines/servers? Thanks, Divya

Re: set up Apache Drill on Windows server in distributed mode

ode > because no one appears to have tried for more than 1 Drillbit. > > That said, you should be able to run Apache Drill in a distributed mode as > well, since it is Java-based and would not need to rely on anything more > than a Zookeeper. > > -Original Message- >

Re: Blog for Apache Drill

Me too can help by inputting the issues which I encounter when working with Drill. Thanks, Divya On 11 August 2017 at 01:42, Charles Givre wrote: > Hi Saurabh, > I’d contribute or otherwise help out. I’m particularly interested in > learning about how people are using Drill and what we can do

Re: set up Apache Drill on Windows server in distributed mode

during startup, the Drillbits > register with the Zookeeper, while a JDBC client like SQLLine would look up > the list of Drillbits in ZK to connect to one of them or directly > connect to the Drillbit (default port in this case is 31010). > > You'll need to figure out w

UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema changes

Hi, I am getting below error : > UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema > changes Fragment 0:0 *Some background to understand the error scenario : * I have data saved in parquet files in multidirectory structure. One of the column of the table is empty values so I

Re: UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema changes

umn has empty values try > using null instead of zero, because 0 (zero) is not null. > > > CASE WHEN `Capacity` = '' THEN CAST(null AS integer) ELSE CAST(`Capacity` > AS integer) > > END AS `Capacity` > > > Thanks, > > Khurram > > __

Re: UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema changes

rue; > > > Thanks, > > Khurram > > ____ > From: Divya Gehlot > Sent: Monday, August 14, 2017 3:06:57 PM > To: user@drill.apache.org > Subject: Re: UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support > schema changes > > forgot to menti

stop a long running query

Hi, I have long running query which I would like to stop . But the issue the query I ran is through Tableau Custome SQL interface. In tableau *web console ->Profile ->Running queries * When I click on the user running the query I could see the below error message: > { > "errorMessage" : "VALIDATI

Query Optimization

Hi, I have data in parquet file format . when I run the query the data and see the execution plan I could see following statistics > TOTAL FRAGMENTS: 1 >> DURATION: 01 min 0.233 sec >> PLANNING: 59.818 sec >> QUEUED: Not Available >> EXECUTION: 0.415 sec > > As its a paquet file format I tried en

Re: Query Optimization

happening ? You might have to > turn on some debugs if needed. > BTW, what version of Drill are you running ? > > Thanks, > Padma > > > > On Aug 16, 2017, at 8:15 PM, Divya Gehlot > wrote: > > > > Hi, > > I have data in parquet file format . > > w

Re: Query Optimization

ter ? > Execution time is increased most likely because partition pruning is not > happening. > Did you get a chance to look at the logs ? That might give some clues. > > Thanks, > Padma > > > > On Aug 16, 2017, at 9:32 PM, Divya Gehlot > wrote: > > > >

Re: Query Optimization

ean it scans each and every files and get the results ? I dont have access to logs now . Thanks, Divya On 17 August 2017 at 13:48, Divya Gehlot wrote: > Hi, > Another observation is > My query had where conditions based on the partition values > Before Metadata refresh - Its re

Merge and save parquet files in Drill

Hi, I have CTAS with partition on 4 columns and when I save it it creates lots of small files ~ 102290 where size of each file is in KBs . My queries are : 1.Does the lots of small files reduce the performance while reading the data in Drill ? 2.If yes ,How can I merge the small parquet files ?

Re: Merge and save parquet files in Drill

bit. > > Yes a large number of files does affect the query performance, using > metadata caching helps improve the query planning time a lot. > > --Andries > > > On 8/16/17, 11:12 PM, "Divya Gehlot" wrote: > > Hi, > I have CTAS with partition on 4 c

Re: Query Optimization

exactly the same, then it should not do that. > Also, check if you can partition in a way that will not create so many > files in the > first place. > > Thanks, > Padma > > > > On Aug 16, 2017, at 10:54 PM, Divya Gehlot > wrote: > > > > Hi, > > An

Re: Query Optimization

d the query plan. > > To get the query plan, execute EXPLAIN PLAN FOR ; > > > Thanks, > > Khurram > > > From: Divya Gehlot mailto:divya.htco...@gmail.com > >> > Sent: Friday, August 18, 2017 7:15:18 AM > To: user@drill.apache.org&

Re: Drill selects column with the same name of a different table

Hi, At times if during the join if the columns names are same the drill suffix zero for second column name . like in your case it could be name ,name0, > Can you please do a select * on join tables and check the column headers ? Thanks, Divya On 21 August 2017 at 22:04, Hielke Hoeve wrote: >

Re: Drill selects column with the same name of a different table

You dont have to go ding into Drill config just run the select * query on the joined data instead of selecting individual column. Thanks, Divya On 22 August 2017 at 19:18, Hielke Hoeve wrote: > Hi everyone, > > Sorry for not responding but I am not receiving your replies in my > mailbox. Lucki

Re: Query Optimization

dd as much information as possible. > A sample dataset, how you are creating the table (i.e. partition info), > logs, query profiles will be very helpful. > > Thanks, > Padma > > > > On Aug 20, 2017, at 7:03 PM, Divya Gehlot > wrote: > > > > Hi , > > Y

Re: Best way to partition the data

Hi, I also face the similar issue like JinFeng when querying the data on columns year,month and day which were partioning column too . It created lots of small files and querying took almost 20x times more than reading non partiioning data . Another issue I faced when I query the data by just f

error accessing sqlline in distributed mode

Hi, I have Apache Drill installed and running in distributed mode . I am trying to run queries in sqlline as below : > bin/sqlline –u jdbc:drill:zk=,,:5181 > sqlline> SELECT version FROM sys.version; > No current connection am I missing anything here ? Appreciate the help ! Thanks, Divya

handle special characters in query in bash script

Hi, I have written a sql query in bash script when I try to run I am getting error Below is script : > SELECT > SUBSTR(CAST(`columns`[2] AS VARCHAR(50)), 1, 6 + POSITION('.' IN > `SUBSTR`(CAST(`columns`[2] AS VARCHAR(50)), 8))) AS `Col2`, > TO_NUMBER(`columns`[3], '##') A

need help to decrypt error code

Hi, I have 18 MB csv file and when I try to CTAS as parquet table it throws below error SYSTEM ERROR: IllegalArgumentException: length: -44154 (expected: >= 0) Appreciate the help ! Thanks, Divya

Re: need help to decrypt error code

21:56, Kunal Khatua wrote: > This appears to be the brief client side error. > > What does the Drillbit 's log show in the stacktrace? > ________ > From: Divya Gehlot > Sent: Thursday, September 28, 2017 12:43:38 AM > To: user@drill.apache.org >

error reading csv file with utf-8 encoding

Hi , Created a parquet table from 18 MB csv file When read the table I am getting below error : SYSTEM ERROR: DrillRuntimeException: Unexpected byte 0x92 at position 41053 > encountered while decoding UTF8 string Appreciate the help ! Thanks, Divya

strange issue with select query

Hi, Reading a parquet table Strange issue with the select queries 1. when run > select * from table_name It displays the result set 2 . when run > "select `column name1`,`column name2` from table_name It displays the result set 3.When run > Select CAST(`column name1` AS VARCHAR(100)) from t

Time out error when query from BI tool like tableau

Hi, I am accessing Drill multi directory parquet tables in Tableau server and when I try to access it I am getting below error : prepared statement took longer than 1 ms. Query cancellation > requested. Retry after changing the option > 'prepare.statement.create_timeout_ms' to a higher value.

Re: S3 with mixed files

Hi Daniel, Can you try select * from ibios3.root.`./tracking/tracking.log`; instead of select * from ibios3.root.`tracking/tracking.log`; Thanks, Divya On 20 October 2017 at 13:13, Daniel McQuillen wrote: > Thanks for your help, Padma! > > Just tried the following, per your suggestion: > > sel

Re: Benchmark numbers using Drill

Yes a very good info which helps a lots of ppl like me who is using Drill as one of their production environment cant we share this information as recommendation to Dril users on the Apache Drill KB ? On 20 October 2017 at 01:58, Saurabh Mahapatra wrote: > I do not think you will get such inform

Re: describe query support? (catalog metadata, etc)

@Charles : when you read csv files can casting and get the data type as per your requirements Hope I answer what you asked for :) HTH Thanks, Divya On 20 October 2017 at 01:42, Charles Givre wrote: > Hi Alfredo, > When I was trying to get Drill to work with various BI tools, all I really > nee

Apache Drill connection issue in tableau

Hi , I am facing a strange Drill connection issue. I am connecting to Drill through Tableau. I have published coupled of reports to tableau server. When I connect to Drill thorugh tableau desktop and tableau server at same time it becomes unresponding.I keeping getting "connection time out error"

Re: Apache Drill connection issue in tableau

; to your drill-override.conf > > > > drill.exec.rpc.user.timeout: 30 > > Thanks, > Tim > > > > From: Divya Gehlot > Sent: Tuesday, October 31, 2017 12:26:55 AM > To: user@drill.apache.org > Subject: Apache Drill connection issue in tableau > > Hi

RPC error when accesing Drill through tableau

Hi, I am getting protocol disconnected error in tableau. When checked the drill logs I could see below > 2017-11-03 07:51:52,798 [BitServer-4] WARN > o.a.drill.exec.work.foreman.Foreman - Dropping request to move to COMPLETED > state as query is already at CANCELED state (which is terminal). > 201

Re: RPC error when accesing Drill through tableau

orer 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 12:57 AM, Divya Gehlot divy

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 whe

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

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

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

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 Janua

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: 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

Re: convert epoch time stamp to timestamp

:56.0 | > ++ > 1 row selected (0.461 seconds) > > > Thanks, > > Arjun > > > > From: Divya Gehlot > Sent: Monday, January 15, 2018 12:46 PM > To: user@drill.apache.org > Subject: Re: convert epoch time stamp

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 t

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: Channel closed exception

ad 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 > wrote: > > > Hi, > > At times my dril

Re: Channel closed exception

might not have the same > problem. > > On 3/19/2018 3:57:33 AM, Divya Gehlot 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 ? > > > > Thanks, > Divya > > On 15

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 you can help me please on a issue I am h

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 con

Re: tableau drill connection - handshake time out error

n 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, > > Rob

Re: tableau drill connection - handshake time out error

22:06, Andries Engelbrecht 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:24 AM, "Divya G

Re: tableau drill connection - handshake time out error

> > > Thanks, > Sorabh > > ____ > From: Divya Gehlot > Sent: Wednesday, May 2, 2018 9:23:45 PM > To: user@drill.apache.org > Subject: Re: tableau drill connection - handshake time out error > > Hi , > Facing strange issue . > Apache Drill is c

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 m

Re: tableau drill connection - handshake time out error

error which you are seeing on client side ? Also can > you try enable logging [1] for ODBC driver to see if it provides any > other information. > > > [1]: https://docs.microsoft.com/en-us/sql/odbc/admin/ > setting-tracing-options?view=sql-server-2017 > > > Thanks, > S

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 o

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

181,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 > wrote: > > > Hi, > > I am trying to access Drill through Sqlline ,I am getting below err

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: is there any way to download the data through Drill Web UI?

at > > > > Kind regards > > Vitalii > > > > > > On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht < > aengelbre...@mapr.com> > > wrote: > > > >> You can look at using the REST API to send a query and receive the > results > >> ba

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 - handsha

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 > Drill in 10 Minutes tutorial, and h

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: 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 s

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

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 ] ] Erro

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`, `t`.`resul

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 changi

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: Read complex json file gives list type doesn't support different data types

> 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&

  1   2   >