Supports EXPLODE, LATERAL VIEW, NOT RLIKE, NOT RLIKE ANY, TRIM, ABS, BETWEEN, NOT BETWEEN, SUBSTRING, UNIXTIMESTAMP
akshaisarma
released this
13 May 23:34
·
32 commits
to master
since this release
This release updates to Bullet Core 1.3.1 and adds support in BQL for:
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