[ https://issues.apache.org/jira/browse/AIRFLOW-1119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bolke de Bruin resolved AIRFLOW-1119. ------------------------------------- Resolution: Fixed Fix Version/s: 1.8.2 Issue resolved by pull request #2245 [https://github.com/apache/incubator-airflow/pull/2245] > Redshift to S3 operator - headers not on first row > -------------------------------------------------- > > Key: AIRFLOW-1119 > URL: https://issues.apache.org/jira/browse/AIRFLOW-1119 > Project: Apache Airflow > Issue Type: Bug > Reporter: Thomas H > Fix For: 1.8.2 > > Attachments: airflow-bug.png > > > The RedshiftToS3 operator adds headers when unloading data from redshift to > s3. However, there is a bug where the headers can appear in any row (see > screenshot). Need to add `ORDER BY 1 DESC` to the query below to ensure > headers are on first row. > https://github.com/apache/incubator-airflow/blob/master/airflow/operators/redshift_to_s3_operator.py#L93:L102 > More info regarding unloading data with headers: > http://stackoverflow.com/questions/24681214/unloading-from-redshift-to-s3-with-headers > https://medium.com/carwow-product-engineering/unloading-a-file-from-redshift-to-s3-with-headers-fb707f5480f7 -- This message was sent by Atlassian JIRA (v6.3.15#6346)