http://www.datastax.com/support-forums/topic/how-do-i-update-hive-table-when-columns-are-added-to-cassandra Software, Support, and Training for Apache Cassandra en-US Sun, 26 May 2013 02:00:12 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/how-do-i-update-hive-table-when-columns-are-added-to-cassandra#post-4283 Mon, 30 Jul 2012 17:14:11 +0000 alexliu 4283@http://www.datastax.com/support-forums/ <p>Drop HiveMetaStore keyspace and MetaStore column family. Then restart DSE, restart HIVE, you should have a fresh start. </p> http://www.datastax.com/support-forums/topic/how-do-i-update-hive-table-when-columns-are-added-to-cassandra#post-3916 Thu, 26 Jul 2012 21:34:11 +0000 jonusko 3916@http://www.datastax.com/support-forums/ <p>Yes. I was starting/stopping cqlsh and dse hive from the same shell prompt and never had them running at the same time.</p> <p>I tried a lot of things to make this work, one of them was to delete the Hive database definition in the HiveMetaStore.MetaStore. I only deleted the one row in the MetaStore that corresponded with my Hive database. Now, Hive will no longer run properly. When I try to "use" any database in Hive, I get an OutOfMemoryError: GC overhead limit reached. I tried restarting dse cassandra and dse hive, but Hive still is broken. Is there anyway to fix Hive? </p> http://www.datastax.com/support-forums/topic/how-do-i-update-hive-table-when-columns-are-added-to-cassandra#post-3909 Thu, 26 Jul 2012 20:02:44 +0000 tjake 3909@http://www.datastax.com/support-forums/ <p>Did you restart Hive before #6? </p> http://www.datastax.com/support-forums/topic/how-do-i-update-hive-table-when-columns-are-added-to-cassandra#post-3906 Thu, 26 Jul 2012 19:44:38 +0000 jonusko 3906@http://www.datastax.com/support-forums/ <p>If I define all the columns for a column family in Cassandra, I see that they are automatically defined in Hive. If I use ALTER TABLE to add a column in Cassandra, this column does not get added to the Hive metastore thus it is not visible to Hive. Hive does not let me modify an external table. So how do I get my Hive table back in sync with the Cassandra column family?</p> <p>Steps to reproduce:<br /> 1) Create table in cqlsh.<br /> 2) Insert row in table using cqlsh.<br /> 3) Select row in Hive to verify the data.<br /> 4) Alter table in cqlsh and add a new column.<br /> 5) Update new column with a value in cqlsh.<br /> 6) Select row in Hive to verify the new column's data.</p> <p>In step #6, select * does not return the new column and select newColumn returns an error. </p>