esProc Changelog

What's new in esProc 2023-12-08

Dec 11, 2023
  • Help Documentation updated;
  • Improvement: Add GC parameter configuration to JVM parameters;
  • New option: s.regex@w(rs,rpls), which finds whether the whole string matches the regular expression;
  • New option: output@g1234(x,…), which configures log level when outputting data to a log file;
  • New option: T.update@y/T.append@y(), which updates a pseudo table or apends data to the memory;
  • New function: A.cumulate(), which computes sum of members of a sequence;
  • New function: A.proportion(), which computes the proportion of each member of a sequence;
  • New function: x.nodes@r(Fi,…), which expands the refencing field through multilevel recursion;
  • New option: T.index@w(f:h,w;C,…;F,…), which optimizes the process of creating a full-text index for an entity table;
  • New function: transpose(A), which handles transpositon on the matrix that have empty members;
  • Improvement: Optimize【Find/Replace in the File】functionality and allow users to open the target script file by clicking it.

New in esProc 2023-10-20 (Oct 20, 2023)

  • Help Documentation updated;
  • Improvement: Add “Inverse operation” to certain functions, which corresponds to @z option;
  • New function: time functions pdate@1 and deq@1, which treat Monday as the first day of the week;
  • New function: typeof(), which gets a variable’s data type;
  • New option: @i and @c options in f.structure(), which get structures of an index file and an preaggregation file respectively;
  • New function: T.cuboid(), which generates preaggregation file and T.cgroups(), which uses preaggregation file to group and summarize a composite table;
  • New function: s.split@z, which splits a string into two parts at the position of the last delimiter;
  • New function: f.sortx(), which sorts a bin file/a sequence of bin files and generates a new bin file;
  • New function: T.append(), which appends data in a table sequence to a composite table’s entity table;
  • New function: f.reset(), which combine data in a cursor/table sequence into the composite table when arranging data in the latter;
  • Improvement: Index file-related functionalities for the composite table improved; related functions are T.index()and T.icursor();
  • Improvement: For functions left(s,n), right(s,n) and mid(s,n,l), the algorithm involving negative parameter n values improved.

New in esProc 2023-02-28 (Feb 28, 2023)

  • Help Documentation updated;
  • New feature:Output total duration of the SPL computation after the SPL program is executed in IDE;
  • New feature:Releae resources ater connection is closed when JDBC uses nodes;
  • Improvement: Add method of accessing a regular URL in HTTP service;
  • New function: A.bits() for handling the sequence of bit values;
  • New function: T.index(I:h,w;C,…) that creates non-primary-key-based index for an in-memory table;
  • Improvement: Simplify and streamline the jar files esProc requires.

New in esProc 2022-12-26 (Feb 8, 2023)

  • Update: Help Documentation;
  • Improvement: Support of .spl files in call functions;
  • New feature: Function prompt;
  • New function: splserver(port,cfg), which starts or stops the node service on the local machine through SPL script;
  • New feature: Call a node service on the local machine using callx(spl,…;hs;rspl) function;
  • New syntax: in simple SQL, users can query data file information, and use wild character and macro in a data file name;
  • New feature: output@g(), which writes console information to log file.