When Drill first starts up (or encounters an empty folder for embedded data), it will automatically create a number of new storage plugins. This includes cp and dfs, as well as disabled ones for hive, hbase, etc. It seems like your Drill is failing to do this. Since you only copied one plugin into your tmp directory (the hive plugin), you will not be able to query from the cp plugin. You would need to copy all the default plugins to get this working. This potentially provides a workaround but it doesn't indicate why Drill is failing to initialize these settings.
Can you possibly try this under the Administrator account if one exists? -- Jacques Nadeau CTO and Co-Founder, Dremio 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. > >>> >>> >> > > >>> >>> >> > >>> >>> > >>> >> > >>> >> > >>> > >> > >> > > >
