在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:mlsql开源软件地址:https://gitee.com/allwefantasy/mlsql开源软件介绍:MLSQLMLSQL is a distributed Programming Language designed For Big Data and AI. load hive.`raw.stripe_discounts` as discounts;load hive.`raw.stripe_invoice_items` as invoice_items;select invoice_items.*, case when discounts.discount_type = 'percent' then amount * (1.0 - discounts.discount_value::float / 100) else amount - discounts.discount_value end as discounted_amount from invoice_items left outer join discounts on invoice_items.customer_id = discounts.customer_id and invoice_items.invoice_date > discounts.discount_start and (invoice_items.invoice_date < discounts.discount_end or discounts.discount_end is null)as joined;select id, invoice_id, customer_id, coalesce(discounted_amount, amount) as discounted_amount, currency, description, created_at, deleted_at from joinedas final;set allColumns = "all,wow";!if ''' split(:allColumns,",")[0] == "all" '''; select * from final as final2;!else; select id,invoice from final as final2;!fi;select * from final2 as output; Official WebSiteDesktop(MacOS、Linux)more document about mlsql lang desktop/Chinese Docker SandboxPulling Sandbox Docker ImageFor Spark 2.4.3 bundle: docker pull techmlsql/mlsql-sandbox:2.4.3-2.1.0 For Spark 3.1.1 bundle: docker pull techmlsql/mlsql-sandbox:3.1.1-2.1.0 Start Containerdocker run -d \-p 3306:3306 \-p 9002:9002 \-e MYSQL_ROOT_PASSWORD=mlsql \--name mlsql-sandbox-2.4.3-2.1.0 \techmlsql/mlsql-sandbox:2.4.3-2.1.0
Download MLSQL
Naming Convention mlsql-engine_${spark_major_version}-${mlsql_version}.tgz ## Pre-built for Spark 2.4.3mlsql-engine_2.4-2.1.0.tar.gz## Pre-built for Spark 3.1.1mlsql-engine_3.0-2.1.0.tar.gz Building a DistributionPrerequisites
Downloading Source Code## Clone the code basegit clone https://github.com/allwefantasy/mlsql.git .cd mlsql Building Spark 2.4.3 Bundleexport MLSQL_SPARK_VERSION=2.4./dev/make-distribution.sh Building Spark 3.1.1 Bundleexport MLSQL_SPARK_VERSION=3.0./dev/make-distribution.sh Building without Chinese Analyzer## Chinese analyzer is enabled by default.export ENABLE_CHINESE_ANALYZER=false./dev/make-distribution.sh <spark_version> Building with Aliyun OSS Support## Aliyun OSS support is disabled by defaultexport OSS_ENABLE=true./dev/make-distribution.sh <spark_version> Deploying
4.Start MLSQL in local mode cd $MLSQL_HOME## Run process in backgroundnohup ./bin/start-local.sh 2>&1 > ./local_mlsql.log &
Directory structure |-- mlsql |-- bin |-- conf |-- data |-- examples |-- libs |-- README.md |-- LICENSE |-- RELEASE Contributing to MLSQLIf you are planning to contribute to this repository, please create an issue at our Issue pageeven 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. Contributors
WeChat Group扫码添加K小助微信号,添加成功后,发送 mlsql 这5个英文字母进群。 |
请发表评论