Sqoop error with HBase

to create new topics or reply. | New User Registration

Tagged: 

This topic contains 2 replies, has 2 voices, and was last updated by  Arun Veettil 1 year, 4 months ago.

  • Creator
    Topic
  • #49548

    Arun Veettil
    Participant

    I am trying to import data from teradata to HBase using sqoop. I am getting the below stack trace. Please help.

    14/03/02 06:42:17 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=y0319p248.nordstrom.net:2181,y0319p247.nordstrom.net:2181,y0319p249.nordstrom.net:2181 sessionTimeout=60000 watcher=catalogtracker-on-hconnection-0x4ee6065d
    14/03/02 06:42:17 INFO zookeeper.RecoverableZooKeeper: Process identifier=catalogtracker-on-hconnection-0x4ee6065d connecting to ZooKeeper ensemble=y0319p248.nordstrom.net:2181,y0319p247.nordstrom.net:2181,y0319p249.nordstrom.net:2181
    14/03/02 06:42:17 INFO zookeeper.ClientCnxn: Opening socket connection to server y0319p249.nordstrom.net/10.16.134.139:2181. Will not attempt to authenticate using SASL (unknown error)
    14/03/02 06:42:17 INFO zookeeper.ClientCnxn: Socket connection established to y0319p249.nordstrom.net/10.16.134.139:2181, initiating session
    14/03/02 06:42:17 INFO zookeeper.ClientCnxn: Session establishment complete on server y0319p249.nordstrom.net/10.16.134.139:2181, sessionid = 0x34413d919a107e7, negotiated timeout = 40000
    14/03/02 08:04:32 INFO zookeeper.ZooKeeper: Session: 0x34413d919a107e7 closed
    14/03/02 08:04:32 INFO zookeeper.ClientCnxn: EventThread shut down
    14/03/02 08:04:32 ERROR tool.ImportTool: Encountered IOException running import job: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=35, exceptions:
    Sun Mar 02 06:44:17 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=false
    Sun Mar 02 06:45:28 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=true
    Sun Mar 02 06:46:37 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=true
    Sun Mar 02 06:47:47 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=true
    Sun Mar 02 06:48:57 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=true
    Sun Mar 02 06:50:07 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=true
    Sun Mar 02 06:51:16 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:meta, row=dlabs:custxreftoshopperid,,, reload=true
    Sun Mar 02 06:52:26 PST 2014, org.apache.hadoop.hbase.client.RpcRetryingCaller@7862f503, java.io.IOException: Failed to find location, tableName=hbase:m

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Sqoop error with HBase’ is closed to new replies.

  • Author
    Replies
  • #49582

    Arun Veettil
    Participant

    Thanks Mahesh, Actually I resolved the issue after digging through the HBase code base. Basically hbase-site.xml was configured to have zookeeper root node as hbase-unsecure. I think this was supposed to be just hbase. Because of this zookeeper was not able to get the region-meta server name. Fixing the configuration resolved the issue.

    <!–
    <property>
    <name>zookeeper.znode.parent</name>
    <value>/hbase-unsecure</value>
    </property>
    –>

    Collapse
    #49556

    Hi Arun,

    1. Can you provide the command you have used to perform the sqoop import?
    2. Can you paste the complete trace from the sqoop import till it fails.
    3. Is the table existing in hbase to which you are trying to import the data from teradata.

    -Mahesh

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.