RE: Can't drop table

We have a similar problem with not being able to drop tables, using Hive 0.6 and Hadoop 20.0 along with Postgres. Can you share with us the schema you created? We are wondering if the schema that was automatically created in our case is somehow incomplete. Thanks, Tali Date: Mon, 17 Jan

Help needed: Can't drop or alter a table , but can create a new table and run queries

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 , ha

java.lang.IllegalStateException: Shutdown in progress

Hi All, My hive jobs all finished successfully, output file created, hadoop job -list, displays no running jobs. I run hive -e ''> myfile. All Map/reduces are done and than I see 'OK' forever, until I kill this job with Ctrl C. Than I get an Exception:java.lang.IllegalStateExcept

Help: Could not obtain block: blk_ Exception

Hi All, I am getting Could not obtain block: blk_2706642997966533027_4482 file=/user/outputwc425729652_0/part-r-0 I checked the file is actually there. What I should do? Please help. Could not obtain block: blk_2706642997966533027_4482 file=/user/outputwc425729652_0/part-r-0

Help: Could not obtain block: blk_ Exception

Hi All, I am getting Could not obtain block: blk_2706642997966533027_4482 file=/user/outputwc425729652_0/part-r-0 I checked the file is actually there. What I should do? Please help. Could not obtain block: blk_2706642997966533027_4482 file=/user/outputwc425729652_0/part-r-0

Load data into HIVE from HDFS Clarification

When one loads data to hive , if the file is in hdfs, it is moved into the Hive-controlled file system namespace. and deleted from hdfs. Is it possible to change it so , file wouldn't be moved, but copied?

RE: Ctrl C and Hive ?

that I'll have prompt to run another query. Sincerely, Tali > Date: Tue, 7 Dec 2010 15:31:11 -0500 > Subject: Re: Ctrl C and Hive ? > From: edlinuxg...@gmail.com > To: user@hive.apache.org > > On Tue, Dec 7, 2010 at 3:18 PM, Tali K wrote: > > 1) When I cancel hi

Ctrl C and Hive ?

1) When I cancel hive job with Ctrl C, I noticed that java/hive processes still run on some of my nodes. I shutdown hadfoop, and restarted it, but noticed that 2 or 3 java/hadoop processes were still running on each node. So we went to each node and did a 'killall java' - in some cases I had to

RE: Caused by: javax.jdo.JDODataStoreException: Exception thrown while querying indices for table=DBS: HELP need

upgrade script? This is a requirement if you are upgrading from an older version of Hive to version 0.6. Thanks. Carl On Fri, Dec 3, 2010 at 1:31 PM, Tali K wrote: Hi All, We installed a new hive distribution - 0.6. We copied this 2 jars to the hive/lib directory. postgresql-9.0-801.jdbc4.jar

Caused by: javax.jdo.JDODataStoreException: Exception thrown while querying indices for table=DBS: HELP need

Hi All, We installed a new hive distribution - 0.6. We copied this 2 jars to the hive/lib directory. postgresql-9.0-801.jdbc4.jar jdo2-core-2.0.jar We are getting this exception Caused by: javax.jdo.JDODataStoreException: Exception thrown while querying indices for table=DBS NestedThrowables: