[DRILL-4042] Unable to run sqlline in embedded mode on Windows

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 1.3.0
• Component/s: Client - CLI
• Assignee: Aditya Kishore
• Reporter: Aditya Kishore
• Created: 05/Nov/15 23:35
• Updated: 06/Nov/15 23:04
• Resolved: 06/Nov/15 23:04

Description

Hadoop binaries (hadoop.dll, winutils.exe) bundled with Drill are out of date and needs to be rebuilt with Hadoop 2.7.

Running sqlline in embedded mode hangs after any command.

$ ./bin/sqlline -u jdbc:drill:zk=local
Nov 05, 2015 3:23:19 PM org.glassfish.jersey.server.ApplicationHandler initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
apache drill 1.3.0-SNAPSHOT
"drill baby drill"
0: jdbc:drill:zk=local> use dfs;
Exception in thread "drill-executor-2" java.lang.UnsatisfiedLinkError: org.apache.hadoop.io.nativeio.NativeIO$Windows.createFileWithMode0(Ljava/lang/String;JJJI)Ljava/io/FileDescriptor;
        at org.apache.hadoop.io.nativeio.NativeIO$Windows.createFileWithMode0(Native Method)
        at org.apache.hadoop.io.nativeio.NativeIO$Windows.createFileOutputStreamWithMode(NativeIO.java:559)
        at org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.<init>(RawLocalFileSystem.java:219)
        at org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.<init>(RawLocalFileSystem.java:209)
        at org.apache.hadoop.fs.RawLocalFileSystem.createOutputStreamWithMode(RawLocalFileSystem.java:305)
        at org.apache.hadoop.fs.RawLocalFileSystem.create(RawLocalFileSystem.java:294)
        at org.apache.hadoop.fs.RawLocalFileSystem.create(RawLocalFileSystem.java:326)
        at org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.<init>(ChecksumFileSystem.java:393)
        at org.apache.hadoop.fs.ChecksumFileSystem.create(ChecksumFileSystem.java:456)
        at org.apache.hadoop.fs.ChecksumFileSystem.create(ChecksumFileSystem.java:435)
        at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:909)
        at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:890)
        at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:787)
        at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:776)
        at org.apache.drill.exec.store.dfs.DrillFileSystem.create(DrillFileSystem.java:159)
        at org.apache.drill.exec.store.sys.local.FilePStore.put(FilePStore.java:145)
        at org.apache.drill.exec.work.foreman.QueryManager.writeFinalProfile(QueryManager.java:307)
        at org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:749)
        at org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:841)
        at org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:786)
        at org.apache.drill.common.EventProcessor.sendEvent(EventProcessor.java:73)
        at org.apache.drill.exec.work.foreman.Foreman$StateSwitch.moveToState(Foreman.java:788)
        at org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:894)
        at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:255)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)