title: Sqoop import having SQL query with where clause
body: <pre><code>sqoop import --connect jdbc:teradata://192.168.xx.xx/DBS_PORT=1025,DATABASE=ds_tbl_db 
  --driver com.teradata.jdbc.TeraDriver 
  --username dbc 
  --password dbc 
  --query 'select * from reason where id&gt;20' 
  --hive-import 
  --hive-table reason_hive 
  --target-dir &lt;hdfs-location&gt; 
  -m 1
  </code></pre>
  
  <p>I got the error:</p>
  
  <blockquote>
    <p>Query [select * from reason where id>20] must contain '$CONDITIONS' in WHERE clause.</p>
  </blockquote>
  
  <p>I know there must be a where clause in query for Sqoop. </p>
  
  <p>So, for queries like </p>
  
  <p><code>select * from reason</code></p>
  
  <p>I modify it to:</p>
  
  <p><code>select * from reason WHERE $CONDITIONS</code></p>
  
  <p><strong>What to do for queries having <code>where</code> clause?</strong></p>