title: Teradata Hadoop Connector using split by amp
body: <p>I am using TDCH for pulling data from Teradata to  hadoop cluster using TDCH.
  In TDCH i am using split by amp option .I have 120 amp Teradata System and in my TDCH script i am defining 30 mappers. So each will pull data from 4 AMP .I am getting like below queries :-</p>
  
  <pre><code>'Select "NAME" ,"ADRESS" FROM FROM tdampcopy(ON "TABLENAME" USING AMPList(136,137,138,139)) AS THCALIAS1 .
  </code></pre>
  
  <p>It is creating 30 queries with 30 session ids. When they are running it on Teradata System , it is causing skewness as in each query only 4 amps are invloved and DBAs are killing these queries. Any pointers to how we can overcome with this.</p>