Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> org.apache.hadoop.hbase.TableNotFoundException


+
Omkar Joshi 2013-04-16, 05:22
Copy link to this message
-
Re: org.apache.hadoop.hbase.TableNotFoundException
Was there a carriage return between ADDRESS and , in your command line ?

Cheers

On Apr 15, 2013, at 10:22 PM, Omkar Joshi <[EMAIL PROTECTED]> wrote:

> Hi,
>
> I had created a table called CUSTOMERS (using create 'CUSTOMERS', 'CUSTOMER_INFO') 2-3 days back and inserted a couple of rows via shell.
>
> Now I wish to upload data into the table from a text file which looks like this :
>
> C1;Carol X. Nash;[EMAIL PROTECTED];459-1190 Tempor Rd.;(656) 169-7763;
> C2;Francesca B. Kirby;[EMAIL PROTECTED];4862 Integer Street;(884) 979-2109;
> C3;Quentin Z. Rodriquez;[EMAIL PROTECTED];1225 Egestas Rd.;(400) 901-2951;
> C4;Steven D. Ashley;[EMAIL PROTECTED];3747 Fringilla Rd.;(160) 300-7921;
>
> and so on.
>
> The DFS directory structure is as follows :
>
> hadoop fs -ls /hbase
> Warning: $HADOOP_HOME is deprecated.
>
> Found 11 items
> drwxr-xr-x   - hduser supergroup          0 2013-04-09 19:47 /hbase/-ROOT-
> drwxr-xr-x   - hduser supergroup          0 2013-04-09 19:47 /hbase/.META.
> drwxr-xr-x   - hduser supergroup          0 2013-04-16 16:02 /hbase/.archive
> drwxr-xr-x   - hduser supergroup          0 2013-04-09 19:47 /hbase/.logs
> drwxr-xr-x   - hduser supergroup          0 2013-04-09 19:47 /hbase/.oldlogs
> drwxr-xr-x   - hduser supergroup          0 2013-04-16 16:05 /hbase/.tmp
> drwxr-xr-x   - hduser supergroup          0 2013-04-16 16:05 /hbase/CUSTOMERS
> drwxr-xr-x   - hduser supergroup          0 2013-04-16 15:44 /hbase/copiedFromLocal
> -rw-r--r--   4 hduser supergroup         38 2013-04-09 19:47 /hbase/hbase.id
> -rw-r--r--   4 hduser supergroup          3 2013-04-09 19:47 /hbase/hbase.version
> drwxr-xr-x   - hduser supergroup          0 2013-04-09 22:03 /hbase/users
>
> I have loaded the text file onto the HDFS :
>
> hadoop fs -ls /hbase/copiedFromLocal
> Warning: $HADOOP_HOME is deprecated.
>
> Found 1 items
> -rw-r--r--   4 hduser supergroup    4751429 2013-04-16 15:44 /hbase/copiedFromLocal/customer.txt
>
> I'm using the below command to import this file into HBase :
>
> HADOOP_CLASSPATH=`${HBASE_HOME}/bin/hbase classpath` ${HADOOP_HOME}/bin/hadoop jar ${HBASE_HOME}/hbase-0.94.6.1.jar importtsv '-Dimporttsv.separator=;' -Dimporttsv.columns=HBASE_ROW_KEY,CUSTOMER_INFO:NAME,CUSTOMER_INFO:EMAIL,CUSTOMER_INFO:ADDRESS ,CUSTOMER_INFO:MOBILE  -Dimporttsv.bulk.output=hdfs://hbase/storefileoutput CUSTOMERS hdfs://hbase/copiedFromLocal/customer.txt
>
> But I get an exception :
>
> 13/04/16 16:16:05 WARN client.HConnectionManager$HConnectionImplementation: Encountered problems when prefetch META table:
> org.apache.hadoop.hbase.TableNotFoundException: Cannot find row in .META. for table: ,CUSTOMER_INFO:MOBILE, row=,CUSTOMER_INFO:MOBILE,,99999999999999
>        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:164)
>        at org.apache.hadoop.hbase.client.MetaScanner.access$000(MetaScanner.java:54)
>        at org.apache.hadoop.hbase.client.MetaScanner$1.connect(MetaScanner.java:133)
>        at org.apache.hadoop.hbase.client.MetaScanner$1.connect(MetaScanner.java:130)
>        at org.apache.hadoop.hbase.client.HConnectionManager.execute(HConnectionManager.java:383)
>        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:130)
>        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:105)
>        at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.prefetchRegionCache(HConnectionManager.java:947)
>        at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:1002)
>        at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:889)
>        at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:846)
>        at org.apache.hadoop.hbase.client.HTable.finishSetup(HTable.java:234)
+
Omkar Joshi 2013-04-16, 06:27
+
Andrea Gazzarini 2013-04-16, 06:27
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB