Re: Drill & Caravel

I Hi Neeraja, I am interested in contributing if integration is not available. Kindly let me know Regards, Nirav On Thu, May 12, 2016 at 9:19 PM, Neeraja Rentachintala < nrentachint...@maprtech.com> wrote: > Hi Folks > > Caravel is nice visualization tool recently open sourced by airbnb. Did >

Scheduling of Drill Queries

Hi All, Do we have any tool which can schedule and organize drill query ? Something like oozie or azkaban for hadoop. Regards, Nirav

exception handling

Hi, We are processing user behavior data. some time same column consists different data type. some time JSON is mal-formed. Is there any way to manage this type of issues? Regards, Nirav

Re: Code too large

I had the same issue but till date even in version 1.6 it's there. I checked about JDK also. it would be great if we can solve this issue. Regards, Nirav On Thu, Mar 24, 2016 at 11:06 PM, Edmon Begoli wrote: > Here is the query: > > CREATE TABLE > cms.joe.`ALL_IP_HS_FINAL` > AS > SELECT CASE W

RE: Help with error message...

between), does the Drill JDBC driver (or drill-embedded server) have any > timeouts which can be increased? > > Interestingly, the client side (JDBC) doesn't notice that the server side > (Drill-embedded) has disconnected. > > ---Paul > > > -Original Message-

Re: Help with error message...

>From the logs it looks like network drop between nodes. If it fails on exact time say 10 min than check with firewall settings. On Feb 10, 2016 12:27 AM, "Paul Friedman" wrote: > Hello... > > I'm executing a long-running Drill (1.4) query (4-10mins) called via JDBC > from Talend and sometimes I'

Re: Issue in developing UDF

el > like you need it: > > > http://www.dremio.com/blog/querying-google-analytics-json-with-a-custom-sql-function/ > > Best, > Nathan > > On Sat, Jan 9, 2016 at 6:40 AM, Nirav Shah > wrote: > > Thanks Nathan for spending time on this issue. > > > > I h

Re: Issue in developing UDF

you have > a '/src/main/resources/drill-module.conf' file set up in your Maven > project for the UDF? If so, could you paste the text here? > > Best, > Nathan > > On Thu, Jan 7, 2016 at 11:03 PM, Nirav Shah > wrote: > > Sorry for delayed response. > > &g

Re: Issue in developing UDF

UDF in a query you get absolutely no error > messages from Drill? > > Also, the first part of this article > ( > http://www.dremio.com/blog/querying-google-analytics-json-with-a-custom-sql-function/ > ) > makes a good resource for telling Drill how to pick up on a new UDF. > &

Re: Null Return

ogic need to return null, I am not able to return null. Regards, Nirav On Wed, Jan 6, 2016 at 11:23 AM, Nirav Shah wrote: > Thanks Jacques. Appreciate your response. > > On Tue, Jan 5, 2016 at 10:59 PM, Jacques Nadeau > wrote: > >> The default behavior of Drill UDFs i

Issue in developing UDF

Hi , I am trying to extract info from user agent using WURFL libraries. I am not sure what's wrong I am doing here but it's not working and not giving any errors as well. I have put wurfl.xml in source folder and wurfl.jar to /jar/3rdparty/ *Code :* wurfl = new net.sourceforge.wurfl.

Re: Null Return

> [1] > > https://github.com/apache/drill/blob/master/exec/java-exec/src/main/codegen/templates/NullOperator.java > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Mon, Jan 4, 2016 at 8:04 PM, Nirav Shah > wrote: > > > Hi, > > May be this is sil

Null Return

Hi, May be this is silly question, Please let me know how to return null string from drill custom function. Regards, Nirav

Re: apache drill with mysql plugins creation

R u running on distributed mode? if yes than give hostname in place of localhost. Regards, Nirav On Tue, Dec 22, 2015 at 5:04 PM, Pankaj Pandey wrote: > Hi Team, > > First of all thanks a lot for introducing such a nice technology like > apache drill. > I am able to integrate Mongodb and Hbase

Re: issue with where clause

Can someone help me on this? On Mon, Dec 21, 2015 at 2:19 PM, Nirav Shah wrote: > Hi, > > > I am put up in strange situation. > > select count(distinct case when misfmg = 'true' then sessionid end) nnn > from t196 t where channelid = 2 and id = '/con

issue with where clause

Hi, I am put up in strange situation. select count(distinct case when misfmg = 'true' then sessionid end) nnn from t196 t where channelid = 2 and id = '/confirmDrop/btnYes/' and event='click'and mprizetype= 1 and mgametype = 'cfp' ; is running fine and giving expected results but sele

Re: Drill Query Problem

Thanks Nirav,I did the same. > > I think the limitation, in my case, is due to the number of cast / > regex_replace / substr etc to handle in the query, not the number of Kline > of code > > Boris > > > > > > Le Mercredi 9 décembre 2015 6h41, Nirav Shah <

Re: Querying a directory of json.gz Files in Drill 1.4

May be you can try In Drill 1.4 the same Query SELECT * FROM ` D:\DataFiles\2015\12\16\*.gz` ORDER BY ID LIMIT 10 it's working for me. Thanks, Nirav On Fri, Dec 18, 2015 at 12:46 AM, Holy Alexander < alexander.h...@derstandard.at> wrote: > I keep my JSON Files in local File system, such as > > D

Re: Connecting to S3 Drill 1.2

; looks something like this: > > "connection": "s3n://:@myname", > Kristine Hahn > Sr. Technical Writer > 415-497-8107 @krishahn skype:krishahn > > > > On Thu, Dec 10, 2015 at 11:38 PM, Nirav Shah > wrote: > > Hi All, > > > > I am tryin

Re: Local File Storage

I am sorry. I got the solution for this. On Mon, Dec 14, 2015 at 4:10 PM, Nirav Shah wrote: > Hi, > > > I am trying to create table from a log(local file system). table is > getting created and accessible with low row count, same query runs > successfully with higher row co

Local File Storage

Hi, I am trying to create table from a log(local file system). table is getting created and accessible with low row count, same query runs successfully with higher row count but than table is not accessible. create table t296 as select DateFunc(serverTime) serverTime, sessionid, logininfoid, ch

Connecting to S3 Drill 1.2

Hi All, I am trying to query from S3. I am getting below error. Error: SYSTEM ERROR: IllegalArgumentException: AWS Access Key ID and Secret Access Key must be specified as the username or password (respectively) of a s3 URL, or by setting the fs.s3.awsAccessKeyId or fs.s3.awsSecretAccessKey prop

Re: Drill Query Problem

ssion and is directly related to 1.3 > since I have already ran queries more than twice biggers (nearly 30K > characters) with 1.1 and 1.2 I'm downgrading to 1.2 > > Boris > > > > > Le Vendredi 4 décembre 2015 12h42, Nirav Shah < > nirav.s...@games24x7.com&

Re: Drill Query Problem

gt; Attachments typically don't work since Apache mailing lists strip them off. > > Can you put the query into a gist on github or some such? > > > > On Tue, Dec 8, 2015 at 1:09 PM, Nirav Shah > wrote: > > > Hi Abdel & Jacques > > I have observed that if we

Re: Announcing new committer: Kristine Hahn

Congrats and Appreciate your work Kris. On Fri, Dec 4, 2015 at 11:26 PM, Bob Rumsby wrote: > Congratulations Kris! > > On Fri, Dec 4, 2015 at 9:46 AM, Jason Altekruse > wrote: > > > Congrats Kris! Well deserved, the docs are looking great! > > > > On Fri, Dec 4, 2015 at 9:36 AM, Sudheesh Katka

Re: Drill Query Problem

2015 11:03 PM, "Abdel Hakim Deneche" wrote: > Hi Nirav, > > can you give us more information to help reproduce this issue ? > > thanks > > On Fri, Dec 4, 2015 at 3:42 AM, Nirav Shah > wrote: > > > Hello, > >

Drill Query Problem

Hello, I am getting below error while running big query. === Error: SYSTEM ERROR: CompileException: File 'org.apache.drill.exec.compile.DrillJavaFileObject[ProjectorGen2825.java]', Line 5799, Column 17: ProjectorGen2825.java:5799: error: code too large pub

Re: Insert to MySQL from Drill

drill with odbc or jdbc > > That's our plan for reporting at least. > > On Tuesday, December 1, 2015, Nirav Shah wrote: > > > Thanks Magnus, > > > > I am fetching data from log files --> Processing It --> want to move to > > MySql for reporting. > > &

Re: Insert to MySQL from Drill

unctionality as of now included in Apache Drill. It could be added > but focus has been on getting data from RDBMS in a convenient way rather > than moving data to RDBMS. > > Regards, > Magnus > > > 1 dec 2015 kl. 10:31 skrev Nirav Shah : > > > > Hi, > > >

Insert to MySQL from Drill

Hi, I am trying to move data from drill to mysql. is Insert/update allowed from drill to MySQL? If yes than how? Thanks in advance. Best, Nirav

Re: UDF

t; Karol Potocki > > > On Mon, Nov 30, 2015 at 8:56 AM, Nirav Shah > wrote: > > > I have written custom function to decode base64 string. > > I am getting issue if string is large it says "Index out of bound, max > > length is 256" > > > >

UDF

I have written custom function to decode base64 string. I am getting issue if string is large it says "Index out of bound, max length is 256" It seems I can return only 256 characters. Kindly help, Thanks in advance. Code : for reference @FunctionTemplate( name = "Base64Conv", scope = FunctionTe

Drill 1.2 Support for Hadoop 1.2

Hello, I am trying to run Drill 1.2 with Hadoop 1.2. Please let me know how to do the same. Best, Nirav

Stable Version

Hello Sir, We are planning to use Drill for our production env. I am not sure and able to get which version is stable and production ready. Kindly share details with thanks in advance. Regards, Nirav