Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hbase tables import problem via Sqoop(using SQL Server to Hbase tables)

Highlighted

Hbase tables import problem via Sqoop(using SQL Server to Hbase tables)

I have 105 million records. I want to upload data sql server to hbase tables via sqoop.

 

Following steps are followed

 

1. sqoop import --connect "jdbc:sqlserver://192.168.1.95:1433;database=database;username=ss;password=XXXXXXX" --table "TempTable" --hbase-table "ods2_ord_TempTable_Sqoop" --column-family "ods" --split-by "RowNo" -m 10 --fetch-size 10000 -- --schema admin

 

2. we can set map reduce 10 

 

3. Fetch size 10000Lost Node.PNG

 

job running more than 15 hours. till now only 1 map successful. Other map  still running.  

 

We have two nodes. one node goes to Lost Stage