OpenMLDB is an open-source machine learning database that provides a feature platform computing consistent features for training and inference.
APACHE-2.0 License
Bot releases are visible (Hide)
first_value
which will be compatible with ANSI SQL(#3861 @aceforeverd)online
which was offline
before 0.9.0(#3862 @aceforeverd)Published by github-actions[bot] 8 months ago
UNION ALL
statement (#3590 #3653 @aceforeverd)SELECT ... INTO OUTFILE
to OpenMLDB online tables (#3616 @tobegit3hub)LAST JOIN
and WINDOW
without ORDER BY
in offline mode (#3619 @aceforeverd)CREATE/ALTER/DROP USER
statement (#3678 #3745 #3747 @dl239, #3744 @tobegit3hub)INSERT
returns failure if the server-side memory usage exceeds the specified limit (#3631 @dl239)LEFT JOIN
, the indexs will be created automatically. (#3667 @aceforeverd)absandlat/absorlat
TTL type for disktable (#3716 @dl239)FlexibleRowBuilder
will throw a NullPointerException
if set with a null value (#3649 @dl239)BufferOverflowException
. (#3729 @ljwh)TRUNCATE
(#3677 @dl239)GetAllDbs
fails. (#3742 @vagetablechicken)#3666 @vagetablechicken
Published by github-actions[bot] 11 months ago
SHOW CREATE TABLE
, TRUNCATE
and [Alpha] LEFT JOIN
(#3500 #3542 @dl239, #3576 @aceforeverd)ORDER BY
clause (#3554 @aceforeverd)LAST JOIN
on a window clause (#3533 #3565 @aceforeverd)datediff
(#3499 @aceforeverd)LAST JOIN
in WINDOW UNION
statement in the request mode. (#3493 @aceforeverd)#3547 @aceforeverd
Published by github-actions[bot] about 1 year ago
json_array_length
and get_json_object
(#3414 #3429 @aceforeverd)RANGE_BIAS
and ROWS_BIAS
for the DEPLOYMENT
statement (#3456 @vagetablechicken)const
project in online mode (#3376 @aceforeverd)SHOW DEPLOYMENT
and DROP DEPLOYMENT
with a database name (#3353 @emo-coder)CREATE TABLE LIKE HIVE
returns success even if a database is not found (#3379 @emo-coder)DROP FUNCTION
, the function cannot be deleted again. (#3362 @vagetablechicken, #3441 @dl239)SHOW JOBS
are not sorted by id
(#3371 @emo-coder)CREATE INDEX
may fail if the previous CREATE INDEX
command on the same table has not finished. (#3393 @dl239)SELECT
on the deleted index column is empty (#3426 @dl239)#3397 @emo-coder, #3411 @vagetablechicken, #3435 @aceforeverd, #3473 @lqy222
GetInternalSchema
in SQLResultSet
changes from native Schema to com._4paradigm.openmldb.sdk.Schema
#3445namenode.uri
#3369Published by github-actions[bot] about 1 year ago
delete
statement (#3301 #3374 @dl239)IF EXISTS
in the DROP TABLE/DATABASE
statement (#3348 @emo-coder)10.5.0-SNAPSHOT-0.8.1
(#3365 @vagetablechicken)Offline_deep_copy
will be replaced by Offline_symbolic_paths
in the result of SHOW TABLE STATUS
#3349.Published by github-actions[bot] over 1 year ago
ALTER TABLE ... ADD/DROP OFFLINE_PATH ...
(#3286 @aceforeverd, #3323 @tobegit3hub)top_n_value_ratio_cate
, top_n_key_ratio_cate
, list_except_by_key
and list_except_by_value
(#3329 @aceforeverd)SELECT INTO ...
statement (#2529 @vagetablechicken)udf
directory does not exist by default. (#3326 @vagetablechicken)#3226 @dl239, #3294 @aceforeverd
Published by github-actions[bot] over 1 year ago
var_samp
, var_pop
, entropy
, earth_distance
, nth_value_where
and add_months
(#3046 #3193 @aceforeverd)round
(#3221 @aceforeverd)SKIP_INDEX_CHECK
to skip index checking when deploying SQLs (#3241 @dl239)CREATE TABLE ... LIKE HIVE ...
statement execution fails if there is no database in a table name. (#3063 @tobegit3hub)success
even though CREATE TABLE ... LIKE ...
execution fails. (#3080 @tobegit3hub)SELECT ... INTO ...
statement execution fails in the offline mode if there is no source table. (#3116 @tobegit3hub)SELECT *
over two LAST JOIN. (#3117 @aceforeverd)JOB_INFO
fails. (#3169 @vagetablechicken)#3188 @tobegit3hub
Published by github-actions[bot] over 1 year ago
max_traverse_cnt
to unlimited to avoid result truncated when performing queries in CLI (#2999 @dl239)SPARK_HOME
does not work in the deployment scripts. (#3085 @zhanghaohit)SELECT timestamp(string_val)
is incorrect at the offline mode. (#3088 @tobegit3hub)#3122 @haseeb-xd
Note:
If the configuration of a tablet has not been updated when upgrading to this new version, the query result still may be truncated as the old version (#2999).
Published by github-actions[bot] over 1 year ago
WITH
(#2846 @aceforeverd)std
, stddev
, stddev_samp
, stddev_pop
, ew_avg
and drawdown
(#3025 #3032 #3029 @zhanghaohit)CREATE TABLE ... LIKE PARQUET ...
statement supports a parquet file as the input in the offline mode. (#2996 @tobegit3hub)LAST JOIN
statement in a deployed SQL. (#2979 @dl239)EXCLUDE CURRENT_ROW
(#2930 @aceforeverd)recoverdata
command fails if there are a large number of records in a memory table. (#3060 @dl239)deploy-all
tool deploys the Spark package to local nodes only. (#3022 @zhanghaohit)#2995 #3030 @aceforeverd
Note:
While we have resolved the overflow issue in the current version of the monitor component #3003, it may still persist when upgrading from an older version.
Published by github-actions[bot] almost 2 years ago
CREATE TABLE LIKE
(#2949 @aceforeverd, #2962 @tobegit3hub)_*_cate
is incorrect. (#2939 @zhanghaohit)show components
is incorrect in certain cases. (#2940 @dl239)Curator
component causes an incompatible issue. (#2936 @tobegit3hub)#2875 #2937 @dl239
Published by github-actions[bot] almost 2 years ago
max_memory
to limit the memory usage of a tablet (#2815 @dl239)deploy-all
and start-all
(#2809 @zhanghaohit)unix_timestamp
, pmod
, datediff
, and size
(#2843 #2839 #2847 #2864 @zhanghaohit)ARRAY
in UDFs (#2817 @aceforeverd)SHOW JOBLOG
fails under certain circumstances. (#2874 @tobegit3hub)OP
is not deleted if the related table has been dropped. (#2548 @dl239)yarn-client
and yarn-cluster
in the offline mode. (#2802 @tobegit3hub)#2860 @mammar11, #2865 #2863 @vagetablechicken, #2861 #2862 #2871 @Ziy1-Tan
Published by github-actions[bot] almost 2 years ago
pre-upgrade
and post-upgrade
options in tools for upgrade (#2761 @zhanghaohit)show job
without a job ID. (#2771 @aceforeverd)select count(*)
may return empty result after tablets restart. (#2835 @zhanghaohit)null
. (#2831 @dl239)Published by github-actions[bot] almost 2 years ago
where
clause in the SQL batch engine (#2820 @tobegit3hub)#2816 @dl239, #2714 @aceforeverd
Published by github-actions[bot] almost 2 years ago
autofe
(#2777 @vagetablechicken)TaskManager
client (#2780 @vagetablechicken)Published by github-actions[bot] almost 2 years ago
hash64
(#2754 @aceforeverd)pytest
command is not found in the MacOS virtual machine. (#2765 @tobegit3hub)WindowAggRunner
. (#2758 @aceforeverd)showopstatus
command if no database is specified (#2773 @dl239)Published by github-actions[bot] almost 2 years ago
show joblog
(#2732 @aceforeverd, #2747 @tobegit3hub)show table status
(#2738 @zhanghaohit)start_time
is not human-readable after submitting a job (#2751 @tobegit3hub)GetRecordIdxCnt
is produced in MemTable
(#2719 @jkpjkpjkp)#2688 #2717 @vagetablechicken, #2705 #2728 @dl239, #2601 @team-317, #2737 @Jake-00
Published by github-actions[bot] almost 2 years ago
top_n_value_*_cate_where
(#2622 @aceforeverd)load_mode
and thread
options for LOAD DATA
(#2684 @zhanghaohit)traverse
method may get duplicate data if there are same ts
records on one pk
(#2637 @dl239)select * ...
statement may cause inconsistent output schemas in many cases (#2660 @aceforeverd)UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE CURRENT_ROW
(#2674 @aceforeverd)#2541 @dl239, #2573 #2672 @haseeb-xd
Published by github-actions[bot] about 2 years ago
glog
for clients (#2482 @vagetablechicken)unhex
(#2431 @aucker)LAST JOIN
with a subquery as a producer of window node in the request mode (#2569 @aceforeverd)ValidateSQL
to validate the syntax of SQL (#2626 @vagetablechicken)bool
, it fails to resolve the function count_where
. (#2570 @aceforeverd)#2516 #2520 #2522 #2521 #2542 #2531 #2581 @haseeb-xd, #2525 #2526 #2527 #2528 @kstrifonoff, #2523 @ighmaZ, #2546 #2549 @NevilleMthw, #2559 @marandabui, #2554 @gokullan, #2580 @team-317, #2599 @lbartyczak, #2594 @shivamgupta-sg, #2571 @Jake-00
Published by github-actions[bot] about 2 years ago
partitionnum
is set to 0, which should report an error. (#2220 @dl239)puts
. (#2472 @zhanghaohit)limit
clause dose not work if it is used with the where
and group by
clauses. (#2447 @aceforeverd)TaskManager
process will terminate if ZooKeeper disconnects. (#2494 @tobegit3hub)#2413 @dl239, #2470 #2467 #2468 @vagetablechicken
Published by github-actions[bot] about 2 years ago
last_day
and regexp_like
(#2262 @HeZean, #2187 @jiang1997)APIServer
will core dump if no rs
in QueryResp
. (#2346 @vagetablechicken)pre-aggr
tables if there are delete operations in a main table. (#2300 @zhanghaohit)UnsafeRowOpt
with multiple threads in the Yarn cluster. (#2352 #2364 @tobegit3hub)#2310 @hv789, #2306 #2305 @yeya24, #2311 @Mattt47, #2368 @TBCCC, #2391 @PrajwalBorkar, #2392 @zahyaah, #2405 @wang-jiahua