Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  • filename: The path to the file

  • directory: (since 2023/06/07): read recursive all files inside this directory.
  • path: (since 2024/02/28): When using directory, a pattern can be used. Default is "*"
  • append: append values to end of file. If set to false the values are overwritten. (default false)

  • createdir: When writing to a file, creates the file directory if it doesn't exist. (default false)

  • writedelaysize: Uses a buffer with specified size which has to be filled before data is written to the file (default 0)

  • preload: Loads the whole file into memory when the query is started (default false, incompatible with delayopenin)

  • delayopenin: When reading from a file, delays opening until reading the first tuple. Can be used to monitor log files which do not exist upon starting the query (default false)

  • delayopenout: When writing to a file, delays opening (and, if specified, creating the directory) until writing the first tuple (default false, incompatible with preload)