Indeed. Happy new year On Dec 31, 2015 4:07 PM, "Peder Jakobsen | gmail" <[email protected]> wrote:
> Hi Jacques, I will try it tomorrow. It's time have some Veuve Clicquot. > :) > > Thank you for all your help today. Happy New Year to everyone. > > Peder J. > > On Thu, Dec 31, 2015 at 6:16 PM, Jacques Nadeau <[email protected]> > 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 < > > [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. > > > >>> >>> >> > > > > >>> >>> >> > > > >>> >>> > > > >>> >> > > > >>> >> > > > >>> > > > >> > > > >> > > > > > > > > > >
