Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread Carl Steinbach
Hi Vaibhav, ror output when i run isql hive > > [-]SQL_SUCCESS > [-]hEnv = $09BF20A0 phDbc = $0804E2FC > [-]SQL_SUCCESS > [ISQL]ERROR: Could not SQLConnect > Did you remember to start the HiveServer process? Do you have the driver configured to use the right IP address and port numbe

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread vaibhav negi
HI Ning , output of ldd isql is :- [r...@vmlinux3 ~]# ldd /usr/local/bin/isql linux-gate.so.1 => (0x00d7a000) libodbc.so.1 => /usr/local/lib/libodbc.so.1 (0x0045c000) libdl.so.2 => /lib/libdl.so.2 (0x00548000) libreadline.so.5 => /usr/lib/libreadline.so.5 (0x005ea

Re: Error in metadata: javax.jdo.JDOFatalDataStoreException

2011-01-05 Thread Adarsh Sharma
John Sichi wrote: Since the exception below is from JDO, it has to do with the configuration of Hive's metastore (not HBase/Zookeeper). JVS On Jan 5, 2011, at 2:14 AM, Adarsh Sharma wrote: Dear all, I am trying Hive/Hbase Integration from the past 2 days. I am facing the below issue w

MySQL Metastore migration

2011-01-05 Thread Chris Bates
Hi all, We've been running hive in the default derby single user mode for a while. Now we've got more users interested in Hive and so would like to change the metastore to run off of mysql. I was able to find a pretty easy tutorial for doing this at this blog: http://blog.milford.io/2010/06/ins

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread Ning Zhang
It looks like isql cannot find the dynamically linked libraries. Can you ldd isql and see if all dynamically linked libraries are correct? On Jan 5, 2011, at 5:29 AM, vaibhav negi wrote: > Hi Carl, > > Downloaded the patched version of unixODBC from the given link and > installed successfully

Re: HIVE SERVER in background

2011-01-05 Thread vaibhav negi
thanks wjh and pavan Vaibhav Negi On Thu, Dec 30, 2010 at 7:39 PM, Pavan Yara wrote: > nohup hive --service hiveserver & > > u can get logs written to terminal in nohup.out > > -- > Best Regards, Pavan > Sent from my Nokia N900 > - Original message - > > Hi All, > > > > How to run Hive

Re: Error in metadata: javax.jdo.JDOFatalDataStoreException

2011-01-05 Thread vaibhav negi
Hi Adarsh, It may be because of wrong configuration to meta store server/lack of access rights . Vaibhav Negi On Wed, Jan 5, 2011 at 11:04 PM, Jean-Daniel Cryans wrote: > With one cluster you really only need one, and it doesn't seem to be > running from what I can tell: > > 2011-01-05 15:20:1

Re: Error in metadata: javax.jdo.JDOFatalDataStoreException

2011-01-05 Thread John Sichi
Since the exception below is from JDO, it has to do with the configuration of Hive's metastore (not HBase/Zookeeper). JVS On Jan 5, 2011, at 2:14 AM, Adarsh Sharma wrote: > > > > > Dear all, > > I am trying Hive/Hbase Integration from the past 2 days. I am facing the > below issue while c

Re: Error in metadata: javax.jdo.JDOFatalDataStoreException

2011-01-05 Thread Jean-Daniel Cryans
With one cluster you really only need one, and it doesn't seem to be running from what I can tell: 2011-01-05 15:20:12,185 WARN zookeeper.ClientCnxn (ClientCnxn.java:run(967)) - Exception closing session 0x0 to sun.nio.ch.selectionkeyi...@561279c8 java.net.ConnectException: Connection refused An

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread vaibhav negi
Hi Carl, Downloaded the patched version of unixODBC from the given link and installed successfully . libodbchive.so gets generated in /usr/local/lib . But still the error persists. error output when i run isql hive [-]SQL_SUCCESS [-]hEnv = $09BF20A0 phDbc = $0804E2FC [-]SQL_SUCCESS

Error in metadata: javax.jdo.JDOFatalDataStoreException

2011-01-05 Thread Adarsh Sharma
Dear all, I am trying Hive/Hbase Integration from the past 2 days. I am facing the below issue while creating external table in Hive. *Command-Line Error :- *had...@s2-ratw-1:~/project/hive-0.6.0/build/dist$ bin/hive --auxpath /home/hadoop/project/hive-0.6.0/build/dist/lib/hive_hbase-han

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread Carl Steinbach
Hi Vaibhav, > i cannot find libodbchive.so in /usr/local/lib . So i defined odbc hive > driver as libodbc.so . Is that the problem? > > libodbc.so is the ODBC DriverManager library provided by unixODBC. You should not rename or symlink this file. I think your problem is that you forgot to patch t