Skip to main content
SimilarExport ZIP
100%

Running Apcahe drill in Embedded mode on Win2012/2016

✓ Published0🌍 Public
HHugoberry
Last edited Jun 15, 2017
Created on Jun 15, 2017

This example shows a batch script that sets up and launches Apache Drill in embedded mode on Windows Server 2012 or 2016, creating the necessary directory structure and then starting the Drill shell. The script first creates user-profile subdirectories for Drill’s UDF registry, temporary files, and staging area, then takes ownership of the entire drill folder with `takeown`. It finally calls `sqlline.bat` with the JDBC URL `jdbc:drill:zk=local` to connect to the embedded ZooKeeper instance, launching an interactive SQL query interface. The visualization highlights the procedural steps of filesystem preparation and command invocation, relying on Windows command-line utilities (`mkdir`, `takeown`) and the Drill shell API.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 38a5a981b671bf09a7b9e76eeebc2294

This example visualizes a system-administration script that automates the setup of an Ambari-managed Hadoop cluster. The code shows a sequence of shell commands and configuration steps, including disabling SELinux and iptables, installing Java and MySQL, and configuring databases and users. It uses the `awk` utility to edit `sshd_config` and the `mysql` command-line client to create and grant privileges on the `ambaridb`, `hivedb`, and `ooziedb` databases. The visualization maps the script’s control flow and dependencies, likely through a node-link diagram, to illustrate how each step builds on prior ones.

FFred-Fan
52% match
Loading thumbnail…

Gist 44e95c5ae2e212c1b41485ea7e31e0c4

This example shows a Power Query function that connects to an embedded Power BI Desktop tabular model and retrieves session information from the `$SYSTEM.DISCOVER_SESSIONS` dynamic management view. The function first locates the most recently accessed user profile folder, reads the `msmdsrv.port.txt` file to obtain the local port number, then uses that port to list available databases via the `AnalysisServices.Databases` API. It selects the first database and executes the provided DAX query using `AnalysisServices.Database`. The code demonstrates dynamic file system traversal, port discovery, and parameterized Analysis Services queries within the Power Query M language.

HHugoberry
49% match
Loading thumbnail…

Gist 47d998760fa7271ac3157ce7d9555612

This example demonstrates how to query and load data from external sources using Power Query's OleDb.Query function, specifically connecting to a local CSV file and an XML catalog. The code shows two approaches: one using Microsoft's ACE OLEDB provider to read a delimited text file, and another using the MSDAOSP provider with MSXML2.DSOControl to access XML data. The visualization highlights the raw query definitions rather than rendering graphical output, focusing on the data-acquisition layer. Both queries reference file paths on the local system, with the CSV query specifying the file directory and the XML query pointing to a catalog file.

HHugoberry
48% match
Loading thumbnail…

Gist ea3c2dbb293136905194cfa2fa60cec8

This example demonstrates a shell script that automates the download and extraction of the latest Linux 64-bit geckodriver release. It shows how to query the GitHub API for the newest release, parse the download URL using `sed`, and pipe the archive directly into `tar` for extraction. The script relies on `curl` to fetch the API metadata and `wget` to retrieve the tarball, providing a one-liner workflow for staying up-to-date with geckodriver binaries.

HHerst
48% match
Loading thumbnail…

A little bit of JavaScript that helps setup a box on ScraperWiki for tools inside that box

This example shows how to automate the setup of a tool environment on ScraperWiki by writing a dataset URL to a file and launching an installation script. The code uses ScraperWiki’s `scraperwiki.exec` and `scraperwiki.readSettings` APIs to run shell commands, while jQuery’s `$(function(){})` triggers the two setup functions on page load. It writes the target URL into `~/tool/dataset_url.txt` and runs `run-one tool/runonce.R` with logging to `tool/log.txt`. No data source or rendering is involved; the focus is purely on command-line orchestration within ScraperWiki’s execution context.

IIanHopkinson
47% match
Loading thumbnail…

R.Execute example without the use of R.Execute() in Power Query [behind the scenes this gets executed bin\x64\Rscript.exe" --encoding=UTF-8 RScriptWrapper.R"]

This example demonstrates how to execute an R script from within Power Query without explicitly invoking the `R.Execute` function, instead relying on the `AdoDotNet.DataSource` with the `R.Provider` to run a native query. The code passes a string containing an `output` variable that captures the result of `system2("whoami", stdout=TRUE)`, which retrieves the current username. The resulting table is then converted from binary R data using `RData.FromBinary`. This approach showcases the underlying use of `Rscript.exe` via the provider, highlighting an alternative integration path for R workflows in Power Query.

HHugoberry
47% match
Loading thumbnail…

Gist ea8710410afc9bb88a65f846e46d04da

This example demonstrates how to automate opening a Google Sheets tab in Chrome at user logon and session unlock, using a PowerShell script to register a Windows scheduled task. The task triggers on logon and session unlock events, launching Chrome with an app-mode URL pointing directly to the spreadsheet. The code constructs an XML task definition with the `Register-ScheduledTask` cmdlet, embedding the Chrome executable path and the spreadsheet URL as arguments. It highlights the use of PowerShell’s scheduled task API and XML trigger configuration, showing a practical workflow automation for persistent access to a specific data source without manual intervention.

HHerbCaudill
46% match
Loading thumbnail…

Getting $Embedded$ connection details in Power Query via R

This example shows how to extract connection details for the Power Query engine by querying system processes and network ports. It retrieves the process ID of `msmdsrv.exe` from a filtered `tasklist` command and then cross-references it with TCP port information obtained via `netstat`. The R script parses the command-line output into fixed-width tables using base R functions (`read.fwf`, `textConnection`, `system2`). No external visualization libraries are used; the focus is on data wrangling through R's base I/O and text-processing capabilities, making the connection details available for later analysis.

HHugoberry
46% match