Support Forums : DataStax

What is the correct procedure for dropping a hive table that is backed by a cassandra column family?

(3 posts) (2 voices)

Tags:

No tags yet.

SVBridget
Member

Would someone be able to describe the steps for dropping a hive table backed by cassandra?

I am creating cassandra column families, then using hive create table to tell hive about the cassandra column family. However, if I do a hive drop table, then show tables, the hive table is still there (even after restarting everything). Do I have to also drop the cassandra column family in order to make the hive side go away? (That would be inconvenient while we are trying out different ways of modeling in hive.) But in any case, I'd just like to know the proper sequence.

Thanks!
-B

Posted 1 year ago #
SVBridget
Member

So it seems that you can't drop or alter any table that you create by hand in a hive database that was auto-magically created from a cassandra keyspace. If you create your own hive database, then create hive tables that point to cassandra column families, then you can alter and drop those kinds of hive tables. IMO this is a bug - either you shouldn't be able to create any tables in auto-magically mapped hive databases, OR you should be able to alter and drop the tables you create by hand in an auto-magically mapped hive database.

Posted 1 year ago #
blueplastic
Member

Also, I just noticed that before deleting a table in Hive, you may have to first delete the Column Family from Casandra-CLI. Then go back into Hive prompt and run: drop table KeySpaceName.ColumnFamilyName;

Posted 1 year ago #

You must log in to post.