Skip to content

BQL - EXPLODE, LATERAL VIEW, NOT RLIKE, NOT RLIKE ANY, TRIM, ABS, BETWEEN, NOT BETWEEN, SUBSTRING, UNIXTIMESTAMP. Bug fixes for Schema table, subfields, BQL autocomplete
Compare
Choose a tag to compare
@akshaisarma akshaisarma released this 18 May 23:11
· 8 commits to master since this release
v1.1.0
a7e9a76
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

This release supports Bullet BQL 1.2.0 for the following features in the BQL query building page:

EXPLODE - for exploding maps and lists into constituents in the SELECT or with a LATERAL VIEW
LATERAL VIEW - to be used with EXPLODE to generate a cross product with the exploded field and a row for all rows in a result
NOT RLIKE, NOT RLIKE ANY - the NOT versions of the supported RLIKE and RLIKE ANY
BETWEEN and NOT BETWEEN - two functions to check if a numeric or a string typed value is between two other values or fields
SUBSTRING - to get parts of a String with support for negative indexing
UNIXTIMESTAMP - to get the current UTC unix timestamp or to convert a given date argument or field into a unix timestamp with an optional pattern for parsing the date

It also fixes the following bugs:

  • Makes schema table load all expanded rows on open. The infinite scroll detection was not working and so would not load more than 2 rows previously.
  • Fixes the dot autocomplete bug that did not respect the word before the dot in the autocomplete list. Now fields inside maps should autocomplete correctly
  • Fixes the subfield in the querybuilder not causing dirty flag marking and therefore, losing subfield changes if that was the only change made
Assets 3
Loading