# OpenMLDB

Summary

This week 8 Pull requests were merged, 5 Pull requests were added, 11 Issues were closed, and 20 Issues were added. A total of 84 file changes were made, with 6677 lines of code added and 511 lines deleted.

Merged Pull Requests

  • feat: support spark.master config to run job in yarn or local#466 
  • feat: read openmldb git properties and set in return string#464
  • feat: enable TestWindowUnion test#467
  • Feat: Bump SNakeyAML from 1.17 to 1.26 in /test/ Batch-test/OpenMLdb-Batch-test #416
  • feat: add openmldb jmh#367 
  • test: modify cicd#465 
  • feat: add src test cicd#452 
  • fix: fix a bug when turn on window parallelization and skew optimization#438 

Open Pull Requests

  • Fix import error of OpenMLDB Python lib when installed as zip format#439 
  • fix: remove dup apply pass on the same physical op.#453 
  • feat: ddlparser extracts indexes from sql#457 
  • build: add deployment script#469 
  • style: update hybridse header guard style#470 

Close Issues

  • Support Spark local jobs in TaskManager for local OpenMLDB setup#456 
  • Return the openmldb version string for Batch#463 
  • Enable the unit test of TestWindowUnion#339 
  • Create index, ttl_type=test, create successfully, expect error message #162
  • Deploy all-in-one java package#84 
  • move demo to main repo#120 
  • Create absorlat index, desc does not display #163
  • scripts: package java sdk set cmake type to release#371 
  • feat: support insert multiple rows into a table using a single SQL insert statement.#398
  • Fix enable WindowSkewOpt and WindowComputeParallelOpt at the same time#444 
  • add more status badges to README#313 

Open Issues

  • Support passing multiple databases for parsing each SQL statement#468 
  • Set index if there is no index info in create statement#462 
  • Update catalog in stand alone mode#461 
  • Add SHOW DEPLOYMENT and DROP DEPLOYMENT command#460 
  • Recover metadata when nameserver restart in stand alone mode#459 
  • Store metadata in system table#458 
  • Support SELECT INTO OUTFILE syntax#455 
  • ci: pre-build macos pkg needs to select sdk#454 
  • Support querying data from Trino in oenmldb CLI#451 
  • Add SHOW JOBS command for CLI and TaskManager#450 
  • Support generating and storing job id for TaskManager#449 
  • Integrate the ability of SQL analysis by trino in CLI#448 
  • Add DEPLOY command#447 
  • Write the result of select sql into file#446 
  • Support SET syntax#445 
  • Add import command#443 
  • Support engine option in create statement#442 
  • Use nameserver ip and port to connect openmldb#441 
  • Support stand-alone mode#440 
  • Fail query window+lastjoin when turn on enable_batch_window_parallelization#437 

Contributors

Highlights

This week saw further improvements in feature development, bug fixes, performance testing, and CICD integration solutions. In terms of functions, TaskManager supports single-machine batch processing mode. The Bug solution fixes the problems of Git version information display, batch mode running window tilt optimization and window parallel optimization. In terms of performance testing, openMLDB-JMH module is integrated to strengthen the performance regression testing of Java modules. For CICD integration, SRC tests based on source branches and PKG tests based on specific versions have been added, and large-scale integration tests with thousands of cases can also be run manually on Github. There are many new issues this week, focusing on the redesign and implementation of high-performance stand-alone version. Those who are interested in high-performance database optimization can also pay attention to them.

More developers are welcome to pay attention to and participate in OpenMLDB open source projects.