hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tali K <ncherr...@hotmail.com>
Subject Help needed: Can't drop or alter a table , but can create a new table and run queries
Date Wed, 02 Feb 2011 19:00:41 GMT




Hi All,
I can't drop or alter tables, but can create a new one and load data , and run some queries.
When I try to alter or drop a table I get :
ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" 
requires "org.eclipse.core.resources" but it cannot be resolved.

We are using hive 0.6 , hadoop 0.20.2 and postgres 

 hive -hiveconf hive.root.logger=INFO,console
Hive history file=/tmp/hadoop/hive_job_log_hadoop_201102021037_1234928781.txt
11/02/02 10:37:14 INFO exec.HiveHistory: Hive history file=/tmp/hadoop/hive_job_log_hadoop_201102021037_1234928781.txt
hive> alter table roger_cog_id_to_cog_ rename to roger_cog_id_to_cog;
11/02/02 10:37:18 INFO parse.ParseDriver: Parsing command: alter table roger_cog_id_to_cog_
rename to roger_cog_id_to_cog
11/02/02 10:37:18 INFO parse.ParseDriver: Parse Completed
11/02/02 10:37:18 INFO ql.Driver: Semantic Analysis Completed
11/02/02 10:37:18 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null)
11/02/02 10:37:18 INFO ql.Driver: Starting command: alter table roger_cog_id_to_cog_ rename
to roger_cog_id_to_cog
11/02/02
 10:37:18 INFO metastore.HiveMetaStore: 0: Opening raw store with 
implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
11/02/02 10:37:18 INFO metastore.ObjectStore: ObjectStore, initialize called
11/02/02
 10:37:18 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" 
requires "org.eclipse.core.resources" but it cannot be resolved.
11/02/02
 10:37:18 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" 
requires "org.eclipse.core.runtime" but it cannot be resolved.
11/02/02 10:37:18 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" requires "org.eclipse.text"
but it cannot be resolved.
11/02/02 10:37:19 INFO metastore.ObjectStore: Initialized ObjectStore
11/02/02 10:37:20 INFO metastore.HiveMetaStore: 0: get_table : db=default tbl=roger_cog_id_to_cog_
11/02/02
 10:37:20 INFO hive.log: DDL: struct roger_cog_id_to_cog_ { string 
query_id, string cat, string cog_id, string annotation}
11/02/02 10:37:20 INFO metastore.HiveMetaStore: 0: alter_table: db=default tbl=roger_cog_id_to_cog_
newtbl=roger_cog_id_to_cog


 		 	   		  
Mime
View raw message