oops, sorry, I now see you prefaced the FROM with cp. Forget that. Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn
On Thu, Dec 31, 2015 at 2:52 PM, Kristine Hahn <kh...@maprtech.com> wrote: > Please try USE cp; before the select statement. Drill uses the dfs storage > plugin, not the cp storage plugin, by default. > > Kristine Hahn > Sr. Technical Writer > 415-497-8107 @krishahn skype:krishahn > > > On Thu, Dec 31, 2015 at 2:50 PM, Peder Jakobsen | gmail < > pjakob...@gmail.com> wrote: > >> I spoke too soon, perhaps (but it must be a simple I/O issue on startup, >> no?) >> >> >> C:\devel\apache-drill-1.4.0\bin>sqlline.bat -u "jdbc:drill:zk=local" >> DRILL_ARGS - " -u jdbc:drill:zk=local" >> HADOOP_HOME not detected... >> HBASE_HOME not detected... >> Calculating Drill classpath... >> Dec 31, 2015 5:39:53 PM org.glassfish.jersey.server.ApplicationHandler >> initialize >> INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 >> 01:25:26... >> apache drill 1.4.0 >> "just drill it" >> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 3; >> Dec 31, 2015 5:46:55 PM >> org.apache.calcite.sql.validate.SqlValidatorException <init> >> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table >> 'cp.employee.json' not found >> Dec 31, 2015 5:46:55 PM org.apache.calcite.runtime.CalciteException <init> >> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, >> column 15 to line 1, column 16: Table 'cp.employee.json' not found >> Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 16: >> Table >> 'cp.employee.json' not found >> >> >> [Error Id: 9d6af232-fc40-40ec-8a2a-8d082923b776 on Funky:31010] >> (state=,code=0) >> >> On Thu, Dec 31, 2015 at 5:34 PM, Peder Jakobsen | gmail < >> pjakob...@gmail.com >> > wrote: >> >> > OUCH that hurts. Sometimes you get lucky when you jump in a haystack >> and >> > get pricked by the missing needle right away. >> > >> > So I copied hive.sys.drill from my tmp folder in linux to windows, and >> > wow, now it seems to work. Would you allow me the honour to fix this >> bug >> > and commit the changes even though I have not programmed in Java since >> 2003 >> > ? ;) I can't imagine that I/O in java has changed all that much. >> > >> > Peder :) >> > >> > >> > >> > On Thu, Dec 31, 2015 at 5:30 PM, Peder Jakobsen | gmail < >> > pjakob...@gmail.com> wrote: >> > >> >> No. I've tried this many times. >> >> >> >> So at startup, it's supposed to create these files which it needs? >> >> >> >> It seems to do so in my linux install. I will try to copy those files >> >> over and see if I get another error. Needle in a haystack debugging. >> :) >> >> >> >> P. >> >> >> >> On Thu, Dec 31, 2015 at 5:27 PM, Nathan Griffith <ngriff...@dremio.com >> > >> >> wrote: >> >> >> >>> Ah! Okay. I remember it making temporary stuff *somewhere* within >> >>> windows. >> >>> >> >>> If I recall correctly, a bad set of temporary files once gave me the >> >>> exact same issue, which was fixed by deleting them. But apparently >> >>> this is isnt helping with your case? >> >>> >> >>> On Thu, Dec 31, 2015 at 2:22 PM, Peder Jakobsen | gmail >> >>> <pjakob...@gmail.com> wrote: >> >>> > OK, at startup, Drill creates an empty file called hive.sys.drill >> >>> that's >> >>> > located in C:\tmp\drill\sys.storage_plugins >> >>> > >> >>> > Perhaps it's not surprising that we get "Unable to deserialize >> >>> > "/tmp/drill/sys.storage_plugins/hive.sys.drill" (state=,code=0)" >> >>> > considering that this file appears to be empty. >> >>> > >> >>> > On Linux, lots of stuff is included in this drill path: profiles, >> >>> > sys.options & sys.storage_plugins >> >>> > >> >>> > Hope this helps >> >>> > >> >>> > P. >> >>> > >> >>> > On Thu, Dec 31, 2015 at 5:13 PM, Peder Jakobsen | gmail < >> >>> pjakob...@gmail.com >> >>> >> wrote: >> >>> > >> >>> >> I deleted everything in C:\Windows\Temp. Note, when I start drill >> >>> >> again, nothing gets created in there. I will now try to search >> the >> >>> >> machine for any files that may have been created at the time of >> >>> startup. >> >>> >> Standy by.. >> >>> >> >> >>> >> On Thu, Dec 31, 2015 at 5:10 PM, Nathan Griffith < >> >>> ngriff...@dremio.com> >> >>> >> wrote: >> >>> >> >> >>> >>> Hey Peder, >> >>> >>> >> >>> >>> What's in your C:\Windows\Temp directory? Is there something that >> >>> >>> looks like it's from Drill? If there is, try deleting it and >> running >> >>> >>> again. >> >>> >>> >> >>> >>> --Nathan >> >>> >>> >> >>> >>> On Thu, Dec 31, 2015 at 1:53 PM, Peder Jakobsen | gmail >> >>> >>> <pjakob...@gmail.com> wrote: >> >>> >>> > Hi Tomer and Jacques, >> >>> >>> > >> >>> >>> > I tried those instructions to the letter. I still get the same >> >>> java >> >>> >>> > Runtime Exception "Uable to deserialize >> >>> >>> > "/tmp/drill/sys.storage_plugins/hive.sys.drill" >> >>> >>> > >> >>> >>> > Let me know if you need the full stack trace, although this >> should >> >>> be >> >>> >>> easy >> >>> >>> > to replicate. I simply installed a clean version of Windows 7 >> on >> >>> >>> > VirtualBox, and followed all instructions from Drill >> documentation >> >>> and >> >>> >>> > Tomers suggestions. I can't imagine why it would work on any >> >>> other >> >>> >>> > windows OS unless some other tweak is done somewhere. >> >>> >>> > >> >>> >>> > P. >> >>> >>> > >> >>> >>> > >> >>> >>> > On Thu, Dec 31, 2015 at 1:22 PM, Jacques Nadeau < >> >>> jacq...@dremio.com> >> >>> >>> wrote: >> >>> >>> > >> >>> >>> >> Just to clarify, Drill doesn't require Hadoop to be installed. >> >>> Drill >> >>> >>> does >> >>> >>> >> include some Hadoop code since it uses some Hadoop >> functionality >> >>> under >> >>> >>> the >> >>> >>> >> hood as a library (even in non-hadoop installs). Drill should >> be >> >>> >>> including >> >>> >>> >> the required windows executables/dlls in the distribution >> folder >> >>> (for >> >>> >>> using >> >>> >>> >> hadoop as a library) and this should be transparent to you. Let >> >>> us know >> >>> >>> >> what happens when you follow the link that Tomer suggested. >> >>> >>> >> >> >>> >>> >> -- >> >>> >>> >> Jacques Nadeau >> >>> >>> >> CTO and Co-Founder, Dremio >> >>> >>> >> >> >>> >>> >> On Thu, Dec 31, 2015 at 10:14 AM, Tomer Shiran < >> >>> tshi...@dremio.com> >> >>> >>> wrote: >> >>> >>> >> >> >>> >>> >> > No. Drill does not depend on Hadoop >> >>> >>> >> > >> >>> >>> >> > Can you try these instructions and see if they work: >> >>> >>> >> > >> >>> >>> >> > >> >>> >>> >> >>> >> http://www.dremio.com/blog/installing-apache-drill-on-microsoft-windows/ >> >>> >>> >> > >> >>> >>> >> > >> >>> >>> >> > > On Dec 31, 2015, at 11:32 AM, Peder Jakobsen | gmail < >> >>> >>> >> > pjakob...@gmail.com> wrote: >> >>> >>> >> > > >> >>> >>> >> > > Hi, does hadoop have to be installed in order to run apache >> >>> drill >> >>> >>> on >> >>> >>> >> > > windows? >> >>> >>> >> > > >> >>> >>> >> > > So far, I'm 3 hours into "Run Apache Drill in 10 Minutes", >> and >> >>> >>> still no >> >>> >>> >> > > luck. Once I figure it out, I will update the >> documentation >> >>> for >> >>> >>> >> windows >> >>> >>> >> > if >> >>> >>> >> > > you like. >> >>> >>> >> > > >> >>> >>> >> > > Thanks, >> >>> >>> >> > > >> >>> >>> >> > > Peder J. >> >>> >>> >> > >> >>> >>> >> >> >>> >>> >> >>> >> >> >>> >> >> >>> >> >> >> >> >> > >> > >