Sqoop
  1. Sqoop
  2. SQOOP-476

If table name is a qualified name, Sqoop import fails in DB2

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.2
    • Component/s: None
    • Labels:
      None

      Description

      In DB2, it is OK to have a dot "." in table name, but it is not in alias. For example, the following query fails:

      SELECT * FROM foo.bar AS foo.bar
      
      SQL0104N  An unexpected token "." was found following "from foo.bar as foo".  
      Expected tokens may include:  ",".  SQLSTATE=42601
      

      During the import job, Sqoop uses the following select query:

      SELECT <column names> FROM <table name> AS <table name>
      

      As can be seen, it can be a problem for DB2 if table name has a dot "." in it.

      1. SQOOP-476.patch
        15 kB
        Cheolsoo Park

        Activity

        Cheolsoo Park created issue -
        Cheolsoo Park made changes -
        Field Original Value New Value
        Status Open [ 1 ] Patch Available [ 10002 ]
        Cheolsoo Park made changes -
        Attachment SQOOP-476.patch [ 12529903 ]
        Bilung Lee made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Cheolsoo Park made changes -
        Fix Version/s 1.4.2 [ 12320141 ]

          People

          • Assignee:
            Cheolsoo Park
            Reporter:
            Cheolsoo Park
          • Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development