👉👉👉 This extension is still under development.

👉👉👉 JDK 1.8+ is required in your system.

mlsql-Lang

mlsql-lang is a Visual Studio Code extension that allows you to run MLSQL code in both Script/Notebook interface.

Current Version

v0.0.5

v0.0.5 (dev)

✅ Fix opening .mlsqlnb do not trigger mlsql language server

v0.0.4

✅ More control parameters on engine
✅ New include type project is support
✅ !pyInclude also support project type.
✅ Support html/png renderer in notebook mode.
✅ More mlsql code examples
- mlsql-lang-example-project/github
- mlsql-lang-example-project/gitee

v0.0.3

✅ mlsql-lang grammar highlight
✅ Better table renderer
✅ mlsql-lang code autocomplete

Requirements

JDK 1.8+ is required in your system.
mlsql-lang is only tested in MacOS/Linux though this extension works in Windows.

Installation

Install From Local

this extension contains mlsql-lang already.

Download extension from https://mlsql-downloads.kyligence.io/2.1.0/mlsql-0.0.5.vsix

run command code --install-extension mlsql-0.0.5.vsix
Or Just open mlsql-0.0.5.vsix in vscode in market panel

Install From Market

Search mlsql in market and install it.
Download mlsql-lang from https://mlsql-downloads.kyligence.io/2.1.0/
Extract mlsql-lang and configure the path by engine.home in .mlsq.config.

Others

MLSQL 桌面版使用 (Mac/Linux)

Usage

Install extension.
Create a directory, then open it with Visual Studio Code.
File extensions .mlsql or .mlsqlnb are supported.
Once you open a mlsql file, the extension will be activated.

If not auto activate, click right left corner and click language select button, choose MLSQL.
Open command MLSQL: run to execute MLSQL script:

Here is notebook example:

Example project

Restart mlsql lang language server

Run command in vscode: Developer: Reload Window

Congiguration (>= 0.0.2)

You can configure MLSQL Lang server with file .mlsql.config in your project (root path).

For example:

engine.home=...../mlsql-lang/mlsql-app_2.4-2.1.0-SNAPSHOT
engine.url=http://127.0.0.1:9003
engine.owner=admin
engine.memory=2048m

user.access_token=123

Build-in Plugins

Excel/Shell is build-in support in this extention. You can load excel file like this:

Install Third-party Plugin

The plugins repo: mlsql-plugins

You can install them like this:

Know Issues

.mlsqlnb have no plugin for it ( <=v0.0.4)

If you reopen the project, when notebook is open before the mlsql-lang is activated,then the following error will happen:

Just close/open the notebook(.mlsqlnb) and everything goes Ok.

mlsql lang server fails to quit when your workspace closed ( <= v0.0.3)

Sometimes the lang server will not quit properly when you close your workspace. Try using flowing command to find the pid and kill it.

ps -ef |grep 'tech.mlsql.plugins.langserver.launchers.stdio.Launcher'

mlsql

allwefantasy