BigObject Analytics Release 1.8.7 (Dec, 31, 2020)

  1. New geometry data type: 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.
  6. Bug fixes.

BigObject Analytics 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.
  7. Bug fixes.

BigObject Analytics Release 1.8.5 (May, 14, 2019)

  1. Enhance GET statement.
  2. Bug fixes.

BigObject Analytics Release 1.8.4 (Apr, 18, 2019)

  1. Add aggregate functions: MEDIAN and QUANTILE.
  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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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 Analytics 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.