S3 Select (python) does not return the header when using WHERE clause despite FileHeaderInfo=NONE

Asked Dec 15 '21 at 01:34

Active Dec 15 '21 at 02:27

Viewed 181 times

When I submit this query: SELECT * FROM s3object with the FileHeaderInfo of the input serialization set to NONE, I get the records expected with their header.

As soon as I add a where clause like this:

SELECT * FROM s3object  WHERE _3 = 'Chicago'

then the header is no longer returned.

edited Dec 15 '21 at 02:27

John Rotenstein

241,921
22
380
470

asked Dec 15 '21 at 01:34

Jeff Saremi

2,674
3
33
57

Might be helpful: [amazon web services - S3 Select CSV Headers - Stack Overflow](https://stackoverflow.com/questions/50848573/s3-select-csv-headers) – John Rotenstein Dec 15 '21 at 02:29
Thank you John. I've taken all those suggestions into consideration. I'm using NONE – Jeff Saremi Dec 15 '21 at 18:17

S3 Select (python) does not return the header when using WHERE clause despite FileHeaderInfo=NONE

0 Answers0