http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 16:45:24 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-4277 Mon, 30 Jul 2012 16:58:13 +0000 alexliu 4277@http://www.datastax.com/support-forums/ <p>You can use Alter table to change the table name. But you can't directly create a different name table form the cassandra column family name. </p> http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-3917 Thu, 26 Jul 2012 21:36:34 +0000 jonusko 3917@http://www.datastax.com/support-forums/ <p>I wanted to see if creating external tables in Hive work using a table name that is different from the Cassandra table name. However, I can no longer get Hive to run since I manually deleted a database in the MetaStore. </p> http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-3915 Thu, 26 Jul 2012 21:26:08 +0000 xedin 3915@http://www.datastax.com/support-forums/ <p>Ok, thank you for the information! </p> http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-3914 Thu, 26 Jul 2012 21:25:25 +0000 jonusko 3914@http://www.datastax.com/support-forums/ <p>I am using DSE 2.1. </p> http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-3910 Thu, 26 Jul 2012 20:12:02 +0000 xedin 3910@http://www.datastax.com/support-forums/ <p>Thanks for reporting this problem! This sounds like a bug, we will create an issue and investigate the cause. What version of DSE you are you currently using? </p> http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-3907 Thu, 26 Jul 2012 19:47:00 +0000 jonusko 3907@http://www.datastax.com/support-forums/ <p>It appears that create external table always fails if the table has already been created in Cassandra. It does not look like one can create a table in Hive that only references some of the columns in the Cassandra table. </p> http://www.datastax.com/support-forums/topic/creating-external-hive-table-fails#post-3355 Fri, 20 Jul 2012 23:11:26 +0000 jonusko 3355@http://www.datastax.com/support-forums/ <p>Creating an external table in Hive displays an error if the table already exists in another keyspace. However, it appears that the Hive table was created. Steps to reproduce:</p> <p>Using CQL...</p> <p>1) Create a keyspace "Company1" with a replication factor = 1.<br /> 2) Create a table "TestTable" in Company1;<br /> 3) Insert a row of data in Company1.TestTable.<br /> 4) Create a keyspace "Company2" with a replication factor = 1.<br /> 5) Create a table "TestTable" in Company2;<br /> 6) Insert a row of data in Company2.TestTable. (Use different values.)</p> <p>Using Hive...<br /> 7) Create an external table "TestTable" with cassandra.ks.name = "Company1".<br /> 8) Create an external table "TestTable" with cassandra.ks.name = "Company2".</p> <p>Step #8 will cause and error: AlreadyExistsException(message: Table TestTable already exists)</p> <p>However, if you "use Company2" and "show tables", TestTable exists. Selecting the data in TestTable displays the correct data. Using Company1 also displays the correct data.</p> <p>Is this error incorrect? Can Hive contain identical table names from two different keyspaces? </p>