how to mount an existing table?

2010-12-29 Thread Hiller, Dean (Contractor)
I finally have hive working. I can create tables and it makes complete since that hive stores the metadata since hbase is completly open, but how do I mount an existing table which already has 13gig of data??? Actually, it came from a 1.6 gig file. Is it weird that I loaded a 1.6 gig

RE: hive installation

2010-12-29 Thread Hiller, Dean (Contractor)
Ah, sweet...ok, I didn't know hive was reading stdout for that. I had some echo's in there to log some info as I added a debug line that I can flip on and off and other echo statements. Thanks! Dean -Original Message- From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Wedn

Re: hive installation

2010-12-29 Thread Edward Capriolo
On Wed, Dec 29, 2010 at 11:20 AM, Hiller, Dean (Contractor) wrote: > I don't' understand.  I can run "hadoop" from anywhere.  ie. It's in my path > as in > > [r...@dnvr-dev1 ~]# echo $PATH > /opt/jdk1.6.0_23/bin:/opt/hive-0.6.0-bin/bin:/opt/hadoop-install/hadoop/bin:/usr > /kerberos/sbin:/u

RE: hive installation

2010-12-29 Thread Hiller, Dean (Contractor)
I don't' understand. I can run "hadoop" from anywhere. ie. It's in my path as in [r...@dnvr-dev1 ~]# echo $PATH /opt/jdk1.6.0_23/bin:/opt/hive-0.6.0-bin/bin:/opt/hadoop-install/hadoop/bin:/usr /kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/ sbin:/usr/bin:/r

Re: hive installation

2010-12-29 Thread Edward Capriolo
On Wed, Dec 29, 2010 at 8:45 AM, Hiller, Dean (Contractor) wrote: > I ran into “Unable to determine Hadoop version information” > > > > Google found > > some post referring to some build/dist directory that I can only have if I > checkout the source(I downloaded the binary instead).  Do I have to

Re: Partitioning External table

2010-12-29 Thread Ted Yu
Can you try using: location 'dt=1/engine' Cheers On Wed, Dec 29, 2010 at 1:12 AM, David Ginzburg wrote: > Hi, > Thank you for the reply. > I tried ALTER TABLE tpartitions ADD PARTITION (dt='1') LOCATION > '/user/training/partitions/'; > SHOW PARTITIONS > tpartitions; > > OK > dt=1 > > > but

hive installation

2010-12-29 Thread Hiller, Dean (Contractor)
I ran into "Unable to determine Hadoop version information" Google found some post referring to some build/dist directory that I can only have if I checkout the source(I downloaded the binary instead). Do I have to checkout and build source or is there changes to the binary? http://osdir

RE: Partitioning External table

2010-12-29 Thread David Ginzburg
Hi, Thank you for the reply. I tried ALTER TABLE tpartitions ADD PARTITION (dt='1') LOCATION '/user/training/partitions/'; SHOW PARTITIONS tpartitions; OK dt=1 but when I try to issue a select query , I get the followi