Hi Jacques, yes when I copy all these files over manually from my Linux machine, everything works as expected on Windows 7 32bit. ODBC drivers and Drill explorer also work fine.
So what do you think is causing some of these files not to be written on startup? I have permission on all folders. For I/O operations in Drill at startup, ideally they'd be performed in a try catch block of some sort so that the program can exit gracefully with the appropriate feedback to the user, no? Let me know if I can be of further help in tracking down this problem. Peder J. On Thu, Dec 31, 2015 at 6:16 PM, Jacques Nadeau <jacq...@dremio.com> wrote: > 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 < > 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. > > >>> >>> >> > > > >>> >>> >> > > >>> >>> > > >>> >> > > >>> >> > > >>> > > >> > > >> > > > > > >