title: AWS Glue PySpark can't count the records
body: <p>I'm using AWS Glue to extract data from EC2 (Postgre) to be transformed and put it on S3 when I tried to extract 1 table. I got an error looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/hj7TK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hj7TK.png" alt="enter image description here"></a></p>
  
  <p>Is there anything I can do? I tried to drop null fields or fillna, but none of those works.</p>
  
  <p>UPDATE: I even selected a string-type column but still got the same error:
  <a href="https://i.stack.imgur.com/2XV9w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2XV9w.png" alt="enter image description here"></a></p>