Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 137CC10A3E for ; Tue, 16 Apr 2013 06:57:46 +0000 (UTC) Received: (qmail 32418 invoked by uid 500); 16 Apr 2013 06:57:43 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 32370 invoked by uid 500); 16 Apr 2013 06:57:43 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 32361 invoked by uid 99); 16 Apr 2013 06:57:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Apr 2013 06:57:43 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of andrea.gazzarini@gmail.com designates 74.125.83.50 as permitted sender) Received: from [74.125.83.50] (HELO mail-ee0-f50.google.com) (74.125.83.50) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Apr 2013 06:57:38 +0000 Received: by mail-ee0-f50.google.com with SMTP id e53so71711eek.9 for ; Mon, 15 Apr 2013 23:57:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:message-id:date:from:user-agent:mime-version:to:subject :references:in-reply-to:content-type; bh=Xe1XBK8Vb/rl6onF8i1KRRzQ+e3qFZfLNKmzax4SpGs=; b=QX1tR6DR1dHKa6HsLFTAyLXEbqhHglf6evceLQttFZLoYsussSXOsMtvA0debUr0a2 JB7aZGiXsah4tuirjWyLg2IXV/j0/nkrY/eiIrUWjLKIqDlHjnxaq9JEbXbLH32XIwfz 0+Q8qIWAIuin7oe5roHKb5BI0bwJ4i4LZZe1T3P8SeLZFq+UlmnrNYAp3Wq8j3cA02JA uWz3SeSKvk/5yH189uOVxt1M1S7P9KaGxBYFf3ogV7CgiddYXdA3bkzpOxPTfEIE4bcD P2k7f9JstWpPz93AeW3Ob3IearXf8NIII7VaoLrkGMVo7RHod/leUo3yG+OM1zzfrdM/ VJ8w== X-Received: by 10.15.22.76 with SMTP id e52mr3083237eeu.7.1366093663994; Mon, 15 Apr 2013 23:27:43 -0700 (PDT) Received: from [172.20.195.68] (host253-183-static.123-81-b.business.telecomitalia.it. [81.123.183.253]) by mx.google.com with ESMTPS id b5sm789423eew.16.2013.04.15.23.27.41 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 15 Apr 2013 23:27:43 -0700 (PDT) Message-ID: <516CEF5B.9030403@gmail.com> Date: Tue, 16 Apr 2013 08:27:39 +0200 From: Andrea Gazzarini User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130330 Thunderbird/17.0.5 MIME-Version: 1.0 To: user@hbase.apache.org Subject: Re: org.apache.hadoop.hbase.TableNotFoundException References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------050209020107060703020303" X-Virus-Checked: Checked by ClamAV on apache.org --------------050209020107060703020303 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I see a space between ADDRESS and the comma, shouldn't be a problem but...who knows? CUSTOMER_INFO:ADDRESS ,CUSTOMER_INFO:MOBILE Seems that the the unknown column name in the log message includes the space and the comma, is that right? Cannot find row in .META. for table:* ,CUSTOMER_INFO:MOBILE*, row=,CUSTOMER_INFO:MOBILE,,99999999999999 Best, Andrea On 04/16/2013 07:38 AM, Ted Yu wrote: > Was there a carriage return between ADDRESS and , in your command line ? > > Cheers > > On Apr 15, 2013, at 10:22 PM, Omkar Joshi 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;hendrerit.Donec@diamnuncullamcorper.edu;459-1190 Tempor Rd.;(656) 169-7763; >> C2;Francesca B. Kirby;eget.odio.Aliquam@duiCumsociis.edu;4862 Integer Street;(884) 979-2109; >> C3;Quentin Z. Rodriquez;sit.amet@ligulaAeneaneuismod.com;1225 Egestas Rd.;(400) 901-2951; >> C4;Steven D. Ashley;accumsan.interdum@elitelit.edu;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) >> at org.apache.hadoop.hbase.client.HTable.(HTable.java:174) >> at org.apache.hadoop.hbase.client.HTable.(HTable.java:133) >> at org.apache.hadoop.hbase.mapreduce.TableOutputFormat.setConf(TableOutputFormat.java:201) >> at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) >> at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) >> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:884) >> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850) >> at java.security.AccessController.doPrivileged(Native Method) >> at javax.security.auth.Subject.doAs(Subject.java:415) >> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121) >> at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:850) >> at org.apache.hadoop.mapreduce.Job.submit(Job.java:500) >> at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:530) >> at org.apache.hadoop.hbase.mapreduce.ImportTsv.main(ImportTsv.java:425) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.apache.hadoop.util.ProgramDriver$ProgramDescription.invoke(ProgramDriver.java:68) >> at org.apache.hadoop.util.ProgramDriver.driver(ProgramDriver.java:139) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.apache.hadoop.hbase.mapreduce.Driver.main(Driver.java:51) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.apache.hadoop.util.RunJar.main(RunJar.java:156) >> 13/04/16 16:16:05 ERROR mapreduce.TableOutputFormat: org.apache.hadoop.hbase.TableNotFoundException: ,CUSTOMER_INFO:MOBILE >> 13/04/16 16:16:05 INFO mapred.JobClient: Cleaning up the staging area hdfs://cldx-1139-1033:9000/tmp/hadoop-hduser/mapred/staging/hduser/.staging/job_201304091909_0006 >> Exception in thread "main" java.lang.reflect.InvocationTargetException >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.apache.hadoop.hbase.mapreduce.Driver.main(Driver.java:51) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.apache.hadoop.util.RunJar.main(RunJar.java:156) >> Caused by: java.lang.RuntimeException: org.apache.hadoop.hbase.TableNotFoundException: ,CUSTOMER_INFO:MOBILE >> at org.apache.hadoop.hbase.mapreduce.TableOutputFormat.setConf(TableOutputFormat.java:206) >> at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) >> at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) >> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:884) >> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850) >> at java.security.AccessController.doPrivileged(Native Method) >> at javax.security.auth.Subject.doAs(Subject.java:415) >> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121) >> at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:850) >> at org.apache.hadoop.mapreduce.Job.submit(Job.java:500) >> at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:530) >> at org.apache.hadoop.hbase.mapreduce.ImportTsv.main(ImportTsv.java:425) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.apache.hadoop.util.ProgramDriver$ProgramDescription.invoke(ProgramDriver.java:68) >> at org.apache.hadoop.util.ProgramDriver.driver(ProgramDriver.java:139) >> ... 10 more >> Caused by: org.apache.hadoop.hbase.TableNotFoundException: ,CUSTOMER_INFO:MOBILE >> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:1024) >> 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) >> at org.apache.hadoop.hbase.client.HTable.(HTable.java:174) >> at org.apache.hadoop.hbase.client.HTable.(HTable.java:133) >> at org.apache.hadoop.hbase.mapreduce.TableOutputFormat.setConf(TableOutputFormat.java:201) >> ... 27 more >> >> I disabled, dropped CUSTOMERS and recreated it but the issue is recurring. >> >> Please guide me >> >> Regards, >> Omkar Joshi >> >> >> ________________________________ >> The contents of this e-mail and any attachment(s) may contain confidential or privileged information for the intended recipient(s). Unintended recipients are prohibited from taking action on the basis of information in this e-mail and using or disseminating the information, and must notify the sender and delete it from their system. L&T Infotech will not accept responsibility or liability for the accuracy or completeness of, or the presence of any virus or disabling code in this e-mail" --------------050209020107060703020303--