RE: Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-18 Thread Vivek Mishra
Hi, Additionally, verify this property javax.jdo.option.ConnectionURL jdbc:derby:;databaseName=metastore_db;create=true JDBC connect string for a JDBC metastore in hive-default.xml From: Jasper Knulst [jasper.knu...@incentro.com] Sent: 18 December 2011 23

Re: Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-18 Thread Jasper Knulst
Hi Periya, Try removing both .lck (lock) files in the metastore_db folder. The derby db can only support one user. So if you have used hive from cli it is probably for another user. Cheers, Jasper Op 18 dec. 2011 17:42 schreef "Periya.Data" het volgende: > Hi Vivek, >Tried doing with sudo a

Re: Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-18 Thread Periya.Data
Hi Vivek, Tried doing with sudo and later also changed the permissions. None of them worked. root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# ls -l total 4 drwxr-xr-x 5 root root 4096 2011-12-18 03:19 metastore_db root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# chmod 777 metastore_db/

RE: Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-18 Thread Vivek Mishra
try issuing with "sudo". as metastore_db is locked for root user. else do sudo chmod 777 folder. Vivek From: Periya.Data [periya.d...@gmail.com] Sent: 18 December 2011 10:29 To: user@hive.apache.org Subject: Hive server not starting...on EC2 Ubuntu 10.04

RE: hive select count(*) query exception

2011-12-18 Thread Vivek Mishra
did you copy same jars in classpath for hadoop? hadoop_home for hive is set to this only? i tried with 0.20.2 version from apache site only! From: jingjung Ng [jingjun...@gmail.com] Sent: 18 December 2011 11:02 To: user@hive.apache.org Subject: Re: hive s