Re: Migrating Tables with primary key and foreign key from mysql to Hbae
Hi Jean, Thanks A lot for reply, I got your point about HBASE , let me give a little clear picture of what I am desiring from HBase , If any body is willing to migrate ones application on Hadoop and at teh same time migrate Mysql database to Hbase to get the advantage of the Hbase in that case if migrate Mysql databae or any relational database to Hbase using tools like sqoop , but as the database in mysql has tables relation's maintained with foreign key , primary key so what need to be done Hbase side to maintain the integrity and dependency of one data on the other or its totally a bad idea to migrate from Relational database to Hbase. PLease through some light on that if possible. And I am sure many people must have faced this situation while working wkith Hadoop, Hbase for first time. REgards Neetu On Wed, Mar 28, 2012 at 12:43 AM, Jean-Daniel Cryans jdcry...@apache.orgwrote: Hi, HBase is not a relational database, it doesn't have foreign keys or constraints. I'd suggest you familiarize yourself with HBase by reading the refence manual[1] or buying the book[2]. Regards, J-D 1. http://hbase.apache.org/book/book.html 2. http://www.amazon.com/dp/1449396100 On Tue, Mar 27, 2012 at 5:25 AM, Neetu Ojha neetuojha.c...@gmail.com wrote: Dear all, I used sqoop tool to migrate the mysql table to hbase but I have not got any clearity yet that how the primary keys and foreign keys are preserved in Hbase for the tables migrated from mysql database to hbase so that user can access the tables from hbase with having the assurance of the data integrity and behaviour as it was on Mysql database. My idea is ti present Hbase as Cloud storage solution and where users can migrate there mysql database to Hbase and the behaviour and data integrity is entact too. If any one has experience of the same or idea please share with me. Thanks Regards Neetu
hbase-0.90.4 unable to execute java application to retrieve hbase table
Hello, I have installed HBase-0.90.4 on my local machine and as shown in quick start i installed/configured in standalone mode using my local file system of fedora-15. I have not started hadoop daemon assuming that its not needed as its completely standalone config. All the required libs that comes with the package are there. I faced lot of difficulty in compiling the simple code itself.I set CLASSPATH, in hbase-env.sh set HBASE_CLASSPATH but now it doen'n run. I took a code from the net and has created the required table in the hbase. When I am trying to execute a very basic java code using Hbase-0.90.4 API. some how it compiled but on execution it throws exception: java MyLittleHBaseClient Exception in thread main java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.apache.hadoop.conf.Configuration.clinit(Configuration.java:139) at MyLittleHBaseClient.main(MyLittleHBaseClient.java:21) Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory at java.net.URLClassLoader$1.run(URLClassLoader.java:217) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:205) at java.lang.ClassLoader.loadClass(ClassLoader.java:321) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294) at java.lang.ClassLoader.loadClass(ClassLoader.java:266) ... 2 more Kindly see if any one has experienced the same issue at any point of time. As for me its a long way ahead, hbase over HDFS and then hadoop cluster... Thanks Regards Neetu sharma
Re: hbase-0.90.4 unable to execute java application to retrieve hbase table
Thanks A lot! Well Ulrich i am not at alll aware of maven!!! Regards Neetu Sharma On Thu, Jan 5, 2012 at 3:53 PM, Ulrich Staudinger ustaudin...@activequant.com wrote: That's more a java related question. With maven it is pretty straightforward to get this up and running, without altering the CLASSPATH or even having HBase installed on your machine. Do you use maven? On Thu, Jan 5, 2012 at 10:34 AM, Neetu Ojha neetuojha.c...@gmail.com wrote: Hello, I have installed HBase-0.90.4 on my local machine and as shown in quick start i installed/configured in standalone mode using my local file system of fedora-15. I have not started hadoop daemon assuming that its not needed as its completely standalone config. All the required libs that comes with the package are there. I faced lot of difficulty in compiling the simple code itself.I set CLASSPATH, in hbase-env.sh set HBASE_CLASSPATH but now it doen'n run. I took a code from the net and has created the required table in the hbase. When I am trying to execute a very basic java code using Hbase-0.90.4 API. some how it compiled but on execution it throws exception: java MyLittleHBaseClient Exception in thread main java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.apache.hadoop.conf.Configuration.clinit(Configuration.java:139) at MyLittleHBaseClient.main(MyLittleHBaseClient.java:21) Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory at java.net.URLClassLoader$1.run(URLClassLoader.java:217) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:205) at java.lang.ClassLoader.loadClass(ClassLoader.java:321) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294) at java.lang.ClassLoader.loadClass(ClassLoader.java:266) ... 2 more Kindly see if any one has experienced the same issue at any point of time. As for me its a long way ahead, hbase over HDFS and then hadoop cluster... Thanks Regards Neetu sharma -- Ulrich Staudinger http://goog_958005736http://www.activequant.com Connect online: https://www.xing.com/profile/Ulrich_Staudinger
Re: hbase-0.90.4 unable to execute java application to retrieve hbase table
Hi Ulrich Thanks a lot again!!! Regards Neetu On Thu, Jan 5, 2012 at 5:22 PM, Ulrich Staudinger ustaudin...@activequant.com wrote: I just checked and I also include the hadoop dependency and exclude several packages from. see http://activequant.org/svn/aq2o/trunk/pom.xml for a working pom. On Thu, Jan 5, 2012 at 12:50 PM, Ulrich Staudinger ustaudin...@activequant.com wrote: With maven it becomes quite trivial to create an hbase app. You would add the hbase dependency: dependency groupIdorg.apache.hbase/groupId artifactIdhbase/artifactId version${hbase.version}/version /dependency and possibly the hbase repository repository idhbase/id url https://repository.apache.org/content/repositories/releases//url /repository and you are ready to go. well, if you read into it, you'll understand what i say. On Thu, Jan 5, 2012 at 12:41 PM, Neetu Ojha neetuojha.c...@gmail.com wrote: Thanks A lot! Well Ulrich i am not at alll aware of maven!!! Regards Neetu Sharma On Thu, Jan 5, 2012 at 3:53 PM, Ulrich Staudinger ustaudin...@activequant.com wrote: That's more a java related question. With maven it is pretty straightforward to get this up and running, without altering the CLASSPATH or even having HBase installed on your machine. Do you use maven? On Thu, Jan 5, 2012 at 10:34 AM, Neetu Ojha neetuojha.c...@gmail.com wrote: Hello, I have installed HBase-0.90.4 on my local machine and as shown in quick start i installed/configured in standalone mode using my local file system of fedora-15. I have not started hadoop daemon assuming that its not needed as its completely standalone config. All the required libs that comes with the package are there. I faced lot of difficulty in compiling the simple code itself.I set CLASSPATH, in hbase-env.sh set HBASE_CLASSPATH but now it doen'n run. I took a code from the net and has created the required table in the hbase. When I am trying to execute a very basic java code using Hbase-0.90.4 API. some how it compiled but on execution it throws exception: java MyLittleHBaseClient Exception in thread main java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.apache.hadoop.conf.Configuration.clinit(Configuration.java:139) at MyLittleHBaseClient.main(MyLittleHBaseClient.java:21) Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory at java.net.URLClassLoader$1.run(URLClassLoader.java:217) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:205) at java.lang.ClassLoader.loadClass(ClassLoader.java:321) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294) at java.lang.ClassLoader.loadClass(ClassLoader.java:266) ... 2 more Kindly see if any one has experienced the same issue at any point of time. As for me its a long way ahead, hbase over HDFS and then hadoop cluster... Thanks Regards Neetu sharma -- Ulrich Staudinger http://goog_958005736http://www.activequant.com Connect online: https://www.xing.com/profile/Ulrich_Staudinger -- Ulrich Staudinger http://goog_958005736http://www.activequant.com Connect online: https://www.xing.com/profile/Ulrich_Staudinger -- Ulrich Staudinger http://goog_958005736http://www.activequant.com Connect online: https://www.xing.com/profile/Ulrich_Staudinger
unable to compile simple java application with HBASE API(s)
-- Forwarded message -- From: Neetu Ojha neetuojha.c...@gmail.com Date: Wed, Dec 21, 2011 at 2:40 PM Subject: To: user@hbase.apache.org Hello , I have installed hbase-0-90-3 in standalone mode on ext3 file system. All teh jars have come with tar but when i try to hook java application with hbase the java code is not getting started. I have hadoop-0.20.2 also installed , i have written a very simple application to scan simple table data. I am very new to this i need to know few things: 1. That can we interface with HBase using java API(s) in standalone mode without worrying about the hadoop part or that deamon must run. 2. When i try to extract the jars under hbase-0-90-3 it shows class inflated but i am not able to locate where this is done as JVM can't locate the class even after setting classpath. 3. Is it safe to take jrs independently install and fix the problem. Please help me understanding these issue to start up with HBase-0-90-3. Thanks and regards Neetu sharma