create a table for csv files

[xiaohe lan]

Hi,

I have some csv file in HDFS with headers like col1, col2, col3, I want to
add a column named id, so the a record would be <id, col1, col2, col3>

How can I do this using Spark SQL ? Can id be auto increment ?

Thanks,
Xiaohe