Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

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


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)