Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-6893

Unable to run sqoop query with "--query" in Sqoop1 editor

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 4.0.0
    • Fix Version/s: None
    • Component/s: con.sqoop
    • Labels:
      None

      Description

      So, basically if the value is a phrase i.e. has spaces between words, sqoop takes them are separate arguments. E.g. the following query does not work in sqoop editor.

      sqoop import --connect jdbc:mysql://nightly510-unsecure-1.gce.cloudera.com:3306/test --username new_user --password cloudera --query 'SELECT a.* FROM employee as a WHERE $CONDITIONS' --target-dir dfs://nightly510-unsecure-1.gce.cloudera.com:8020/user/admin/prachi --verbose --split-by a.empid

      REASON: bcoz the argument value 'SELECT a.* FROM employee as a WHERE $CONDITIONS' has spaces in it.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                romain Romain Rigaux
                Reporter:
                prachi.poddar Prachi Poddar
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: