LOAD CSV functions

LOAD CSV functions can be used to get information about the file that is processed by the LOAD CSV clause.

The functions described on this page are only useful when run on a query that uses LOAD CSV. In all other contexts they always return null. If there are multiple LOAD CSV clauses in a query, the functions return information about the most recently executed LOAD CSV clause.

linenumber()

Details
Syntax	`linenumber()`
Description	Returns the line number that LOAD CSV is currently using.
Returns	`INTEGER`

Considerations
`null` will be returned if this function is called without a `LOAD CSV` context.
If the CSV file contains headers, the headers will be `linenumber` 1 and the 1st row of data will have a `linenumber` of 2.

file()

Details
Syntax	`file()`
Description	Returns the absolute path of the file that LOAD CSV is using.
Returns	`STRING`

Considerations
`null` will be returned if this function is called without a `LOAD CSV` context.