BigObject Analytics 1.x

BigObject Release 1.9.2 (Mar, 06, 2024)

  1. Support NULL values.
  2. New timestamp datatype supports sub-second precision.
  3. Add string function: HEX.
  4. FULL keyword is deprecated.
  5. DATETIMEDOS is deprecated.
  6. Avro streaming support is deprecated.
  7. Many bug fixes.

BigObject Release 1.9.1 (Apr, 21, 2022)

  1. Improve insertion performance.
  2. Bug fixes.

BigObject Release 1.9.0 (Apr, 21, 2022)

  1. New aggregate functions: FIRST and LAST.
  2. Add table and column comment.
  3. Improve joins on different types.
  4. Bug fixes.

BigObject Release 1.8.9 (Jan, 28, 2022)

  1. New math function: TRUNCATE.
  2. New spatial functions: DEGREES, ST_AZIMUTH, ST_AZIMUTH_GEOM, ST_MAKEPOINT, and ST_MAKELINE.
  3. New string functions: LTRIM and SUBSTRING.
  4. New utility functions: AES_DECRYPT and AES_ENCRYPT.
  5. New vector function: F32VEC_DIST.
  6. New management statement: create/drop user, grant/revoke privileges, and show cluster tables.
  7. Improve show cluster information.
  8. Logging mechanism.
  9. Auto cluster query.
  10. SSL connection.
  11. Bug fixes.

BigObject Release 1.8.8 (June, 25, 2021)

  1. Add datetime functions: ADDDATE, CURDATE, DATE, DAYOFMONTH, DAYOFWEEK, FROM_DAYS, SUBDATE, TO_DAYS, TIME, and TIME_TO_SEC.
  2. Add string functions: LEFT, RIGHT, and RTRIM.
  3. Bug fixes.

BigObject Release 1.8.7 (Dec, 31, 2020)

  1. New geometry data types: POINT, LINESTRING, POLYGON, MULTIPOLYGON.
  2. New geohash function: ST_POINTFROMGEOHASH.
  3. New functions for POINT: ST_X, ST_Y, ST_DISTANCE_SPHERE.
  4. New geometry format functions: ST_ASTEXT, ST_ASGEOJSON.
  5. New spatial functions: MBRINTERSECTS, ST_ENDPOINT, ST_INTERSECTS, ST_STARTPOINT, ST_WITHIN.
  6. Bug fixes.

BigObject Release 1.8.6 (Mar, 24, 2020)

  1. Add math functions: PI, SIN, and COS.
  2. Add string functions: LOWER and UPPER.
  3. Add geohash functions: GEOHASH and ST_GEOHASH.
  4. New GH_NEIGHBORS and GH_EXPAND table operators.
  5. Support OUTER JOIN and simple RANGE JOIN.
  6. Support INSERT ON DUPLICATE KEY UPDATE.
  7. Bug fixes.

BigObject Release 1.8.5 (May, 14, 2019)

  1. Enhance GET statement.
  2. Bug fixes.

BigObject Release 1.8.4 (Apr, 18, 2019)

  1. Add aggregate functions: MEDIAN and QUANTILE.
  2. Add APPROXIMATE MEDIAN and APPROXIMATE QUANTILE for BigObject cluster.
  3. Add PIVOT/UNPIVOT clause.
  4. BUILD PIVOT TABLE command is deprecated.
  5. New DateTime functions: DATE_TRUNC and TIME_BUCKET.
  6. Bug fixes.

BigObject Release 1.8.3 (Jan, 29, 2019)

  1. Allow BigObject Cluster setup to register multiple masters and filter exposed databases.
  2. New string function: LENGTH.
  3. Allow UPDATE to set value with expression.
  4. Bug fixes.

BigObject Release 1.8.2 (Nov, 09, 2018)

  1. Enhance BigObject Cluster setup with auto registration.
  2. New datetime function: ADDTIME, SUBTIME.
  3. FIND statement is temporarily removed.
  4. Bug fixes.

BigObject Release 1.8.1 (Sep, 28, 2018)

  1. Supports BigObject Cluster.
  2. Add CLUSTER SELECT statement for BigObject Cluster.
  3. Add GROUP_CONCAT aggregate function.
  4. Add OPTIMIZE statement to reduce space of deletable tables.
  5. Enhance Lua table function find() for indexed tables.
  6. Add utility functions: GROUP_RANK, GROUP_ROW_NUMBER.
  7. Add math functions: ROUND, CEIL, FLOOR.
  8. Support MySQL Workbench 8.0.
  9. Support UNION operator.
  10. Bug fixes.

BigObject Release 1.8.0 (Mar, 09, 2018)

  1. Add time-bounded sliding table.
  2. Enable SELECT on specified time window for sliding tables via LAST, SINCE, or BETWEEN clause.
  3. Support many-to-many LEFT/INNER JOIN.
  4. New math functions: SQRT and POW.
  5. New datetime function: STR_TO_DATE.
  6. New string function: RPAD.
  7. CAST function supports more types.
  8. Bug fixes.

BigObject Release 1.7.2a (Dec, 26, 2017)

  1. Add RENAME TABLE statement.
  2. Add FORMAT function to convert FLOAT and DOUBLE to CHAR with specified precision.
  3. Bug fixes.

BigObject Release 1.7.1a (Sep, 27, 2017)

  1. New data type IPv4 and IPv6.
  2. New datetime functions: DATE_FORMAT, NOW, TIMEDIFF, TIMESTAMP, and TIME_SEG.
  3. New string functions: CONCAT, LPAD, and SUBSTR.
  4. New functions: CUMSUM and DIFF, DATEDIFF, and CUT.
  5. Bug fixes.

BigObject Release 1.7a (Jan, 25, 2017)

  1. Add table sampling via FILTER BY SAMPLE clause.
  2. New aggregate function CORR.
  3. Supports read only file system.
  4. Bug fixes.

BigObject Release 1.6.1a (July, 15, 2016)

  1. Improve MySQL protocol performance.
  2. Add data type CHAR.
  3. Add standard and population variance function.
  4. Impose restriction on maximum length of string data types.
  5. Allow append to pivot table.
  6. Enhance compatibility for tableau live connection.
  7. Change DATETIME32 to DATETIMEDOS and add new data type DATETIME32.
  8. Bug fixes.

BigObject Release 1.6a (May, 27, 2016)

  1. Add column-based table.
  2. New HTTP interface API.
  3. Add distinct count function.
  4. Remove restrictions on table key.
  5. Bug fixes.

BigObject Release 1.5a (Feb, 19, 2016)

  1. Add MySQL Protocol to support mysql client.
  2. Support MySQL Workbench and tableau via MySQL ODBC driver.
  3. Add LOAD command to load csv file.
  4. Add streaming in protocol for avro and csv.
  5. Column group table is deprecated.
  6. Improve API performance.
  7. Bug fixes.

BigObject Release 1.4a (Nov, 25, 2015)

  1. Add boost_level to adjust performance and memory usage.
  2. Support Tableau via ODBC.
  3. New column group table.
  4. Support DELETE for table created with keyword DEFAULT.
  5. Bug fixes.

BigObject Release 1.3a (Oct, 8, 2015)

  1. New trans-pivot analytics feature to create pivot tables from a table object.
  2. Allow tree path specified by index in a GET/APPLY statement.
  3. Improve restful API performance.
  4. Add function numColumns() for table in lua programming.
  5. Bug fixes.

BigObject Release 1.2a (Aug 10, 2015)

  1. Enable restful API with either direct or scan-based data retrieval scheme.
  2. New in-place programming framework via lua script.
  3. New csv smart uploader in web-based BigObject shell.
  4. Add aggregation function: STD/STDSAMP.
  5. Add ALTER command to add key/change column name.
  6. Bug fixes.

BigObject Release 1.1a (May, 20, 2015)

  1. New restful API.
  2. New table object.
  3. Allow customized Lua function in Find statement.
  4. Bug fixes.
  5. Docker release.

BigObject Release 1.0a (January, 15, 2015)

  1. Find by filter.
  2. Find by pattern.
  3. Discover by association.
  4. API for Java, JavaScript(node.js), PHP, Ruby and Python.
  5. Support several D3.js components.