[SQOOP-3272] Amazon EMR: Can not import MSSQL table into HBASE

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: hbase-integration

Environment

Amazon EMR
Release label:emr-5.11.0
Hadoop distribution:Amazon 2.7.3
Applications:Ganglia 3.7.2, HBase 1.3.1, Hive 2.3.2, Hue 4.0.1, Phoenix 4.11.0

• Flags: Important
• Assignee: Unassigned
• Reporter: mostafa sohdy
• Created: 08/Jan/18 09:26
• Updated: 08/Jan/18 09:26

Description

When I try to import a table from mssql to hbase using the following command:

./sqoop-import --connect "jdbc:sqlserver://beta.sr.nagwa.com:1433; database=Nagwa.Studio.Demo;" \
--username User --P \
--table Media \
--hbase-create-table\
--hbase-table media \
--column-family mediafam \
--hbase-row-key Id

I get the following error and I can't figure out the problem:
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.hbase.HTableDescriptor.addFamily(Lorg/apache/hadoop/hbase/HColumnDescriptor

When I create the table in HBase manually then try to import using the following command:
./sqoop-import --connect "jdbc:sqlserver://beta.sr.nagwa.com:1433; database=Nagwa.Studio.Demo;" \
--username OnlineTutoring --P \
--table Media \
--hbase-table media \
--column-family mediafam \
--hbase-row-key Id

it gets stuck at:
18/01/08 08:39:41 INFO mapreduce.Job: Running job: job_1515060323626_0007

attached please find the terminal log that I get when I run the command in -verbose