title: Sqoop Import replace special characters of mysql
body: <p>I have 1000 tables with more than 100000 records in each table in mysql. The tables have 300-500 columns.</p>
  
  <p>Some of tables have columns with special characters like .(dot) and space in the column names.</p>
  
  <p>Now I want to do sqoop import and create a hive table in HDFS in a single shot query like below</p>
  
  <pre><code>sqoop import --connect ${domain}:${port}/$(database) --username ${username} --password ${password}\
  --table $(table) -m 1 --hive-import --hive-database ${hivedatabase} --hive-table $(table) --create-hive-table\
  --target-dir  /user/hive/warehouse/${hivedatabase}.db/$(table) 
  </code></pre>
  
  <p>After this the hive table is created but when I query the table it shows error as</p>
  
  <p>This error output is a sample output.</p>
  
  <pre><code>Error while compiling statement: FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp from [0:emp.id, 1:emp.name, 2:emp.salary, 3:emp.dno]
  </code></pre>
  
  <p>How can we replace the .(dot) with _(underscore) while doing sqoop import itself. I would like to do this dynamically. </p>