Re: Custom Functions

2015-06-25 Thread Ted Dunning
Alok, Can you put your UDF in a git repo that I can access? I am happy to build you a modified version in exchange for you helping to document the somewhat obscure constraints on how a UDF needs to be written. Sound like a good trade? n On Thu, Jun 25, 2015 at 3:21 PM, Alok Tanna wrote: > I

Re: drill configuration setting - rows overwriting one another

2015-06-25 Thread Ted Dunning
Could also be a terminal setting bug. On Thu, Jun 25, 2015 at 9:24 PM, Jacques Nadeau wrote: > Sounds like a bug in sqlline's output format. Try changing the output > format from table to csv to work around this. > On Jun 25, 2015 1:13 PM, "Jim Scott" wrote: > > > Can anyone point me to a co

Re: drill configuration setting - rows overwriting one another

2015-06-25 Thread Jacques Nadeau
Sounds like a bug in sqlline's output format. Try changing the output format from table to csv to work around this. On Jun 25, 2015 1:13 PM, "Jim Scott" wrote: > Can anyone point me to a configuration setting (not maxwidth) that can > prevent having the drill output in the CLI from overwriting d

Re: drill configuration setting - rows overwriting one another

2015-06-25 Thread Ted Dunning
Not an answer, but sqlline lets you log results to a file. You can probably then view the file using a better tool. On Thu, Jun 25, 2015 at 4:12 PM, Jim Scott wrote: > Can anyone point me to a configuration setting (not maxwidth) that can > prevent having the drill output in the CLI from ov

Re: To EMRFS or not to EMRFS?

2015-06-25 Thread Paul Mogren
"When consistent view is enabled, Amazon EMR also has better performance when listing Amazon S3 prefixes with over 10,000 objects. In fact, we’ve seen a 5x increase in list performance on prefixes with over 1 million objects. This speed-up is due to using the EMRFS metadata, which is required for c

drill configuration setting - rows overwriting one another

2015-06-25 Thread Jim Scott
Can anyone point me to a configuration setting (not maxwidth) that can prevent having the drill output in the CLI from overwriting data that is already in a row? (i.e. the data is not wrapping to a new line) I have a query that when I select all the columns, the data in the columns at the end over

Re: Custom Functions

2015-06-25 Thread Alok Tanna
I got the full JDK version now I am getting below errors while building the JAR file [root@ip-172-31-34-166 simple-drill-functions]# /home/ec2-user/apache-maven-3.3. 3/bin/mvn package [INFO] Scanning for projects... [INFO] [INFO] ---

ApacheCON EU HBase Track Submissions

2015-06-25 Thread Nick Dimiduk
Hello developers, users, speakers, In honor of ApacheCON's inaugural "Apache: Big Data" event, I'm hoping to see a "HBase: NoSQL + SQL" track come together. The idea is to showcase the growing ecosystem of applications and tools built on top of and around Apache HBase. To have a track, we need con

Re: Using Azure WASB

2015-06-25 Thread Daniel Haviv
Thanks, that did the work :) On Thu, Jun 25, 2015 at 5:13 PM, David Tucker wrote: > You'll need to make sure of two things : > WASB jars are included by default with HDFS 2.6 and later. If you're > using an earlier version (or simply a stand-alone installation of Drill), > you'll need to grab

Re: Missing artifact org.apache.drill.exec:drill-java-exec:jar:1.0.0

2015-06-25 Thread Ranjit Reddy
There is another thread for same issue. Solution for now is to install the dependency locally since it is not in the central repo.  To install locally, run the following command:mvn install:install-file -Dfile=/opt/apache-drill-1.0.0/jars/drill-java-exec-1.0.0-rebuffed.jar -DgroupId=org.apache.dri

Re: Custom Functions

2015-06-25 Thread Abdel Hakim Deneche
Hi Alok, the mailing list doesn't allow attached files, can you please copy/paste your drill-override.conf, or at least the line that you edited ? Thanks! On Thu, Jun 25, 2015 at 5:47 AM, Alok Tanna wrote: > I got my Jar working . Thank you ! > > After this I tried editing my drill-override.co

Re: Using Azure WASB

2015-06-25 Thread David Tucker
You'll need to make sure of two things : WASB jars are included by default with HDFS 2.6 and later. If you're using an earlier version (or simply a stand-alone installation of Drill), you'll need to grab the jar files and put them in the class path. Your Azure credentials must be in core-site.x

Re: Custom Functions

2015-06-25 Thread Alok Tanna
I got my Jar working . Thank you ! After this I tried editing my drill-override.conf file and I am getting below error when I start my drill [root@ip-172-31-34-166 apache-drill-1.0.0]# bin/drill-embedded drill-override.conf: 25: Cannot concatenate object or list with a non-object-or-list, SimpleC

Using Azure WASB

2015-06-25 Thread Daniel Haviv
Hi, I'm trying to query Azure's blob storage but when I'm trying to query a hive table that resided on it I'm getting: java.io.IOException: No FileSystem for schem: wasb The FAQ clearly states that Azure Blob storage is supported: - *Cloud storage*: Amazon S3, Google Cloud Storage, Azure Blog

Re: Missing artifact org.apache.drill.exec:drill-java-exec:jar:1.0.0

2015-06-25 Thread Rajkumar Singh
Please clone the drill-1.0.0 on your local machine and then build it using mvn clean install -DskipTests=true, which will install the required artifacts on your local maven repo. Rajkumar Singh MapR Technologies > On Jun 25, 2015, at 2:33 PM, Devender Yadav > wrote: > > As metioned in docum

Missing artifact org.apache.drill.exec:drill-java-exec:jar:1.0.0

2015-06-25 Thread Devender Yadav
As metioned in documentation (http://drill.apache.org/docs/develop-a-simple-function/?) , I used following dependency: org.apache.drill.exec drill-java-exec 1.0.0 While building maven project, I got error: Missing artifact org.apache.drill.exec:drill-java-exec:jar:1.0.0 How to resolve thi