Unsupported interfaces

If you used some of the Apache Hive interfaces that are no longer supported, alternatives might be available, such as Data Analytics Studio which you can use in lieu of Hive View.

CDP does not support the following interfaces that were available in HDP and CDH platforms.

S3 for storing tables and LLAP (available in CDP Public Cloud only)
Hive CLI (replaced by Beeline)
WebHCat
Hcat CLI
SQL Standard Authorization
MapReduce execution engine (replaced by Tez)
Spark execution engine (replaced by Tez)
Hive Indexes
Hive View and Tez View

You can use Data Analytics Studio in lieu of Hive View.

Partially unsupported interfaces

Apache Hadoop Distributed Copy (DistCP) is not supported for copying Hive ACID tables. See link below.

Unsupported Features

CDP does not support the following features that were available in HDP and CDH platforms:

CREATE TABLE that specifies a managed table location
Do not use the LOCATION clause to create a managed table. Hive assigns a default location in the warehouse to managed tables.
CREATE INDEX
Hive builds and stores indexes in ORC or Parquet within the main table, instead of a different table, automatically. Set hive.optimize.index.filter to enable use (not recommended--use materialized views instead). Existing indexes are preserved and migrated in Parquet or ORC to CDP during upgrade.
Hive metastore (HMS) high availablility (HA) load balancing
You need to set up HMS HA as described in the documentation (see link below).

Unsupported Connector Use

CDP does not support the Sqoop exports using the Hadoop jar command (the Java API) that Teradata documents. For more information, see link below.