title: Sqoop: Import several tables from different SQL DBs into a single CSV in HDFS?
body: <p>With Sqoop I need to import several SQL tables into a single CSV file in HDFS. In other words I need to do something similar to:</p>
  
  <pre><code>CREATE TABLE all AS SELECT *
  FROM (
    SELECT *  
    FROM user_1
    UNION ALL  
    SELECT *  
    from user_2
  ) tmp;  
  </code></pre>
  
  <p>Is it possible to do this in Sqoop, providing that tables <code>user_1</code> and <code>user_2</code> exist in different DBs?</p>