22.14. Release 0.148-t.1.2
Presto 0.148-t.1.2 is equivalent to Presto release 0.148, with some additional features.
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
Discontinue to support
In 0.141-t, implicit casts from Varchar(x) to Data types were allowed. This does not work in 0.148-t and will not be supported.
Some functionality from Presto 0.148 may work but is not officially supported by Teradata.
- The installation method as documented on prestodb.io.
- Web Connector for Tableau
- The following connectors: * Cassandra Connector * Kafka Connector * Local File Connector * MongoDB Connector * Redis Connector
- Developing Plugins
- The SQL keyword
endis used as a column name in
system.runtime.queries, so in order to query from that column,
endmust be wrapped in quotes
NATURAL JOINis not supported
EXCEPTare not supported
OFFSETare not supported
- Correlated Subqueries
Hive Connector Limitations
Teradata supports data stored in the following formats:
- Text files
Presto supports a granularity of milliseconds for the
TIMESTAMP datatype, while Hive
TIMESTAMP values in tables are parsed according to the server’s timezone. If this is not what you want, you must
start Presto in the UTC timezone. To do this, set the JVM timezone to UTC:
-Duser.timezone=UTC and also add the
following property in the Hive connector properties file:
Presto’s method for declaring timestamps with/with out timezone is not sql standard. In Presto, both are declared using
TIMESTAMP '2003-12-10 10:32:02.1212' or
TIMESTAMP '2003-12-10 10:32:02.1212 UTC'.
The timestamp is determined to be with or without timezone depending on whether you include a time zone at the end of
the timestamp. In other systems, timestamps are explicitly declared as
TIMESTAMP WITH TIME ZONE or
TIMESTAMP WITHOUT TIME ZONE (with
TIMESTAMP being an alias for one of them). In these systems, if you declare a
TIMESTAMP WITHOUT TIMEZONE, and your string has a timezone at the end, it is silently ignored. If you declare a
TIMESTAMP WITH TIME ZONE and no time zone is included, the string is interpreted in the user time zone.
INSERT INTO ... VALUES limitations
The data types must be exact, i.e. must use
cast('2015-1-1' as date) for
date, and you must supply a value for every column.
INSERT INTO ... SELECT limitations
INSERT INTO creates unreadable data (unreadable both by Hive and Presto) if a Hive table has a schema for which Presto only interprets some of the columns (e.g. due to unsupported data types). This is because the generated file on HDFS will not match the Hive table schema.
If called through JDBC, executeUpdate does not return the count of rows inserted.
Hive Parquet Issues
PARQUET support in Hive imposes more limitations than the other file types.
BINARYdatatypes are not supported
PostgreSQL and MySQL Connectors Limitations
describe table reports
Table has no supported column types inappropriately.
Presto connects to MySQL and PostgreSQL using the credentials specified in the properties file. The credentials are used to authenticate the users while establishing the connection. Presto runs queries as the “presto” service user and does not pass down user information to MySQL or PostgreSQL connectors.
PostgreSQL and MySQL each support a wide variety of datatypes (PostgreSQL datatypes, MySQL datatypes). Many of these
types are not supported in Presto. Table columns that are defined using an unsupported type are not visible to Presto
users. These columns are not shown when
describe table or
select * SQL statements are executed.
CREATE TABLE (...) does not work, but
CREATE TABLE AS SELECT does.
INSERT INTO is not supported
DROP TABLE is not supported.
Limited SQL push-down
Presto does not “push-down” aggregate calculations to PostgreSQL or MySQL. This means that when a user executes a
simple query such as
SELECT COUNT(*) FROM lineitem the entire table will be retrieved and the aggregate calculated
by Presto. If the table is large or the network slow, this may take a very long time.
MySQL catalog names are mapped to Presto schema names.
Teradata JDBC Driver
The Teradata JDBC driver does not support batch queries.