DROP actually doesn't work on our current production version of Cassandra (1.2). It's not supported until 2.0.

For now I think it may just have to remain there as an unused column.