Change log

This article tracks the changes and updates to Upsolver.
2022
2022/Mar/22
Bug Fixes
Simple Cloud Storage Input: Improvements to file discovery
Enhancements
Athena Outputs: Enabled partition column types other than string
Performance improvements
​
2022/Mar/21
Changes in this Release:
API: The return value of shards and related fields changed from number to struct. The struct contains executionParallelism which represents the old number. Customers using API endpoints related to data sources, lookup tables or outputs may need to update their code. Please contact our support for details.

Bug Fixes
SQL               Fixed the code-generation of the decimal type
Compute Cluster    Fixed a bug that would cause the Compute cluster, in rare cases, not 
                   to update against the configuration.
Monitoring        Fixed a bug that would not expose reporting tags to external monitors.
API               Fixed a bug that prevented the rolling of clusters.
API                Fixed a race condition that prevented multiple concurrent requests to 
                   work and returned Forbidden (403).
Snowflake Output   Fixed a bug when writing values to DATE columns.
CDC                Fixed a bug that failed to write data which was larger than 2GB.
Enhancements
Functions          Added the PRESTO_ZIP function
Python             Allow using URLLIB
CDC                 Improved the binlog delay monitor
AWS VPC integration Validated subnet ids in Existing AWS VPC integration
Athena Output       Non-string partition columns now supported
2022/Feb/20
Bug Fixes
Show scaling policy in the Cluster page.
Wurfl User Agent: fixed a bug that appeared when there was more than one wurfl file in the organization.
Fixed a bug that caused the metrics to stop being reported to external monitoring systems (Datadog / Influx).
Deprecated SPLIT, CONCAT and DATE_DIFF functions and introduced new functions:
             - SPLIT:              SPLIT_DELIMITER_FIRST  &  PRESTO_SPLIT
             - CONCAT:         ARRAY_JOIN             &  PRESTO_CONCAT
             - DATE_DIFF:     DATE_DIFF_PRECISE      &  PRESTO_DATE_DIFF

Enhancements
Added function LN.
DATE_DIFF function now supports dynamic units.
LIKE operation now supports getting another field as a pattern.
2022/Feb/08 ANNOUNCEMENT
Recently Implemented Changes (Currently Enabled)
As part of Upsolver's effort to adopt industry standards, we are gradually changing functions to be more Presto compatible. The functions that changed are CONCAT, SPLIT and DATE_DIFF.
CONCAT, SPLIT and DATE_DIFF are being deprecated. Henceforth, SQLs that attempt to use CONCAT, SPLIT and DATE_DIFF will include a warning message when executed. This behavior is designed to draw attention to the changes. Currently running outputs are NOT affected by these changes.
The change log summary:
Important: All information in this table, including planned versions and dates, is subject to change; the information is provided only as a guideline for updates you may make in the future.
Schedule
 Enabled by default in February, 2022 
Functional Area 
SQL Changes - Commands & Functions
Behavior Change
Additional Notes
​ARRAY_JOIN 
The new function name for the
deprecated CONCAT function.
Presto-compatible version of the CONCAT functions:  PRESTO_CONCAT​
​SPLIT_DELIMITER_FIRST 
The new function name for the
deprecated SPLIT Function.
Presto-compatible version of the SPLIT functions: PRESTO_SPLIT​
​DATE_DIFF_PRECISE
The new function name for the
deprecated DATE_DIFF Function.
Presto-compatible version of the DATE_DIFF functions: PRESTO_DATE_DIFF​
2021
2021/10/05
Bug Fixes
MySQL Output: Fixed bug with boolean fields that were not written as expected.
Redshift Output: Fixed race condition in upsert tables that could cause rows not to get deleted in rare cases.
 SQL: 
Improved SQL editor responsiveness.
Fixed a bug in SQL parsing. 
Fixed an exception arising when using infix operations. 
Fixed join/match expressions not working correctly with >3 terms.
API: 
Fixed an issue with distinct data sources that had the same name.
Prevented "SPLIT TABLE ON" on non-Athena Outputs.
Fixed name suggestion in hierarchical Athena outputs.
Enhancements
Azure Event Hubs: Support more features.
Streaming Output: Support setting an upsert key.
ContentTypes:
Support null values in TSV.
Support fixed width content type.
Oracle Object Storage: Various enhancements.
SQL: Support for WHERE filter in sub-select expressions.
S3 Data Source: Don't require AWS integration when creating S3 data source.
S3 Output: Support bucket-level access control.
UI: Added various annotations cluster graphs in the monitoring tab.
2021/08/09
Enhancements
CSV Content Format: allows repeating header names in files.
Function changes: the * CONCAT function was changed to ARRAY_JOIN.
ARRAY_JOIN - gets an array of strings and a delimiter and concats them.
* CONCAT - now gets multiple arguments and concats them (like || in SQL).
Bug Fixes
Athena Output: fixed a performance issue when deleting files due to retention.
Clusters: Show "Additional Processing Units for Replay" only in Compute Clusters.
Redshift Spectrum: fixed boolean casting when running output with SELECT * 
API: Show thrown errors from Hive Metastore.
SQL: Fixed a bug when join with sub-query.
2021/08/02
Enhancements
Support dynamic position in ELEMENT_AT function.
Allow updating the boot script in Clusters.
Support fixed schema in S3 outputs with Avro format. 
Bug Fixes
Fixed a bug when reading from multiple topics in Kafka Data Source.
API - Fixed column name suggester when mapping new fields in Athena Output.
2021/07/19
Bug Fixes
API
Fixed a bug with Azure Integration not working in some regions
Fixed validation when updating Columns Retention in Hive Metastore outputs
Data Source Page: don't show statistics from the preview when querying on a time range without data
Show output's fields on outputs with SELECT *
SQL
Prevent SQL regeneration when updating duplicate handling (APPEND ON DUPLICATE or REPLACE ON DUPLICATE)
Added some validation errors when trying to create invalid state
Backend
Fixed a bug that caused duplicated rows when editing Hive Metastore output with upserts
2021/07/11
Enhancements
Monitoring Reporters: Support Graphite
Hive Metastore Output: support splitting the output by schemas/databases in addition to splitting by table names. For example, if the value of the multi table field is "foo.bar", the "foo" will be the schema/database name, and "bar" will be the table name
Bug Fixes
S3 Data Sources Advanced: Fixed a bug with Glob File Name pattern
Hive Metastore Output: save storage by deleting manifest files after their usage
2021/07/05
Enhancements
Athena output: create Views with Glue API
Bug Fixes
Don't show completed dependencies in Lineage tab
Select * in Hive Metastore Output
Return the defined fields first
Removed the multi table column from the view definitions
Hive Metastore Output: fixed a bug when editing output with upserts
API: Allow changing the cluster size on Trial plans
2021/06/28
Enhancements
Added new modal and new SQL syntax for Table Name Suffix Field, which allow you to create multi tables in Hive Metastore output with a single output.
CDC Data source (MySQL) - added Destination part that allows replicating the source database to your data lake
Qubole Metastore: allow changing the time partition column type to String
Bug Fixes
Fixed health check parameters in Query clusters
Don't show deleting data sources in the main page
Hive Metastore output: added a cache layer in the Partition Manager that prevents redundant calls to the Metastore
API: Limit number of running previews. This should fix high CPU usage of the API when many previews are running in the same time.
2021/06/21
Enhancements
Support Select * in Redshift Spectrum
API: Support Select * and Upserts on Preview
Lookup Table: when running Output with a lookup to a Lookup Table, don't calculate the start/end times of the Lookup Table implicitly but use the original times.
Bug Fixes
SAML: Don't regenerate group when changing display name in Upsolver
Athena Output: fixed bug in Columns Retention
API: Fixed a bug that caused deleted inputs to not work
Snowflake Output: fixed columns casing
Removed "errors" outputs from outputs with Parquet format (Athena/S3)
2021/06/13
Enhancements
CDC ingestion is more stable when scaling cluster
Previewing outputs now considers the upsert definition of it
Compactions are now prioritized by urgency and age in order to prevent starvation
Support epoch time date pattern with prefixes in Cloud Storage Data Sources
Bug Fixes
Fixed database name validation in Microsoft SQL Server Connection
2021/06/07
Enhancements
HiveMetastoreClient: Better SET LOCATION method
2021/05/31
Enhancements
Elasticsearch Output: Support Upsert Keys
CDC: Support Column Exclude List
Added SHA512 and SHA3_512 functions
Bug Fixes
S3 Connection with SQS now works with paths that ends with slash
2021/05/24
Enhancements
Added FROM_UNIXTIME function
Qubole Output: added an option to support changing column types
Hive Metastore Outputs: trigger more than one compaction if there is a backlog
Upsolver Output: support new field type: JSON. This type will be extracted when using as an Upsolver Data Source
CSV Content Format: support custom quote escape char
When duplicating output, copy the workspaces from the previous output
Bug Fixes
Fixed memory leak in External Hive Metastore outputs
2021/05/12
Enhancements
Added External Hive Metastore to the output types list
Support SELECT * on External Hive Metastore when querying with PrestoDB and SparkSQL
Reference Data can now be deleted after output is not using it (i.e. output deleted or output completed and was edited)
Reference Data can't be created with the same name as another Reference data or Lookup table
2021/05/04
Enhancements
Kafka Output - Allow ignoring messages that are too large (According to broker settings and producer settings)
Streaming Data Sources (Kafka, Kinesis, EventHubs) - Allow deleting offsets metadata files
API - Performance enhancements when updating Outputs / Lookup Tables
Bug Fixes
Hive Metastore: Fixed bug with SELECT *
2021/05/03
Features
Support MAX/MIN aggregations on more data types
Support <,<=,>,>= on timestamps
2021/04/18
Features
Support SELECT * in Hive Metastore Outputs, this will update the table definition every time a new field arrives
Oracle Object Storage Support
Bug Fixes
Aggregation calculated fields now works in SQL mode
2021/04/04
Features
CDC (Capture Data Change) Data Sources
Dremio and PrestoDB Outputs
Stop/Start Data Sources
Enhancements
Allow setting Lazy Load on Lookup Tables using the Properties tab
Update base AMI image in AWS to Amazon Linux 2
Bug Fixes
Data Lake Output: Filter out partitions that were deleted due to retention compaction
2021/03/28
Features
Hive Metastore: Allow creating an Output to External Hive Metastore
Enhancements
Lower latencies between dependencies in Compute Cluster
2021/03/21
Features
Ahana Output
Starburst Output
Enhancements
Redshift: Allow inserting 'now' into date / time fields in order to set a column to the insertion time
Bug Fixes
Kinesis Stream Autocomplete filter out Upsolver Internal Streams
Fixed bug in S3 IAM policy generation with slash in end of path
Avro Schema Registry: Don't treat HTTP errors as parse errors
SQL Parser: Don't regenerate the SQL when there is an expression that returns boolean with extra parentheses
2021/03/14
Support Real Time Kafka Output - Support running Kafka Outputs on the Real Time cluster with ms latency
Hive Metastore Output with Upserts - fixed a bug that caused the compaction process to get stuck after edit
Hive Metastore Output with Upserts - support number as an upsert key
Lookup Tables: fixed a bug when using sharded lookup tables in outputs
API: show the current capacity when clicking Update Capacity button on Clusters page
API: fixed wrong validation on Kafka Outputs (support numbers on topic names)
Microsoft SQL Server Output: fixed create statement when primary key is empty
API: fixed a bug when removing mapping of fields
2021/03/07
S3 Data Source with Parquet Content Format - split files by 200MB
Lookup Table - support compaction shards on lookup tables with multiple windows
SQL - fixed a bug generating the SQL when "Is Delete Field" is mapped to a column
2021/03/01
Monitoring: Added three metrics to Hive Metastore Outputs
partitions-delay - The delay between now and the last partition time
data-loading-delay - The delay on loading data to the metastore
partitions-count - Number of partitions in the table
IS_DUPLICATE and Lookup from Data Sources: Don't omit key columns for new versions
Avro: Fixed escaping of [] in array namespaces
Fixes a bug in Snowflake Output with VARIANT column output with arrays
2021/02/23
Azure: Support billing SaaS offering
DNS: Ability to sync Route53 records with private IP addresses for customers with own Spotinst Account
SSO/bugfix: attach endpoints don't have permissions
Partners: Support exporting logs and monitoring to external domain
Free Plan: Support upgrading account
2021/01/04
Snowflake Output: Configurable DbDecimal
CSV Content Type: Don't ignore values starting with #
SQL: Support unmapped columns in JDBC outputs. New mapped columns will be created when deploying the output
Infra: performacne improvements
Lookup Table: fixed a bug when using Delete column
Singup: Create sample data source on register
SQL: Fixed a bug with autocomplete Lookup Table names
SQL: Support Lookup time
Athena Output: Fixed a bug with editing Athena Output when Upsert Partition Fields is true
2020
2020/12/08
JDBC Data Sources: Fixed an issue that could cause it to get stuck and not read any data
JDBC Connections: Fixed an issue that would allow connections to be created with a concurrency of 0
Monitoring: Include the actual time an index is ready to be read form in the monitoring delay charts *
Allow using anonymous credentials to access data in public S3 bucketsA
AppFlow: Autocomplete buckets and flow names during setup
Functions:
Added a Subtract Time Zone Feature to complement Add Time Zone
UI:
Show SQL Errors when deploying Outputs
Show indicative error message when Reference Data file couldn't be found
2020/11/01
Deployment: Allow deploy Upsolver servers to Azure
Add support for Azure EventsHub data source
Athena: Create Glue database if doesn't exist
Functions: Fixed a bug in TO_DATE function
Function: Added new function: RECORD_TO_JSON
Query Cluster: Improvements in the underlying files cache
SQL: Show validation error when mapping an array to unrelated path
SQL: Show validation error when mapping null without specifying type
API: When creating data source, fixed a bug when previewing large file with tar compression
API: Fixed high CPU on boot
2020/10/21
Kafka data source: support reading custom kafka headers
Metastore Ouptut: support running Athena/Qubole output without partitioning by time
Snowflake Output: support Azure storage as the intermediate storage
Compute Cluster Infra: optimize threads when running low priority tasks
ETL: Improved target path inference for some scenarios
Monitoring Task: fixed failure when one of the monitoring reporters is not avaiable
SQL: Fixed validation of inline functions in aggregations
Metastore Output: set the table location to the root path of the output
Qubole: allow defining if TIMESTAMP fields will be created as TIMESTAMP or BIGINT columns in the table per output
Qubole: Added feature flag to deprecate the "SET hive.on.master=?" statement
Elasticsearch Output: Fixed a bug that could cause high memory usage
2020/10/15
Add Amazon AppFlow support
Zip Function- Added optional field names
Api - Fixed validation message for Kafka input
Elastic Search - upgraded client version
2020/10/13
S3 Data source with Parquet Content Format - when the file is not a parquet file, handle it as a parse error
Added Free plan
SQL - Fixed a duplication issue when function target name and select target name are the same
Hive Metastore Output with Upsert keys - Trigger compactions in a better way to avoid compacting in a loop
SQL - Fixed target path inferrence of key columns with inline functions on aggregated outputs
API - Allow setting higher number of shards in the output than number of execution parallelism in the data source. This will parallel the data by the data source files
Support "SELECT * " in cloud storage outputs with parquet content format
API - Fixed a bug that allowed creating more than one draft in the same output
2020/10/05
Show number of sparse fields inside fields tree in inputs and outputs and allow to toggle the filter
2020/10/01
Jdbc data source: use field types from the table definition
PostgreSQL output: support timestamptz data type
UI: New modal when adding multiple fields in tabular outputs to prevent cartesian product between unrelated arrays
No need to specify a target field for filters when creating a filter from the UI
Some bug fixes in API
2020/09/30 - SNAPSHOT
Query Agent - Support round robin
"No Local API" page - Show "Connection Established" instead of error when able to connect
Input creation preview - Filter big JSONs and let the user know about it
2020/09/23
Performance improvements in internal cache mechanism 
Performance improvements in Hive Metastore outputs Raw Blame 
Fixed bug that caused Hive Metastore outputs with upserts to stuck after editing a new version 
Avro w/ Schema Registry Content Format: Support Tagged Avro Schema Registry 
Improved target path calculation of inline functions 
Added validation when deploying a draft that the start time is not after the end time of the previous version 
SQL: Disable automatic column name generation 
Support cancelling pending integration 
2020/09/14
No Local API Page: Fixed showing "You can't connect" instead of "local DNS resolve" error 
CloudFormation: link to the right region in deploy stack 
Less API Calls to Cloud Storage in order to check completion of tasks 
Calculated Function TO_DATE: Changed threshold to not return negative dates 
Fixed bug with PostgreSQL outputs not allowing to alter the column types 
2020/09/07
Support Workspaces in Clusters 
Catch all errors from GCP / Azure and show in UI 
Hive Metastore Outputs: the column names year, month, day, and hour are now reserved 
2020/08/31
Big performance improvements for replay in Kinesis & Kafka Data Sources 
Big performance improvements for replay in Hive Metastore Outputs 
2020/08/24
Compute Cluster: IO Tasks will now run only on Master cluster and will never run on Replay Cluster 
Compute Cluster: Option to limit number of Elastic IPs allocated for the cluster 
Added XX_HASH and SORT_BY calculated functions 
UI : Support literal inputs in aggregations 
2020/08/17
Performance improvements to Hive Metastore Outputs 
Fixed bug with very large parquet file outputs used to make servers crash on OOM 
Preview Output will now stop after 15 seconds instead of making the API server hang 
Support Redshift and PostgreSQL in JDBC Data Source 
UI: Output - New Partitions Modal 
2020/08/10
SQL now supports target site inference, this fixes a lot of confusing bug when using arrays with calculated functions 
SQL: Fixed bug with throwing 500 errors on missing properties of calculated functions 
Athena Output: new outputs will not nest compaction files for better compatibility support with external systems 
2020/08/03
Fixed bug when previewing completed Output with Lookups 
Update Retention validation message is now dismissible 
Regex and Split Content Formats have been added for better compatibility with custom data formats 
2020/07/27
MS SQL Server Output 
Elasticsearch Output: Removed index_type argument, using _doc / doc by default 
UI: overhauled the properties pages 
UI: Split field statistics by Data Source in Output page 
2020/07/20
JSON_TO_RECORD calculated functinon: Allow whitespace in CSV mapping definition and improve exception handling 
Athena Output: Faster replays when run compactions is set to false 
Less red notification errors due to internal errors 
Aggregated Outputs now delete the intermediate aggregations immediately after outputing the data (instead of waiting to the retention period, if defined) 
2020/07/13
MySQL Output: Fixed bug with quote followed by delimiter char inside the data to output 
Create Calculated Function: Fixed a bug with the default output path calculation 
JDBC Data Source now supports creating new tables instead of only inserting data to existing tables 
JDBC Connections: indicative validation error messages on creation 
2020/07/06
PostgreSQL Output 
Writing logs to Customer Bucket now supports writing to specific path in the customer's bucket 
SQL: Show indicative error when trying to filter subquery 
MySQL Output: Fixed writing of date/time fields 
UI: Refined the time range picker 
New boolean operators and calculated functions: AND, OR, NOT, and IS DISTINCT FROM now works like in SQL 
UI: Calculated Functions Gallery now matches to the SQL syntax 
2020/06/29
Redshift: Support configuring 
Added TO_DATE calculated function (converts strings to dates without having to insert format) 
Added APPROX_COUNT_DISTINCT_EACH aggregation 
IAM Role Credentials: Assume role via the Server Role created in the AWS Integration 
Booting a Cluster after stopping it for a while is faster 
SQL: infer null type instead of asking the user to explicit insert the type of the null (null:string) 
SQS: Allow configuring KMS key 
UI: Fixes to "Add Lookup to Data Source" page 
S3: Show the right action on access error
2020/06/22
UI: Charts now shows shared crosshair between graphs 
"Update Shards" error message is now more informative 
Added deployment support to more AWS regions 
Fixed rare case where AWS Redshift Output would duplicate data 
Fixed bug where multiple rows with the same Upsert Key would insert in the same output interval in Snowflake and Redshift Upsert Outputs 
2020/06/15
Git Integration: Don't cancel git integration after one failure to push changes 
UI now allows operating aggregated outputs without key columns (Aggregate all data within the output interval) 
UI: Refinments in the Fields Tree 
Snowflake Output: Better replay performance with sparse Data Sources 
Added EXTRACT, MILLISECOND, SECOND, MINUTE, HOUR, DAY, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_YEAR, WEEK, MONTH, QUARTER, YEAR, and YEAR_OF_WEEK date extraction calculated functions 
Fixed bug with REPLACE calculated function could throw errors in some cases 
2020/06/08
Added RPAD, LPAD, STRPOS, DATE_ADD, and DATE_DIFF calculated functions 
Private API now uses r5 instead of r4 instances in AWS by default 
SQL: Better error messages for inline features 
2020/06/01
The "Archive" operation has removed from the System, Deleted items can be seen using the "Trash" button in the list view 
JDBC Data Source: Support Start Time 
Multiple Bug Fixes in Snowflake Output 
Added DATE_TRUNC calculated function 
Fixed bug with copying big files in S3 
UI Performance enhancements 
2020/05/25
Update Configuration of Upsert Outputs using the UI 
Allow writing logs from Upsolver to Customer requested location as well as Upsolver 
Reduced dramatically the number of API class to Cloud Storage
2020/05/18
Performance improvements and bug fixes
2020/05/04
Data Sources:
JDBC: Added support for connecting to an Oracle DB
Bug fix for event type statistics breakdown in local APIs
Performance and cost improvements
2020/04/27
Revised output preview screen
Minor bug fixes and improvements
2020/04/20
Data Sources:
S3 Over SQS: Allow creating Data Sources from multiple connections with the same prefix
Outputs:
Added output to Snowflake
Monitoring improvements
2020/04/06
Data Sources:
Added properties to Upsolver data source.
Kafka: Added support for custom consumer/producer properties.
Outputs:
UI improvements in sources fields tree
Kafka: Added support for custom consumer/producer properties.
Monitoring Repots:
Added Splunk export support
2020/03/30
UI updates and performance improvements
2020/03/16
Data Sources:
Split meta-data by Event Type field - you are now able to split and view your data source by the desired field in your data source.
Outputs:
SELECT * is supported for Upsolver and Elasticsearch outputs.
Added Amazon Kinesis connector.
Qubole connector now supports using an HTTPs proxy address to override the endpoint used to access Qubole.
IAM:
Added support for SAML with provisioning capabilities.
2020/03/09
Clusters:
Compute cluster monitoring: Compute Units Graph was updated and now provides a breakdown of the compute units used by each task (Data Source/Output/Lookup Table).
2020/02/24
Outputs:
Elasticsearch: Editing the connection string is now supported - as long as the new nodes belong to the same cluster.
Elasticsearch: Added support for setting the event to _doc.
2020/02/18
Transform with SQL:
Added support for partitioning configuration.
Casting improvements.
Outputs:
Redshift: Added support for configuring fail on write error. If enabled, any error while copying data to Redshift will cause the entire bulk to be skipped. The skipped manifest will be saved aside for manual re-processing once the copy error has been fixed. If disabled the same behavior will occur after 100K errors (The max allowed by Redshift).
Monitoring Reporting:
A bug caused false reported delay (in rare cases) was fixed.
2020/02/10
Data Sources:
JDBC Data Source - added support for PostgreSQL.
2020/02/05
Outputs:
Added UUID Generator Calculated Function
Transform with SQL:
Added support for SQL comments using -- (see example below)
Improved error messages
SELECT your_Select_clause -- your comment
FROM your_table -- another comment
2020/01/30
Data Sources:
Parquet reader: support INT96 timestamps and non-canonical field names
Added support for LZO decompression
Added a JDBC connector
Outputs:
Support correcting a specific time frame in an output
Added UpdateSql programmatic API operation for creating outputs
2020/01/22
IAML
Multi-organization support
Outputs:
Support lazy load of lookup tables
Support querying lookup table in SQL
Support sharding of aggregated outputs
Data Sources:
Support S3 data source initial load configuration
Support non-lexicographic date patterns in S3
UI & performance improvements
2020/01/13
Data Sources:
Support XML as content type
2020/01/06
Performance improvements and bug fixes
2019
2019/12/22
Outputs:
Elasticsearch - Add option not to delete indices from Elasticsearch based on retention
Transform with SQL:
Support data source features
UI:
Outputs - Add support for filtering the Preview when in SQL mode
Performance improvements
2019/12/16
Data Sources:
Support changing the number of shards using increments of one (instead of multiplies of two)
Outputs:
Athena - add support for excluding partitions from the table
Transform with SQL:
Support default field names instead of col_x
Generate SQL for running Outputs
Refer to fields by index in the GROUP BY statement
2019/12/09
UI improvements and bug fixes
Behavior Change	Additional Notes
ARRAY_JOIN The new function name for the deprecated CONCAT function.	Presto-compatible version of the CONCAT functions: PRESTO_CONCAT
SPLIT_DELIMITER_FIRST The new function name for the deprecated SPLIT Function.	Presto-compatible version of the SPLIT functions: PRESTO_SPLIT
DATE_DIFF_PRECISE The new function name for the deprecated DATE_DIFF Function.	Presto-compatible version of the DATE_DIFF functions: PRESTO_DATE_DIFF