null pointer at AbstractSqlAccessor.getString()

2016-01-04 Thread Devender Yadav
Hi, I am testing Drill JDBC. While fetching results, I got null pointer at org.apache.drill.exec.vector.accessor.AbstractSqlAccessor.getString(AbstractSqlAccessor.java:101) Below mentioned method is throwing null pointer becaue getObject(rowOffset) returns null for null values & null.toS

Null Return

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

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Jacques Nadeau
It sounds like the docs need to be updated to state that iODBC must be installed on Mac. -- Jacques Nadeau CTO and Co-Founder, Dremio On Mon, Jan 4, 2016 at 1:30 PM, George Chow wrote: > To clarify: iODBC is a driver manager. > > OS X does not ship with a complete/up-to-date driver manager. The

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread George Chow
To clarify: iODBC is a driver manager. OS X does not ship with a complete/up-to-date driver manager. The driver manager dependency is a requirement for ODBC on any platform. George On Mon, Jan 4, 2016 at 11:59 AM, Andries Engelbrecht < aengelbre...@maprtech.com> wrote: > The dmg package for OS

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Andries Engelbrecht
The dmg package for OS X includes Drill explorer. https://drill.apache.org/docs/installing-the-driver-on-mac-os-x/ And as Paul mentioned it requires iODBC to be installed on OS X. --Andries > On Jan 4, 2016, at 11:53 AM, Matt

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Paul Ilechko
OSX here: http://drill.apache.org/docs/installing-the-driver-on-mac-os-x/ But it assumes that you have already installed iODBC, as of last time I used it. On Mon, Jan 4, 2016 at 2:53 PM, Matt wrote: > That section refers only to Windows? Are there OSX specific docs for > Explorer? > > Sent from

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Matt
That section refers only to Windows? Are there OSX specific docs for Explorer? Sent from my iPhone > On Jan 4, 2016, at 2:12 PM, Kristine Hahn wrote: > > Please see step 1 of > > http://drill.apache.org/docs/installing-the-driver-on-windows/#step-3-verify-the-installation > > "Installing the

Re: ODBC in Virtual Box connects to Drill on host Unix system?

2016-01-04 Thread Tomer Shiran
Got it I haven't tried this, but I wonder if you could use the JDBC driver via https://pypi.python.org/pypi/JayDeBeApi/ On Mon, Jan 4, 2016 at 11:23 AM, Peder Jakobsen | gmail wrote: > Hi Tomer, > > My BI "tools" are iPython and Pandas. Occasionally I use R! Studio and > Shiny. > > I recently

Re: ODBC in Virtual Box connects to Drill on host Unix system?

2016-01-04 Thread Peder Jakobsen | gmail
Hi Tomer, My BI "tools" are iPython and Pandas. Occasionally I use R! Studio and Shiny. I recently got a licence for Tableau, so I run that in VirtualBox on Windows. Lots to learn there, so little time. ;) P. On Mon, Jan 4, 2016 at 12:50 PM, Tomer Shiran wrote: > Peder, > > What BI tool

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Kristine Hahn
Please see step 1 of http://drill.apache.org/docs/installing-the-driver-on-windows/#step-3-verify-the-installation "Installing the ODBC Administrator installs Drill Explorer and the Tableau TDC file." Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn On Mon, Jan 4, 2016

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Paul Ilechko
I had a similar problem when I first starting using the Drill Explorer, and the issues was that I had to install the iODBC driver, which did not come with Drill. You can get it here: http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads On Sun, Dec 27, 2015 at 10:53 PM, Peder Jakobsen | gmail

Re: Where is the Drill Explorer and / or docs on installing it?

2016-01-04 Thread Andries Engelbrecht
Peder, Drill Explorer typically installs with the ODBC driver. Did you install the ODBC driver on OS X? --Andries > On Dec 27, 2015, at 7:53 PM, Peder Jakobsen | gmail > wrote: > > Hi, > > The docs refer to the Drill Explorer, which for OS X is supposed to be > located in the Applications

Re: ODBC in Virtual Box connects to Drill on host Unix system?

2016-01-04 Thread Tomer Shiran
Peder, What BI tool are you running on Debian? Thanks, Tomer On Thu, Dec 31, 2015 at 8:40 AM, Peder Jakobsen | gmail wrote: > Hi Norris, > > Just discovered that the ODBC driver is only available for CentOS / Redhat > and SuSE, but not for Debian. It would be nice to have, given that > Debi

Re: "Already had POJO for id" Error In SQL - Join B/W Redshift and HDFS

2016-01-04 Thread Jacques Nadeau
I don't think it is a type variation change. Can you provide the EXPLAIN output of your query? This looks like it is an execution plan serialization bug. -- Jacques Nadeau CTO and Co-Founder, Dremio On Mon, Jan 4, 2016 at 8:12 AM, Andries Engelbrecht < aengelbre...@maprtech.com> wrote: > Perhaps

Re: "Already had POJO for id" Error In SQL - Join B/W Redshift and HDFS

2016-01-04 Thread Andries Engelbrecht
Perhaps check the data type of all the fields being used for the join. Select cvalue, TYPEOF(cvalue) from hdfs.. limit 10 and similar for tag_value on redshift. You can then do a predicate to find records where the data type may be different. where typeof() not like '' I believe there wa