Byzer (former MLSQL) is a low-code, open-sourced and distributed programming language for data pipeline, analytics and AI in cloud native way.
Deisgn protocol: Everything is a table. Byzer is a SQL-like language, to simplify data pipeline, analytics and AI, combined with built-in algorithms and extensions.
We believe that everything is a table, a simple and powerful SQL-like language can significantly reduce human efforts of data development without switching different tools.
You can build a data product based on Byzer engine & Byzer-lang without interacting with computing framework directly like Spark in your data APP. Thus will simplify your data app significantly.
For example, Byzer org contributes a data app Byzer Notebook, which provides notebook interaction & workflow GUI interaction.
Byzer project uses the BIP for the community collaboration, you can checkout the feature design or architecture design in BIP.
You can access the official website https://www.byzer.org/ and try Byzer-lang & Byzer Notebook online.
You can download Byzer engine via:
For more details, please refer to the docs
For dev/test purpose, you can download Byzer All In One Package, extract and then execute the command below
$ cd {BYZER_HOME}
$ ./bin/byzer.sh start
And for production purpose, we recommend to use Byzer Server Package and deploy it on Hadoop.
You can also install Byzer VSCode Extension to use Byzer-lang.
For the Docker Image or , please refer to the docs
Below list an example that how to process Github API as a table to get the information of Byzer Org
-- Get Github Organization Info
-- set API URL and params
SET org_name="byzer-org";
SET GITHUB_ORGANIZATION_URL="https://api.github.com/orgs/${org_name}";
-- Load Github Organization API as table
LOAD Rest.`$GITHUB_ORGANIZATION_URL`
where `config.connect-timeout`="10s"
and `config.method`="GET"
and `header.accept`="application/vnd.github.v3+json"
as github_org;
-- decode API response from binary to a json string
select string(content) as content from github_org as response_content;
-- expand the json string
run response_content as JsonExpandExt.`` where inputCol="content" and structColumn="true" as github_org;
-- retrieve user infomation and process as a table
select content.* from github_org as org_info;
-- save the table to delta lake
save overwrite org_info as delta.`github_info_db.byzer_org`;
For more details about the Byzer-lang grammer, please refer to the user manaual Byzer-lang Grammar
git clone https://github.com/{YOUR_GITHUB}/byzer-lang.git
Use Intellj Idea to open the project, choose the scala version 2.12.10
In Intellj Idea Maven Setting, check the profile below
Click Maven Refresh and wait for Idea load finished
Find the class tech.mlsql.example.app.LocalSparkServiceApp
, click Debug button then Byzer Engine will be started, then you can access the Byzer Web Console in http://localhost:9003/
You can refer to the project byzer-org/byzer-build to check how to build the Byzer engine binary packages and images
If you are planning to contribute to this project, please create an issue at our Issue page even if the topic is not related to source code itself (e.g., documentation, new idea and proposal).
This is an active open source project for everyone, and we are always open to people who want to use this system or contribute to it.
For more details about how to contribute to the Byzer Org, please refer to How to Contribute
Made with contrib.rocks.