Handling schema changes (deprecated)

If you change a table in Cassandra after creating an external table in Hive that maps to that table in Cassandra, a runtime exception can occur. Use a workaround when changes that occur to the table in Cassandra get out of sync with the mapped table in Hive.

Hadoop is deprecated for use with DataStax Enterprise. DSE Hadoop and BYOH (Bring Your Own Hadoop) are deprecated. Hive is also deprecated and will be removed when Hadoop is removed.

If you change a table in Cassandra, using CQL for example, after creating an external table in Hive that maps to that table in Cassandra, a runtime exception can occur. Changes that occur to the table in Cassandra get out of sync with the mapped table in Hive. The workaround is:

Procedure

  1. In Hive, drop the table.
    hive> drop table mytable;
  2. Run SHOW TABLES.
    hive> show tables;

    Now, the table in Hive contains the updated data.