title: AWS Athena - duplicate columns due to partitionning
body: <p>We have a glue crawler that read avro files in S3 and create a table in glue catalog accordingly.
  The thing is that we have a column named 'foo' that came from the avro schema and we also have something like 'foo=XXXX' in the s3 bucket path, to have Hive partitions. </p>
  
  <p>What we did not know is that the crawler will then create a table which now has two columns with the same name, thus our issue while querying the table:</p>
  
  <pre><code>HIVE_INVALID_METADATA: Hive metadata for table mytable is invalid: Table descriptor contains duplicate columns
  
  </code></pre>
  
  <p>Is there a way to tell glue to map the partition 'foo' to another column name like 'bar' ?
  That way we would avoid having to reprocess our data by specifying a new partition name in the s3 bucket path..</p>
  
  <p>Or any other suggestions ?</p>