18.1. Teradata Additions
The following are additions that Teradata has added on top Facebook’s 0.148 release of Presto
- Fix issue “Hive table is corrupt. It is declared as being bucketed, but the files do not match the bucketing declaration. The number of files in the directory (1) does not match the declared.” by fixing support for Hive bucketed tables. See option
hive.multi-file-bucketing.enabledin the Presto Hive connector documentation.
- Fix issue “low must be less than or equal to high” that can occur with ORC and Character data.
Add support for Prepared statements and parameters via sql syntax.
- DEALLOCATE PREPARE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
Add FLOAT support to the Hive connector Add Char support to Hive connector Additional Varchar(x) function implementations Additional Decimal functions implementations
Additional Kerberos Grant/Revoke Presto-Admin Presto YARN Integration Presto Ambari Integration TINYINT, SMALLINT, INTEGER
Windows Functions with identical specifications merged to share work
Add support for running regular expression functions using the more efficent re2j-td library by setting the session
regex_library to RE2J. The memory footprint can be adjusted by setting
Additionally, the number of times the re2j library falls back from its DFA algorithm to the NFA algorithm (due to
hitting the states limit) before immediately starting with the NFA algorithm can be set with the
18.2. Discontinue to support
Implicit casts from Varchar(x) to date types are no longer supported.