Installing/Running Drill (Embedded) as Windows Service

["Leyne, Sean" <Se...@BroadViewSoftware.com>]

Does anyone have instructions on how to get Drill installed/running as a Windows Service?

Thanks


Sean

Re: Installing/Running Drill (Embedded) as Windows Service

[Paul Rogers <pa...@yahoo.com.INVALID>]

Hi Sean,

I was hoping someone who uses Windows would answer. I'll take a stab.

First, if you need a service, you'll want to install the Drill server (not embedded) as a service. Embedded Drill runs inside the command-line Sqlline, which is not very useful when running as a service.

Checking the scripts in $DRILL_HOME/bin, it looks like there is no Windows batch file to start Drill, only a Linux shell script. So, you'd have to create the batch file. Fully recreating drillbit.sh would be a bit of a project. But, if you have access to a Linux machine (just run a VM) or a Mac, there may be a shortcut. Get your Linux/Mac Drillbit to start. Then, run the script like this:

$DRILL_HOME/bin/drillbit.sh debug

This command, instead of launching Drill, will show the environment and command line it would use if it were to actually launch Drill. You can ignore all the rest of drillbit.sh; you just need a batch file (or Powershell script, or whatever) to set up the environment and issue the Java launch command.

Once you have that replicated on Windows, you can then wrap it in a service (the details of which I've not messed with for years.)

All this said, I suspect one reason we do not provide a Drillbit launch script is that some of Drill's networking may be Unix-specific (if I remember what someone told me years ago.) Still, worth a try. 


Remember that if you launch a Drillbit, you also need ZK [1]. ZK becomes the persistent store for things like your plugins and system options.


Might it be easier to just use a Linux box (or VM) to run Drill and ZK? That way you are going down the common path. Sill, if you get Windows working, please file a JIRA with your solution so we can get it into the project to make this easier in future releases.


Thanks,
- Paul

[1] https://medium.com/@shaaslam/installing-apache-zookeeper-on-windows-45eda303e835



 

    On Thursday, February 13, 2020, 10:22:30 AM PST, Leyne, Sean <se...@broadviewsoftware.com> wrote:  
 
 
Does anyone have instructions on how to get Drill installed/running as a Windows Service?

Thanks


Sean