@ThinkBig Upgrades from HDP 3.x to CDP Private Cloud Base are not currently supported. The best way is to build new CDP cluster and then migrate the Data using Replication Manager or any alternate way which suits you.    Refer the Supported Upgrade Path: https://docs.cloudera.com/cdp-private-cloud/latest/upgrade/topics/cdpdc-upgrade-paths.html Use of Replication Manager: https://docs.cloudera.com/cdp-private-cloud/latest/data-migration/topics/cdp-data-migration-replication-manager-to-cdp-data-center.html Also I would encourage you to contact Cloudera for planning a better migration plan since you already have subscription.  ... View more

I don't think that it (Cloudera ODBC driver doesn't support insert) is true. By defining table as transcational table, you can insert data.   CREATE TABLE insert_test( column1 string, column2 string) clustered by (column1) into 3 buckets stored as orcfile TBLPROPERTIES ('transactional'='true');   insert into table efvci_lnd_edw_dev.insert_test values('1', 'One'); insert into table efvci_lnd_edw_dev.insert_test values('2', 'Two');   Thanks, Chirag Patel   ... View more