Interface LoadCSVStatementBuilder

All Superinterfaces:
ExposesCreate, ExposesFinish, ExposesMatch, ExposesMerge, ExposesReturning, ExposesSubqueryCall, ExposesUnwind, ExposesWith, StatementBuilder

@API(status=STABLE, since="2021.2.1") public interface LoadCSVStatementBuilder extends StatementBuilder
A builder dedicated to the creation of the LOAD CSV statement.
Since:
2021.2.1
Author:
Michael J. Simons
  • Method Details

    • usingPeriodicCommit

      static ExposesLoadCSV usingPeriodicCommit(Integer rate)
      Starts building a LOAD CSV clause by using a periodic commit.
      Parameters:
      rate - the rate to be used. No checks are done on the rate, the database will verify valid values.
      Returns:
      an ongoing definition of a LOAD CSV clause
    • loadCSV

      static LoadCSVStatementBuilder.OngoingLoadCSV loadCSV(URI from, boolean withHeaders)
      Starts building a LOAD CSV.
      Parameters:
      from - the URI to load data from. Any uri that is resolvable by the database itself is valid.
      withHeaders - set to true if the csv file contains header
      Returns:
      an ongoing definition of a LOAD CSV clause
    • withFieldTerminator

      StatementBuilder withFieldTerminator(String fieldTerminator)
      Configure a field terminator in case the fields aren't separated with the default ,.
      Parameters:
      fieldTerminator - a new field terminator
      Returns:
      a statement builder supporting all available clauses