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 <[email protected] > 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 < > [email protected] > > 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 < > > [email protected]> 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 <[email protected]> > >> 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 > >>> <[email protected]> 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 < > >>> [email protected] > >>> >> 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 < > >>> [email protected]> > >>> >> 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 > >>> >>> <[email protected]> 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 < > >>> [email protected]> > >>> >>> 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 < > >>> [email protected]> > >>> >>> 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 < > >>> >>> >> > [email protected]> 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. > >>> >>> >> > > >>> >>> >> > >>> >>> > >>> >> > >>> >> > >>> > >> > >> > > >
