title: error with creating volatile table in teradata
body: <pre><code>-drop table r.stray_cust;
  
  CREATE VOLATILE TABLE r.stray_cust
  (
  CustomerID INTEGER
  ) 
  PRIMARY INDEX ( CustomerID );
  
  INSERT INTO  r.stray_cust
  SELECT DISTINCT c.customerid AS customerid
  FROM customer c
  WHERE c.customerid 
  NOT IN (
  SELECT a.customerid 
  FROM address a );
  
  ON COMMIT PRESERVE ROWS;
  
  select * from r.stray_cust;
  </code></pre>
  
  <p>Keep getting an error message - query failed please see history log for details</p>