Commands
Every PPL command of the OpenSearch command reference and how LynxDB executes it. full follows the OpenSearch semantics apart from the listed deviations; partial runs with the listed options and limits and rejects the others with an UNSUPPORTED_FEATURE error; unsupported commands fail with UNSUPPORTED_COMMAND.
| Command | Support | Notes |
|---|---|---|
ad | unsupported | it runs the OpenSearch ML Commons plugin, which LynxDB does not have |
addcoltotals | full | |
addtotals | full | |
append | full | |
appendcol | full | |
appendpipe | full | the input is computed twice |
bin | partial | span= with numeric and time units; bins, minspan, aligntime, start, end and logarithmic spans are unsupported |
chart | partial | limit (topN, bottomN), useother, usenull, nullstr, otherstr and span= on splits supported; bins, minspan, start and end unsupported |
convert | full | auto, num, rmcomma, rmunit, memk, dur2sec, mstime, ctime, mktime, none |
dedup | full | |
describe | partial | returns TABLE_NAME, COLUMN_NAME, TYPE_NAME and ORDINAL_POSITION from the values stored in the index |
eval | full | |
eventstats | partial | bucket_nullable=false with a by clause and the window functions row_number, rank, dense_rank, percent_rank, cume_dist, nth and ntile are unsupported |
expand | full | |
explain | partial | returns LynxDB's logical and optimized IR plans; the simple, standard, cost and extended modes render the same plans |
fieldformat | unsupported | display formatting with prefix and suffix is not implemented; use eval with concat() |
fields | full | |
fillnull | full | without a field list, fills NULL values of the columns each row has |
flatten | partial | aliases are assigned to members in key order |
foreach | unsupported | templated per-field evaluation is not implemented; write one eval per field |
graphlookup | unsupported | recursive graph traversal needs an iterative join operator LynxDB does not have |
grok | partial | built-in library of common patterns (pkg/ppl/grok); custom pattern definitions are not supported |
head | full | |
join | partial | inner, left, right, full, semi, anti and cross joins with equality keys and a residual condition, overwrite and max; the right side is held in memory |
kmeans | unsupported | it runs the OpenSearch ML Commons plugin, which LynxDB does not have |
lookup | partial | replace, append and output with an explicit output field list |
makeresults | full | |
ml | unsupported | it runs the OpenSearch ML Commons plugin, which LynxDB does not have |
multisearch | full | results are merged newest first |
mvcombine | full | |
mvexpand | full | |
nomv | full | |
parse | full | RE2 regular expressions: no lookaround or backreferences |
patterns | partial | simple_pattern in label and aggregation modes; a by clause only in aggregation mode; brain and show_numbered_token=true unsupported |
rare | full | |
regex | full | RE2 syntax |
rename | full | |
replace | full | |
rest | unsupported | it reads OpenSearch cluster management endpoints; use the LynxDB REST API |
reverse | full | |
rex | partial | extract mode and sed s/regex/replacement/[g]; offset_field unsupported; RE2 syntax |
search | partial | free-text terms match whole tokens of the event's raw text through the term index (OpenSearch searches all fields); quoted phrases match at token boundaries; field comparisons are exact and case-sensitive; field wildcards match the whole value; time modifiers supported; cross-cluster prefixes are read as part of the index name |
show datasources | unsupported | LynxDB has no external data sources; every index is local |
sort | full | ip(field) sorts by the text form of the address |
spath | partial | auto-extract keeps JSON value types; a JSON null stays NULL |
stats | partial | bucket_nullable supported; partitions, allnum and delim accepted without effect; dedup_splitvalues unsupported; distinct_count is estimated beyond 10,000 values per group only by the row operators; output row order is unspecified |
streamstats | partial | current, window and global=false supported; bucket_nullable=false with a by clause, reset_before, reset_after, time_window, and window with global=true and a by clause are unsupported |
subquery | partial | uncorrelated IN, EXISTS and scalar subqueries; a subquery is evaluated once before the outer query; correlated subqueries are not supported: a reference through the outer source name or alias (outer.b), or to a field only the outer query has, fails to compile, and an unqualified name the subquery can also have reads the subquery's own field |
table | full | |
timechart | partial | span, limit, useother, usenull, nullstr and timefield supported (the default time field is _time); bins and minspan unsupported; per_second, per_minute, per_hour and per_day supported |
timewrap | unsupported | period-over-period wrapping is not implemented; compute the shifted period with eval and join |
top | full | |
transpose | full | |
trendline | full | |
union | full | |
where | full | |
xyseries | full |