title: Talend convert to bigdecimal from string
body: <p>I am reading a text file which has a field in Timestamp in this format <code>"yyyy-MM-dd HH:mm:ss"</code></p>
  
  <p>I want to be able to convert it to a field in Impala as BigInt and should like yyyMMddHHmmss in Java.
  Following this link:
  <a href="https://stackoverflow.com/questions/27282037/java-timestamp-to-bigint-for-impala">Java Timestamp to BigInt for Impala</a></p>
  
  <p>I use the talend methods for conversion and do this:</p>
  
  <pre><code>TalendDate.formatDate("yyyyMMddHHmmss",TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row5.StopTime))
  </code></pre>
  
  <p>Here StopTime is my timestamp.  I first parse it to a Date format, then to a format it to the required format. I have a string.  </p>
  
  <p>The impala table that has DBType BigInt has JavaType BigDecimal.</p>
  
  <p>How do I convert the string I have to a BigDecimal.  Right not the DBtypesof schemas don't match.</p>
  
  <p>Thanks in advance!</p>