Is it possible to consider the second row as the header for a .csv file in S3 Select?

Asked May 20 '20 at 12:05

Active May 20 '20 at 12:05

Viewed 133 times

Is it possible to consider the second row of a .csv file as the headers and skip the first row in S3 Select?

The structure of my file is as follows:

A   B   C
a b c d e f
1 2 3 4 5 6

Now I want skip

A   B   C

And query on

a b c d e f

Is this possible by any chance?

asked May 20 '20 at 12:05

Pallav Doshi

What do you mean by `query on`? – jellycsc May 20 '20 at 15:30
I doubt this is possible. The CSV format expects the first row to have the column names. You'll likely need to edit the contents of the object to make it usable. Is it a large object? – John Rotenstein May 21 '20 at 03:23
@JohnRotenstein Yes, it did not work, the first row is always considered as the header! – Pallav Doshi May 26 '20 at 07:38
@jellycsc You can run SQL Like queries on a file stored in S3 using S3 Select! – Pallav Doshi May 26 '20 at 07:39

0 Answers0