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 will always return null.

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.