Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-3272

Amazon EMR: Can not import MSSQL table into HBASE

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 1.4.6
    • Fix Version/s: None
    • Component/s: hbase-integration
    • Labels:
      None
    • 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

      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

        Attachments

        1. SqoopImportHBase.txt
          158 kB
          mostafa sohdy

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              msohdy mostafa sohdy
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: