title: AWS Athena Import CSV file
body: <p>I have this data stored in S3 as .csv (but it can be any other file format which is the best suitable for my requirement):</p>
  
  <pre><code>"41.9100687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417","41.9810128,-87.8785121","41.9200687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417",
  "41.9100687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417","41.9810128,-87.8785121","41.9200687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417",
  "41.9100687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417","41.9810128,-87.8785121","41.9200687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417",
  "41.9100687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417","41.9810128,-87.8785121","41.9200687,-87.8805614","41.9802511,-87.8803253","41.9806802,-87.8792417",
  </code></pre>
  
  <p>and I would like to have one coordinate per column:</p>
  
  <p>Like this:</p>
  
  <p>Coordinates:</p>
  
  <pre><code>1.  41.9100687,-87.8805614
  
  2.  41.9802511,-87.8803253
  
  3.  41.9806802,-87.8792417
  </code></pre>
  
  <p>After importing S3 I choose CSV as data type... And then I add string column.</p>
  
  <p><a href="https://i.stack.imgur.com/TlfXT.png" rel="noreferrer"><img src="https://i.stack.imgur.com/TlfXT.png" alt="enter image description here"></a></p>
  
  <p>But instead I get some weird table output. Beside this I tried to import this as plain txt file with comma delimiter.. I get same weird output.</p>
  
  <p><a href="https://i.stack.imgur.com/BCLdM.png" rel="noreferrer"><img src="https://i.stack.imgur.com/BCLdM.png" alt="enter image description here"></a></p>
  
  <p>What am I doing wrong here?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>This <code>test</code> column screenshot is query from another but identical example. There should be <code>gps_coordinates</code></p>