Interface DataSet

All Known Implementing Classes:
RowDataSet

public interface DataSet
Since:
0.8
Author:
Haiyang Li
See Also:
  • com.landawn.abacus.util.Build.DataSetBuilder
  • com.landawn.abacus.jdbc.JdbcUtil
  • CSVUtil
  • Fn.Factory
  • Clazz
  • CommonUtil.newEmptyDataSet()
  • CommonUtil.newEmptyDataSet(Collection)
  • CommonUtil.newDataSet(Map)
  • CommonUtil.newDataSet(Collection)
  • CommonUtil.newDataSet(Collection, Collection)
  • CommonUtil.newDataSet(String, String, Map)
  • Method Details

    • columnNameList

      ImmutableList<String> columnNameList()
      Return the column name list in this DataSet.
      Returns:
    • getColumnName

      String getColumnName(int columnIndex)
      Parameters:
      columnIndex -
      Returns:
    • getColumnIndex

      int getColumnIndex(String columnName)
      Parameters:
      columnName -
      Returns:
      -1 if the specified columnName is not found
    • getColumnIndexes

      int[] getColumnIndexes(Collection<String> columnNames)
      -1 is set to the element in the returned array if the mapping column name is not included in this DataSet.
      Parameters:
      columnNames -
      Returns:
    • containsColumn

      boolean containsColumn(String columnName)
      Parameters:
      columnName -
      Returns:
      true, if successful
    • containsAllColumns

      boolean containsAllColumns(Collection<String> columnNames)
      Check if this DataSet contains all the specified columns.
      Parameters:
      columnNames -
      Returns:
      true if all the specified columns are included in the this DataSet
    • renameColumn

      void renameColumn(String columnName, String newColumnName)
      Parameters:
      columnName -
      newColumnName -
    • renameColumns

      void renameColumns(Map<String,String> oldNewNames)
      Parameters:
      oldNewNames -
    • renameColumn

      <E extends Exception> void renameColumn(String columnName, Throwables.Function<String,String,E> func) throws E
      Type Parameters:
      E -
      Parameters:
      columnName -
      func -
      Throws:
      E - the e
    • renameColumns

      <E extends Exception> void renameColumns(Collection<String> columnNames, Throwables.Function<String,String,E> func) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      func -
      Throws:
      E - the e
    • renameColumns

      <E extends Exception> void renameColumns(Throwables.Function<String,String,E> func) throws E
      Type Parameters:
      E -
      Parameters:
      func -
      Throws:
      E - the e
    • moveColumn

      void moveColumn(String columnName, int newPosition)
      Parameters:
      columnName -
      newPosition -
    • moveColumns

      void moveColumns(Map<String,Integer> columnNameNewPositionMap)
      Parameters:
      columnNameNewPositionMap -
    • swapColumns

      void swapColumns(String columnNameA, String columnNameB)
      Swap the positions of the two specified columns.
      Parameters:
      columnNameA -
      columnNameB -
    • moveRow

      void moveRow(int rowIndex, int newRowIndex)
      Move the specified row to the new position.
      Parameters:
      rowIndex -
      newRowIndex -
    • swapRows

      void swapRows(int rowIndexA, int rowIndexB)
      Swap the positions of the two specified rows.
      Parameters:
      rowIndexA -
      rowIndexB -
    • get

      <T> T get(int rowIndex, int columnIndex)
      There is NO underline auto-conversion from column value to target type: T. So the column values must be the type which is assignable to target type.
      Type Parameters:
      T -
      Parameters:
      rowIndex -
      columnIndex -
      Returns:
    • set

      void set(int rowIndex, int columnIndex, Object element)
      Parameters:
      rowIndex -
      columnIndex -
      element -
    • isNull

      boolean isNull(int rowIndex, int columnIndex)
      Checks if is null.
      Parameters:
      rowIndex -
      columnIndex -
      Returns:
      true, if is null
    • get

      <T> T get(int columnIndex)
      There is NO underline auto-conversion from column value to target type: T. So the column values must be the type which is assignable to target type.
      Type Parameters:
      T -
      Parameters:
      columnIndex -
      Returns:
    • get

      <T> T get(String columnName)
      There is NO underline auto-conversion from column value to target type: T. So the column values must be the type which is assignable to target type.
      Type Parameters:
      T -
      Parameters:
      columnName -
      Returns:
    • getBoolean

      boolean getBoolean(int columnIndex)
      Return default value (false) if the property is null.
      There is NO underline auto-conversion from column value to target type: Boolean. So the column values must be the type which is assignable to target type.
      Parameters:
      columnIndex -
      Returns:
    • getBoolean

      boolean getBoolean(String columnName)
      Return default value (false) if the property is null.
      There is NO underline auto-conversion from column value to target type: Boolean. So the column values must be the type which is assignable to target type.
      Parameters:
      columnName -
      Returns:
    • getChar

      char getChar(int columnIndex)
      Return default value (0) if the property is null.
      There is NO underline auto-conversion from column value to target type: Character. So the column values must be the type which is assignable to target type.
      Parameters:
      columnIndex -
      Returns:
    • getChar

      char getChar(String columnName)
      Return default value (0) if the property is null.
      There is NO underline auto-conversion from column value to target type: Character. So the column values must be the type which is assignable to target type.
      Parameters:
      columnName -
      Returns:
    • getByte

      byte getByte(int columnIndex)
      Return default value (0) if the property is null. Return Number.byteValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Byte. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnIndex -
      Returns:
    • getByte

      byte getByte(String columnName)
      Return default value (0) if the property is null. Return Number.byteValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Byte. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnName -
      Returns:
    • getShort

      short getShort(int columnIndex)
      Return default value (0) if the property is null. Return Number.shortValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Short. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnIndex -
      Returns:
    • getShort

      short getShort(String columnName)
      Return default value (0) if the property is null. Return Number.shortValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Short. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnName -
      Returns:
    • getInt

      int getInt(int columnIndex)
      Return default value (0) if the property is null. Return Number.intValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Integer. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnIndex -
      Returns:
    • getInt

      int getInt(String columnName)
      Return default value (0) if the property is null. Return Number.intValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Integer. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnName -
      Returns:
    • getLong

      long getLong(int columnIndex)
      Return default value (0) if the property is null. Return Number.longValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Long. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnIndex -
      Returns:
    • getLong

      long getLong(String columnName)
      Return default value (0) if the property is null. Return Number.longValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Long. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnName -
      Returns:
    • getFloat

      float getFloat(int columnIndex)
      Return default value (0f) if the property is null. Return Number.floatValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Float. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnIndex -
      Returns:
    • getFloat

      float getFloat(String columnName)
      Return default value (0f) if the property is null. Return Number.floatValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Float. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnName -
      Returns:
    • getDouble

      double getDouble(int columnIndex)
      Return default value (0d) if the property is null. Return Number.doubleValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Double. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnIndex -
      Returns:
    • getDouble

      double getDouble(String columnName)
      Return default value (0d) if the property is null. Return Number.doubleValue() otherwise.
      There is NO underline auto-conversion from column value to target type: Double. So the column values must be the type which is assignable to target type, or Number.
      Parameters:
      columnName -
      Returns:
    • isNull

      boolean isNull(int columnIndex)
      Checks if is null.
      Parameters:
      columnIndex -
      Returns:
      true, if is null
    • isNull

      boolean isNull(String columnName)
      Checks if is null.
      Parameters:
      columnName -
      Returns:
      true, if is null
    • set

      void set(int columnIndex, Object value)
      Parameters:
      columnIndex -
      value -
    • set

      void set(String columnName, Object value)
      Parameters:
      columnName -
      value -
    • getColumn

      <T> ImmutableList<T> getColumn(int columnIndex)
      Must NOT modify the returned list.
      Type Parameters:
      T -
      Parameters:
      columnIndex -
      Returns:
    • getColumn

      <T> ImmutableList<T> getColumn(String columnName)
      Must NOT modify the returned list.
      Type Parameters:
      T -
      Parameters:
      columnName -
      Returns:
    • copyOfColumn

      <T> List<T> copyOfColumn(String columnName)
      Copy of column.
      Type Parameters:
      T -
      Parameters:
      columnName -
      Returns:
    • addColumn

      void addColumn(String columnName, List<?> column)
      Parameters:
      columnName -
      column -
    • addColumn

      void addColumn(int columnIndex, String columnName, List<?> column)
      Parameters:
      columnIndex - position to add.
      columnName -
      column -
    • addColumn

      <T, E extends Exception> void addColumn(String newColumnName, String fromColumnName, Throwables.Function<T,?,E> func) throws E
      Generate the new column values from the specified column by the specified Function.
      Type Parameters:
      T -
      E -
      Parameters:
      newColumnName -
      fromColumnName -
      func -
      Throws:
      E - the e
    • addColumn

      <T, E extends Exception> void addColumn(int columnIndex, String newColumnName, String fromColumnName, Throwables.Function<T,?,E> func) throws E
      Generate the new column values from the specified column by the specified Function.
      Type Parameters:
      T -
      E -
      Parameters:
      columnIndex -
      newColumnName -
      fromColumnName -
      func -
      Throws:
      E - the e
    • addColumn

      <E extends Exception> void addColumn(String newColumnName, Collection<String> fromColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> func) throws E
      Generate the new column values from the specified columns by the specified Function.
      Type Parameters:
      E -
      Parameters:
      newColumnName -
      fromColumnNames -
      func - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • addColumn

      <E extends Exception> void addColumn(int columnIndex, String newColumnName, Collection<String> fromColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> func) throws E
      Generate the new column values from the specified columns by the specified Function.
      Type Parameters:
      E -
      Parameters:
      columnIndex -
      newColumnName -
      fromColumnNames -
      func - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • addColumn

      <E extends Exception> void addColumn(String newColumnName, Tuple.Tuple2<String,String> fromColumnNames, Throwables.BiFunction<?,?,?,E> func) throws E
      Generate the new column values from the specified columns by the specified Function.
      Type Parameters:
      E -
      Parameters:
      newColumnName -
      fromColumnNames -
      func -
      Throws:
      E - the e
    • addColumn

      <E extends Exception> void addColumn(int columnIndex, String newColumnName, Tuple.Tuple2<String,String> fromColumnNames, Throwables.BiFunction<?,?,?,E> func) throws E
      Generate the new column values from the specified columns by the specified Function.
      Type Parameters:
      E -
      Parameters:
      columnIndex -
      newColumnName -
      fromColumnNames -
      func -
      Throws:
      E - the e
    • addColumn

      <E extends Exception> void addColumn(String newColumnName, Tuple.Tuple3<String,String,String> fromColumnNames, Throwables.TriFunction<?,?,?,?,E> func) throws E
      Generate the new column values from the specified columns by the specified Function.
      Type Parameters:
      E -
      Parameters:
      newColumnName -
      fromColumnNames -
      func -
      Throws:
      E - the e
    • addColumn

      <E extends Exception> void addColumn(int columnIndex, String newColumnName, Tuple.Tuple3<String,String,String> fromColumnNames, Throwables.TriFunction<?,?,?,?,E> func) throws E
      Generate the new column values from the specified columns by the specified Function.
      Type Parameters:
      E -
      Parameters:
      columnIndex -
      newColumnName -
      fromColumnNames -
      func -
      Throws:
      E - the e
    • removeColumn

      <T> List<T> removeColumn(String columnName)
      Remove the column with the specified columnName from this DataSet.
      Type Parameters:
      T -
      Parameters:
      columnName -
      Returns:
    • removeColumns

      void removeColumns(Collection<String> columnNames)
      Remove the column(s) with the specified columnNames from this DataSet.
      Parameters:
      columnNames -
    • removeColumns

      <E extends Exception> void removeColumns(Throwables.Predicate<String,E> filter) throws E
      Remove the column(s) whose name matches the specified filter.
      Type Parameters:
      E -
      Parameters:
      filter - column name filter
      Throws:
      E - the e
    • updateColumn

      <E extends Exception> void updateColumn(String columnName, Throwables.Function<?,?,E> func) throws E
      Update the values of the specified column by the specified Try.Function.
      Type Parameters:
      E -
      Parameters:
      columnName -
      func -
      Throws:
      E - the e
    • updateColumns

      <E extends Exception> void updateColumns(Collection<String> columnNames, Throwables.Function<?,?,E> func) throws E
      Update the values of the specified columns one by one with the specified Try.Function.
      Type Parameters:
      E -
      Parameters:
      columnNames -
      func -
      Throws:
      E - the e
    • convertColumn

      void convertColumn(String columnName, Class<?> targetType)
      Convert the specified column to target type.
      Parameters:
      columnName -
      targetType -
    • convertColumns

      void convertColumns(Map<String,Class<?>> columnTargetTypes)
      Convert the specified columns to target types.
      Parameters:
      columnTargetTypes -
    • combineColumns

      void combineColumns(Collection<String> columnNames, String newColumnName, Class<?> newColumnClass)
      Parameters:
      columnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
    • combineColumns

      <E extends Exception> void combineColumns(Collection<String> columnNames, String newColumnName, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> combineFunc) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      newColumnName -
      combineFunc - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • combineColumns

      <E extends Exception> void combineColumns(Tuple.Tuple2<String,String> columnNames, String newColumnName, Throwables.BiFunction<?,?,?,E> combineFunc) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      newColumnName -
      combineFunc -
      Throws:
      E - the e
    • combineColumns

      <E extends Exception> void combineColumns(Tuple.Tuple3<String,String,String> columnNames, String newColumnName, Throwables.TriFunction<?,?,?,?,E> combineFunc) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      newColumnName -
      combineFunc -
      Throws:
      E - the e
    • combineColumns

      <E extends Exception> void combineColumns(Throwables.Predicate<String,E> columnNameFilter, String newColumnName, Class<?> newColumnClass) throws E
      Type Parameters:
      E -
      Parameters:
      columnNameFilter -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      Throws:
      E - the e
    • combineColumns

      <E extends Exception, E2 extends Exception> void combineColumns(Throwables.Predicate<String,E> columnNameFilter, String newColumnName, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E2> combineFunc) throws E, E2
      Type Parameters:
      E -
      E2 -
      Parameters:
      columnNameFilter -
      newColumnName -
      combineFunc - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
      E2 - the e2
    • divideColumn

      <T, E extends Exception> void divideColumn(String columnName, Collection<String> newColumnNames, Throwables.Function<T,? extends List<?>,E> divideFunc) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      newColumnNames -
      divideFunc -
      Throws:
      E - the e
    • divideColumn

      <T, E extends Exception> void divideColumn(String columnName, Collection<String> newColumnNames, Throwables.BiConsumer<T,Object[],E> output) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      newColumnNames -
      output -
      Throws:
      E - the e
    • divideColumn

      <T, E extends Exception> void divideColumn(String columnName, Tuple.Tuple2<String,String> newColumnNames, Throwables.BiConsumer<T,Pair<Object,Object>,E> output) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      newColumnNames -
      output -
      Throws:
      E - the e
    • divideColumn

      <T, E extends Exception> void divideColumn(String columnName, Tuple.Tuple3<String,String,String> newColumnNames, Throwables.BiConsumer<T,Triple<Object,Object,Object>,E> output) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      newColumnNames -
      output -
      Throws:
      E - the e
    • addRow

      void addRow(Object row)
      Adds the row.
      Parameters:
      row - can be Object[]/List/Map/Bean with getter/setter methods
    • addRow

      void addRow(int rowIndex, Object row)
      Adds the row.
      Parameters:
      rowIndex -
      row - can be Object[]/List/Map/Bean with getter/setter methods
    • removeRow

      void removeRow(int rowIndex)
      Removes the row.
      Parameters:
      rowIndex -
    • removeRows

      void removeRows(int... indices)
      Removes the rows.
      Parameters:
      indices -
    • removeRowRange

      void removeRowRange(int inclusiveFromRowIndex, int exclusiveToRowIndex)
      Removes the row range.
      Parameters:
      inclusiveFromRowIndex -
      exclusiveToRowIndex -
    • updateRow

      <E extends Exception> void updateRow(int rowIndex, Throwables.Function<?,?,E> func) throws E
      Update the values in the specified row with the specified Try.Function.
      Type Parameters:
      E -
      Parameters:
      rowIndex -
      func -
      Throws:
      E - the e
    • updateRows

      <E extends Exception> void updateRows(int[] indices, Throwables.Function<?,?,E> func) throws E
      Update the values in the specified rows one by one with the specified Try.Function.
      Type Parameters:
      E -
      Parameters:
      indices -
      func -
      Throws:
      E - the e
    • updateAll

      <E extends Exception> void updateAll(Throwables.Function<?,?,E> func) throws E
      Update all the values in this DataSet with the specified Try.Function.
      Type Parameters:
      E -
      Parameters:
      func -
      Throws:
      E - the e
    • replaceIf

      <E extends Exception> void replaceIf(Throwables.Predicate<?,E> func, Object newValue) throws E
      Replace all the values in this DataSet with the specified new value if it matches the specified condition.
      Type Parameters:
      E -
      Parameters:
      func -
      newValue -
      Throws:
      E - the e
    • currentRowNum

      int currentRowNum()
      Returns the current row number.
      Returns:
    • absolute

      DataSet absolute(int rowIndex)
      Move the cursor to the specified row.
      Parameters:
      rowIndex -
      Returns:
      this object itself.
    • getRow

      Object[] getRow(int rowIndex)
      Gets the row.
      Parameters:
      rowIndex -
      Returns:
    • getRow

      <T> T getRow(Class<? extends T> rowClass, int rowIndex)
      Gets the row.
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      rowIndex -
      Returns:
    • getRow

      <T> T getRow(Class<? extends T> rowClass, Collection<String> columnNames, int rowIndex)
      Gets the row.
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNames -
      rowIndex -
      Returns:
    • getRow

      <T> T getRow(int rowIndex, IntFunction<? extends T> rowSupplier)
      Gets the row.
      Type Parameters:
      T -
      Parameters:
      rowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • getRow

      <T> T getRow(Collection<String> columnNames, int rowIndex, IntFunction<? extends T> rowSupplier)
      Gets the row.
      Type Parameters:
      T -
      Parameters:
      columnNames -
      rowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • firstRow

      u.Optional<Object[]> firstRow()
      Returns:
      Optional<Object[]>
    • firstRow

      <T> u.Optional<T> firstRow(Class<? extends T> rowClass)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      Returns:
      Optional<E>
    • firstRow

      <T> u.Optional<T> firstRow(Class<? extends T> rowClass, Collection<String> columnNames)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNames -
      Returns:
      Optional<E>
    • firstRow

      <T> u.Optional<T> firstRow(IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
      Optional<T>
    • firstRow

      <T> u.Optional<T> firstRow(Collection<String> columnNames, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
      Optional<T>
    • lastRow

      u.Optional<Object[]> lastRow()
      Returns:
      Optional<Object[]>
    • lastRow

      <T> u.Optional<T> lastRow(Class<? extends T> rowClass)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      Returns:
      Optional<E>
    • lastRow

      <T> u.Optional<T> lastRow(Class<? extends T> rowClass, Collection<String> columnNames)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean which can be object array/list/set/map/bean.
      columnNames -
      Returns:
      Optional<E>
    • lastRow

      <T> u.Optional<T> lastRow(IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
      Optional<T>
    • lastRow

      <T> u.Optional<T> lastRow(Collection<String> columnNames, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
      Optional<T>
    • forEach

      <E extends Exception> void forEach(Throwables.Consumer<? super NoCachingNoUpdating.DisposableObjArray,E> action) throws E
      Performs the given action for each row of the DataSet until all rows have been processed or the action throws an exception.
      Type Parameters:
      E -
      Parameters:
      action - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(Collection<String> columnNames, Throwables.Consumer<? super NoCachingNoUpdating.DisposableObjArray,E> action) throws E
      Performs the given action for each row of the DataSet until all rows have been processed or the action throws an exception.
      Type Parameters:
      E -
      Parameters:
      columnNames -
      action - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(int fromRowIndex, int toRowIndex, Throwables.Consumer<? super NoCachingNoUpdating.DisposableObjArray,E> action) throws E
      Performs the given action for each row of the DataSet until all rows have been processed or the action throws an exception.
      Type Parameters:
      E -
      Parameters:
      fromRowIndex -
      toRowIndex -
      action - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(Collection<String> columnNames, int fromRowIndex, int toRowIndex, Throwables.Consumer<? super NoCachingNoUpdating.DisposableObjArray,E> action) throws E
      Performs the given action for each row of the DataSet until all rows have been processed or the action throws an exception.
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      action - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(Tuple.Tuple2<String,String> columnNames, Throwables.BiConsumer<?,?,E> action) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      action -
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(Tuple.Tuple2<String,String> columnNames, int fromRowIndex, int toRowIndex, Throwables.BiConsumer<?,?,E> action) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      action -
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(Tuple.Tuple3<String,String,String> columnNames, Throwables.TriConsumer<?,?,?,E> action) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      action -
      Throws:
      E - the e
    • forEach

      <E extends Exception> void forEach(Tuple.Tuple3<String,String,String> columnNames, int fromRowIndex, int toRowIndex, Throwables.TriConsumer<?,?,?,E> action) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      action -
      Throws:
      E - the e
    • toList

      List<Object[]> toList()
      Returns:
    • toList

      List<Object[]> toList(int fromRowIndex, int toRowIndex)
      Parameters:
      fromRowIndex -
      toRowIndex -
      Returns:
    • toList

      <T> List<T> toList(Class<? extends T> rowClass)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toList

      <T> List<T> toList(Class<? extends T> rowClass, int fromRowIndex, int toRowIndex)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      fromRowIndex -
      toRowIndex -
      Returns:
    • toList

      <T> List<T> toList(Class<? extends T> rowClass, Collection<String> columnNames)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNames -
      Returns:
    • toList

      <T> List<T> toList(Class<? extends T> rowClass, Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toList

      <T> List<T> toList(IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toList

      <T> List<T> toList(int fromRowIndex, int toRowIndex, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toList

      <T> List<T> toList(Collection<String> columnNames, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toList

      <T> List<T> toList(Collection<String> columnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toList

      <T, E extends Exception, E2 extends Exception> List<T> toList(Class<? extends T> rowClass, Throwables.Predicate<? super String,E> columnNameFilter, Throwables.Function<? super String,String,E2> columnNameConverter) throws E, E2
      Type Parameters:
      T -
      E -
      E2 -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNameFilter -
      columnNameConverter -
      Returns:
      Throws:
      E
      E2
    • toList

      <T, E extends Exception, E2 extends Exception> List<T> toList(Class<? extends T> rowClass, int fromRowIndex, int toRowIndex, Throwables.Predicate<? super String,E> columnNameFilter, Throwables.Function<? super String,String,E2> columnNameConverter) throws E, E2
      Type Parameters:
      T -
      E -
      E2 -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      fromRowIndex -
      toRowIndex -
      columnNameFilter -
      columnNameConverter -
      Returns:
      Throws:
      E
      E2
    • toList

      <T, E extends Exception, E2 extends Exception> List<T> toList(Throwables.Predicate<? super String,E> columnNameFilter, Throwables.Function<? super String,String,E2> columnNameConverter, IntFunction<? extends T> rowSupplier) throws E, E2
      Type Parameters:
      T -
      E -
      E2 -
      Parameters:
      columnNameFilter -
      columnNameConverter -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
      Throws:
      E
      E2
    • toList

      <T, E extends Exception, E2 extends Exception> List<T> toList(int fromRowIndex, int toRowIndex, Throwables.Predicate<? super String,E> columnNameFilter, Throwables.Function<? super String,String,E2> columnNameConverter, IntFunction<? extends T> rowSupplier) throws E, E2
      Type Parameters:
      T -
      E -
      E2 -
      Parameters:
      fromRowIndex -
      toRowIndex -
      columnNameFilter -
      columnNameConverter -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
      Throws:
      E
      E2
    • toEntities

      <T> List<T> toEntities(Class<? extends T> beanClass, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      prefixAndFieldNameMap -
      Returns:
    • toEntities

      <T> List<T> toEntities(Class<? extends T> beanClass, int fromRowIndex, int toRowIndex, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      fromRowIndex -
      toRowIndex -
      prefixAndFieldNameMap -
      Returns:
    • toEntities

      <T> List<T> toEntities(Class<? extends T> beanClass, Collection<String> columnNames, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      columnNames -
      prefixAndFieldNameMap -
      Returns:
    • toEntities

      <T> List<T> toEntities(Class<? extends T> beanClass, Collection<String> columnNames, int fromRowIndex, int toRowIndex, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      columnNames -
      fromRowIndex -
      toRowIndex -
      prefixAndFieldNameMap -
      Returns:
    • toMergedEntities

      <T> List<T> toMergedEntities(Class<? extends T> beanClass)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      Returns:
    • toMergedEntities

      <T> List<T> toMergedEntities(Class<? extends T> beanClass, Collection<String> selectPropNames)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      selectPropNames -
      Returns:
    • toMergedEntities

      <T> List<T> toMergedEntities(Class<? extends T> beanClass, String idPropName)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      idPropName -
      Returns:
    • toMergedEntities

      <T> List<T> toMergedEntities(Class<? extends T> beanClass, String idPropName, Collection<String> selectPropNames)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      idPropName -
      selectPropNames -
      Returns:
    • toMergedEntities

      <T> List<T> toMergedEntities(Class<? extends T> beanClass, Collection<String> idPropNames, Collection<String> selectPropNames)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      idPropNames -
      selectPropNames -
      Returns:
    • toMergedEntities

      <T> List<T> toMergedEntities(Class<? extends T> beanClass, Collection<String> idPropNames, Collection<String> selectPropNames, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      idPropNames -
      selectPropNames -
      prefixAndFieldNameMap -
      Returns:
    • toMap

      <K, V> Map<K,V> toMap(String keyColumnName, String valueColumnName)
      Type Parameters:
      K - the key type
      V - the value type
      Parameters:
      keyColumnName -
      valueColumnName -
      Returns:
    • toMap

      <K, V> Map<K,V> toMap(String keyColumnName, String valueColumnName, int fromRowIndex, int toRowIndex)
      Type Parameters:
      K - the key type
      V - the value type
      Parameters:
      keyColumnName -
      valueColumnName -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toMap

      <K, V, M extends Map<K, V>> M toMap(String keyColumnName, String valueColumnName, int fromRowIndex, int toRowIndex, IntFunction<? extends M> supplier)
      Type Parameters:
      K - the key type
      V - the value type
      M -
      Parameters:
      keyColumnName -
      valueColumnName -
      fromRowIndex -
      toRowIndex -
      supplier -
      Returns:
    • toMap

      <K, V> Map<K,V> toMap(Class<? extends V> rowClass, String keyColumnName, Collection<String> valueColumnNames)
      Type Parameters:
      K - the key type
      V - the value type
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      keyColumnName -
      valueColumnNames -
      Returns:
    • toMap

      <K, V> Map<K,V> toMap(Class<? extends V> rowClass, String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex)
      Type Parameters:
      K - the key type
      V - the value type
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toMap

      <K, V, M extends Map<K, V>> M toMap(Class<? extends V> rowClass, String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends M> supplier)
      Type Parameters:
      K - the key type
      V - the value type
      M -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      supplier -
      Returns:
    • toMap

      <K, V> Map<K,V> toMap(String keyColumnName, Collection<String> valueColumnNames, IntFunction<? extends V> rowSupplier)
      Type Parameters:
      K - the key type
      V - the value type
      Parameters:
      keyColumnName -
      valueColumnNames -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toMap

      <K, V> Map<K,V> toMap(String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends V> rowSupplier)
      Type Parameters:
      K - the key type
      V - the value type
      Parameters:
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toMap

      <K, V, M extends Map<K, V>> M toMap(String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends V> rowSupplier, IntFunction<? extends M> supplier)
      Type Parameters:
      K - the key type
      V - the value type
      M -
      Parameters:
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      supplier -
      Returns:
    • toMultimap

      <K, E> ListMultimap<K,E> toMultimap(String keyColumnName, String valueColumnName)
      Type Parameters:
      K - the key type
      E -
      Parameters:
      keyColumnName -
      valueColumnName -
      Returns:
    • toMultimap

      <K, E> ListMultimap<K,E> toMultimap(String keyColumnName, String valueColumnName, int fromRowIndex, int toRowIndex)
      Type Parameters:
      K - the key type
      E -
      Parameters:
      keyColumnName -
      valueColumnName -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toMultimap

      <K, E, V extends Collection<E>, M extends Multimap<K, E, V>> M toMultimap(String keyColumnName, String valueColumnName, int fromRowIndex, int toRowIndex, IntFunction<? extends M> supplier)
      Type Parameters:
      K - the key type
      E -
      V - the value type
      M -
      Parameters:
      keyColumnName -
      valueColumnName -
      fromRowIndex -
      toRowIndex -
      supplier -
      Returns:
    • toMultimap

      <K, E> ListMultimap<K,E> toMultimap(Class<? extends E> rowClass, String keyColumnName, Collection<String> valueColumnNames)
      Type Parameters:
      K - the key type
      E -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      keyColumnName -
      valueColumnNames -
      Returns:
    • toMultimap

      <K, E> ListMultimap<K,E> toMultimap(Class<? extends E> rowClass, String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex)
      Type Parameters:
      K - the key type
      E -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toMultimap

      <K, E, V extends Collection<E>, M extends Multimap<K, E, V>> M toMultimap(Class<? extends E> rowClass, String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends M> supplier)
      Type Parameters:
      K - the key type
      E -
      V - the value type
      M -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      supplier -
      Returns:
    • toMultimap

      <K, E> ListMultimap<K,E> toMultimap(String keyColumnName, Collection<String> valueColumnNames, IntFunction<? extends E> rowSupplier)
      Type Parameters:
      K - the key type
      E -
      Parameters:
      keyColumnName -
      valueColumnNames -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toMultimap

      <K, E> ListMultimap<K,E> toMultimap(String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends E> rowSupplier)
      Type Parameters:
      K - the key type
      E -
      Parameters:
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • toMultimap

      <K, E, V extends Collection<E>, M extends Multimap<K, E, V>> M toMultimap(String keyColumnName, Collection<String> valueColumnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends E> rowSupplier, IntFunction<? extends M> supplier)
      Type Parameters:
      K - the key type
      E -
      V - the value type
      M -
      Parameters:
      keyColumnName -
      valueColumnNames -
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      supplier -
      Returns:
    • toJSON

      String toJSON()
      Returns:
    • toJSON

      String toJSON(int fromRowIndex, int toRowIndex)
      Parameters:
      fromRowIndex -
      toRowIndex -
      Returns:
    • toJSON

      String toJSON(Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toJSON

      void toJSON(File output) throws UncheckedIOException
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(File output, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(File output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(OutputStream output) throws UncheckedIOException
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(OutputStream output, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(OutputStream output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(Writer output) throws UncheckedIOException
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(Writer output, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toJSON

      void toJSON(Writer output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      String toXML()
      Returns:
    • toXML

      String toXML(String rowElementName)
      Parameters:
      rowElementName -
      Returns:
    • toXML

      String toXML(int fromRowIndex, int toRowIndex)
      Parameters:
      fromRowIndex -
      toRowIndex -
      Returns:
    • toXML

      String toXML(String rowElementName, int fromRowIndex, int toRowIndex)
      Parameters:
      rowElementName -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toXML

      String toXML(Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toXML

      String toXML(String rowElementName, Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Parameters:
      rowElementName -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toXML

      void toXML(File output) throws UncheckedIOException
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(File output, String rowElementName) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(File output, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(File output, String rowElementName, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(File output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(File output, String rowElementName, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(OutputStream output) throws UncheckedIOException
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(OutputStream output, String rowElementName) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(OutputStream output, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(OutputStream output, String rowElementName, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(OutputStream output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(OutputStream output, String rowElementName, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(Writer output) throws UncheckedIOException
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(Writer output, String rowElementName) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(Writer output, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(Writer output, String rowElementName, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(Writer output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toXML

      void toXML(Writer output, String rowElementName, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      output -
      rowElementName -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      String toCSV()
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Returns:
    • toCSV

      String toCSV(Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • toCSV

      String toCSV(boolean writeTitle, boolean quoteValue)
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      writeTitle -
      quoteValue -
      Returns:
    • toCSV

      String toCSV(Collection<String> columnNames, int fromRowIndex, int toRowIndex, boolean writeTitle, boolean quoteValue)
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      writeTitle -
      quoteValue -
      Returns:
    • toCSV

      void toCSV(File output) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(File output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(File output, boolean writeTitle, boolean quoteValue) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      writeTitle -
      quoteValue -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(File output, Collection<String> columnNames, int fromRowIndex, int toRowIndex, boolean writeTitle, boolean quoteValue) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      writeTitle -
      quoteValue -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(OutputStream output)
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(OutputStream output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(OutputStream output, boolean writeTitle, boolean quoteValue) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      writeTitle -
      quoteValue -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(OutputStream output, Collection<String> columnNames, int fromRowIndex, int toRowIndex, boolean writeTitle, boolean quoteValue) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      writeTitle -
      quoteValue -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(Writer output)
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(Writer output, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(Writer output, boolean writeTitle, boolean quoteValue) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      writeTitle -
      quoteValue -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • toCSV

      void toCSV(Writer output, Collection<String> columnNames, int fromRowIndex, int toRowIndex, boolean writeTitle, boolean quoteValue) throws UncheckedIOException
      Each line in the output file/Writer is an array of JSON String without root bracket.
      Parameters:
      output -
      columnNames -
      fromRowIndex -
      toRowIndex -
      writeTitle -
      quoteValue -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • groupBy

      <T> DataSet groupBy(String columnName, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnName -
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
    • groupBy

      <T, E extends Exception> DataSet groupBy(String columnName, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,E> func) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      Throws:
      E - the e
    • groupBy

      DataSet groupBy(String columnName, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass)
      Parameters:
      columnName -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
    • groupBy

      DataSet groupBy(String columnName, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector)
      Parameters:
      columnName -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
    • groupBy

      <T, E extends Exception> DataSet groupBy(String columnName, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,E> rowMapper, Collector<? super T,?,?> collector) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      Throws:
      E - the e
    • groupBy

      <K, T, E extends Exception> DataSet groupBy(String columnName, Throwables.Function<K,?,E> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector) throws E
      Type Parameters:
      K - the key type
      T -
      E -
      Parameters:
      columnName -
      keyMapper -
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
      Throws:
      E - the e
    • groupBy

      <K, T, E extends Exception, E2 extends Exception> DataSet groupBy(String columnName, Throwables.Function<K,?,E> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,E2> func) throws E, E2
      Type Parameters:
      K - the key type
      T -
      E -
      E2 -
      Parameters:
      columnName -
      keyMapper -
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      Throws:
      E - the e
      E2 - the e2
    • groupBy

      <K, E extends Exception> DataSet groupBy(String columnName, Throwables.Function<K,?,E> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass) throws E
      Type Parameters:
      K - the key type
      E -
      Parameters:
      columnName -
      keyMapper -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
      Throws:
      E - the e
    • groupBy

      <K, E extends Exception> DataSet groupBy(String columnName, Throwables.Function<K,?,E> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector) throws E
      Type Parameters:
      K - the key type
      E -
      Parameters:
      columnName -
      keyMapper -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
      Throws:
      E - the e
    • groupBy

      <K, T, E extends Exception, E2 extends Exception> DataSet groupBy(String columnName, Throwables.Function<K,?,E> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,E2> rowMapper, Collector<? super T,?,?> collector) throws E, E2
      Type Parameters:
      K - the key type
      T -
      E -
      E2 -
      Parameters:
      columnName -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      Throws:
      E - the e
      E2 - the e2
    • groupBy

      DataSet groupBy(Collection<String> columnNames)
      Parameters:
      columnNames -
      Returns:
    • groupBy

      <T> DataSet groupBy(Collection<String> columnNames, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
    • groupBy

      <T, E extends Exception> DataSet groupBy(Collection<String> columnNames, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,E> func) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      Throws:
      E - the e
    • groupBy

      DataSet groupBy(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass)
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
    • groupBy

      DataSet groupBy(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector)
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
    • groupBy

      <T, E extends Exception> DataSet groupBy(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,E> rowMapper, Collector<? super T,?,?> collector) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      Throws:
      E - the e
    • groupBy

      <E extends Exception> DataSet groupBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      Throws:
      E - the e
    • groupBy

      <T, E extends Exception> DataSet groupBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
      Throws:
      E - the e
    • groupBy

      <T, E extends Exception, E2 extends Exception> DataSet groupBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,E2> func) throws E, E2
      Type Parameters:
      T -
      E -
      E2 -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      Throws:
      E - the e
      E2 - the e2
    • groupBy

      <E extends Exception> DataSet groupBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
      Throws:
      E - the e
    • groupBy

      <E extends Exception> DataSet groupBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
      Throws:
      E - the e
    • groupBy

      <T, E extends Exception, E2 extends Exception> DataSet groupBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,E2> rowMapper, Collector<? super T,?,?> collector) throws E, E2
      Type Parameters:
      T -
      E -
      E2 -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      Throws:
      E - the e
      E2 - the e2
    • rollup

      @Beta Stream<DataSet> rollup(Collection<String> columnNames)
      Parameters:
      columnNames -
      Returns:
      See Also:
    • rollup

      @Beta <T> Stream<DataSet> rollup(Collection<String> columnNames, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
      See Also:
    • rollup

      @Beta <T> Stream<DataSet> rollup(Collection<String> columnNames, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,? extends Exception> func)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      See Also:
    • rollup

      @Beta Stream<DataSet> rollup(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass)
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
      See Also:
    • rollup

      @Beta Stream<DataSet> rollup(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector)
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
      See Also:
    • rollup

      @Beta <T> Stream<DataSet> rollup(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,? extends Exception> rowMapper, Collector<? super T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      See Also:
    • rollup

      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      See Also:
    • rollup

      @Beta <T> Stream<DataSet> rollup(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
      See Also:
    • rollup

      @Beta <T> Stream<DataSet> rollup(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,? extends Exception> func)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      See Also:
    • rollup

      @Beta Stream<DataSet> rollup(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass)
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
      See Also:
    • rollup

      @Beta Stream<DataSet> rollup(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector)
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
      See Also:
    • rollup

      @Beta <T> Stream<DataSet> rollup(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,? extends Exception> rowMapper, Collector<? super T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      See Also:
    • cube

      @Beta Stream<DataSet> cube(Collection<String> columnNames)
      Parameters:
      columnNames -
      Returns:
      See Also:
    • cube

      @Beta <T> Stream<DataSet> cube(Collection<String> columnNames, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
      See Also:
    • cube

      @Beta <T> Stream<DataSet> cube(Collection<String> columnNames, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,? extends Exception> func)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      See Also:
    • cube

      @Beta Stream<DataSet> cube(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass)
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
      See Also:
    • cube

      @Beta Stream<DataSet> cube(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector)
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
      See Also:
    • cube

      @Beta <T> Stream<DataSet> cube(Collection<String> columnNames, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,? extends Exception> rowMapper, Collector<? super T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      See Also:
    • cube

      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      See Also:
    • cube

      @Beta <T> Stream<DataSet> cube(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Collector<T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnName -
      collector -
      Returns:
      See Also:
    • cube

      @Beta <T> Stream<DataSet> cube(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, String aggregateOnColumnName, Throwables.Function<Stream<T>,?,? extends Exception> func)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnName -
      func -
      Returns:
      See Also:
    • cube

      @Beta Stream<DataSet> cube(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Class<?> rowClass)
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowClass -
      Returns:
      See Also:
    • cube

      @Beta Stream<DataSet> cube(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Collector<? super Object[],?,?> collector)
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      collector -
      Returns:
      See Also:
    • cube

      @Beta <T> Stream<DataSet> cube(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,? extends Exception> keyMapper, String aggregateResultColumnName, Collection<String> aggregateOnColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,T,? extends Exception> rowMapper, Collector<? super T,?,?> collector)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      aggregateResultColumnName -
      aggregateOnColumnNames -
      rowMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      collector -
      Returns:
      See Also:
    • pivot

      @Beta <R, C, U, T, E extends Exception> Sheet<R,C,T> pivot(String groupByColumnName, String pivotColumnName, String aggColumnName, Throwables.Function<Stream<U>,? extends T,E> aggFunc) throws E
      Type Parameters:
      R -
      C -
      U -
      T -
      E -
      Parameters:
      groupByColumnName -
      pivotColumnName -
      aggColumnName -
      aggFunc -
      Returns:
      Throws:
      E - the e
    • pivot

      @Beta <R, C, T> Sheet<R,C,T> pivot(String groupByColumnName, String pivotColumnName, Collection<String> aggColumnNames, Collector<? super Object[],?,? extends T> collector)
      Type Parameters:
      R -
      C -
      T -
      Parameters:
      groupByColumnName -
      pivotColumnName -
      aggColumnNames -
      collector -
      Returns:
    • pivot

      @Beta <R, C, U, T, E extends Exception> Sheet<R,C,T> pivot(String groupByColumnName, String pivotColumnName, Collection<String> aggColumnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,U,E> rowMapper, Collector<? super U,?,? extends T> collector) throws E
      Type Parameters:
      R -
      C -
      U -
      T -
      E -
      Parameters:
      groupByColumnName -
      pivotColumnName -
      aggColumnNames -
      rowMapper -
      collector -
      Returns:
      Throws:
      E - the e
    • sortBy

      void sortBy(String columnName)
      Parameters:
      columnName -
    • sortBy

      <T> void sortBy(String columnName, Comparator<T> cmp)
      Type Parameters:
      T -
      Parameters:
      columnName -
      cmp -
    • sortBy

      void sortBy(Collection<String> columnNames)
      Parameters:
      columnNames -
    • sortBy

      void sortBy(Collection<String> columnNames, Comparator<? super Object[]> cmp)
      Parameters:
      columnNames -
      cmp -
    • sortBy

      void sortBy(Collection<String> columnNames, Function<? super NoCachingNoUpdating.DisposableObjArray,? extends Comparable> keyMapper)
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
    • parallelSortBy

      void parallelSortBy(String columnName)
      Parallel sort by.
      Parameters:
      columnName -
    • parallelSortBy

      <T> void parallelSortBy(String columnName, Comparator<T> cmp)
      Parallel sort by.
      Type Parameters:
      T -
      Parameters:
      columnName -
      cmp -
    • parallelSortBy

      void parallelSortBy(Collection<String> columnNames)
      Parallel sort by.
      Parameters:
      columnNames -
    • parallelSortBy

      void parallelSortBy(Collection<String> columnNames, Comparator<? super Object[]> cmp)
      Parallel sort by.
      Parameters:
      columnNames -
      cmp -
    • parallelSortBy

      void parallelSortBy(Collection<String> columnNames, Function<? super NoCachingNoUpdating.DisposableObjArray,? extends Comparable> keyMapper)
      Parallel sort by.
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
    • topBy

      DataSet topBy(String columnName, int n)
      Parameters:
      columnName -
      n -
      Returns:
    • topBy

      <T> DataSet topBy(String columnName, int n, Comparator<T> cmp)
      Type Parameters:
      T -
      Parameters:
      columnName -
      n -
      cmp -
      Returns:
    • topBy

      DataSet topBy(Collection<String> columnNames, int n)
      Parameters:
      columnNames -
      n -
      Returns:
    • topBy

      DataSet topBy(Collection<String> columnNames, int n, Comparator<? super Object[]> cmp)
      Parameters:
      columnNames -
      n -
      cmp -
      Returns:
    • topBy

      DataSet topBy(Collection<String> columnNames, int n, Function<? super NoCachingNoUpdating.DisposableObjArray,? extends Comparable> keyMapper)
      Parameters:
      columnNames -
      n -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
    • distinct

      DataSet distinct()
      Returns a new DataSet with the rows de-duplicated by the values in all columns.
      Returns:
      a new DataSet
    • distinctBy

      DataSet distinctBy(String columnName)
      Returns a new DataSet with the rows de-duplicated by the value in the specified column.
      Parameters:
      columnName -
      Returns:
      a new DataSet
    • distinctBy

      <K, E extends Exception> DataSet distinctBy(String columnName, Throwables.Function<K,?,E> keyMapper) throws E
      Returns a new DataSet with the rows de-duplicated by the value in the specified column from the specified fromRowIndex to toRowIndex.
      Type Parameters:
      K - the key type
      E -
      Parameters:
      columnName -
      keyMapper - don't change value of the input parameter.
      Returns:
      Throws:
      E - the e
    • distinctBy

      DataSet distinctBy(Collection<String> columnNames)
      Returns a new DataSet with the rows de-duplicated by the values in the specified columns.
      Parameters:
      columnNames -
      Returns:
      a new DataSet
    • distinctBy

      <E extends Exception> DataSet distinctBy(Collection<String> columnNames, Throwables.Function<? super NoCachingNoUpdating.DisposableObjArray,?,E> keyMapper) throws E
      Returns a new DataSet with the rows de-duplicated by the values in the specified columns from the specified fromRowIndex to toRowIndex.
      Type Parameters:
      E -
      Parameters:
      columnNames -
      keyMapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(int fromRowIndex, int toRowIndex, Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      fromRowIndex -
      toRowIndex -
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(int fromRowIndex, int toRowIndex, Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      fromRowIndex -
      toRowIndex -
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple2<String,String> columnNames, Throwables.BiPredicate<?,?,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      filter -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple2<String,String> columnNames, Throwables.BiPredicate<?,?,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      filter -
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple2<String,String> columnNames, int fromRowIndex, int toRowIndex, Throwables.BiPredicate<?,?,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      filter -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple2<String,String> columnNames, int fromRowIndex, int toRowIndex, Throwables.BiPredicate<?,?,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      filter -
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple3<String,String,String> columnNames, Throwables.TriPredicate<?,?,?,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      filter -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple3<String,String,String> columnNames, Throwables.TriPredicate<?,?,?,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      filter -
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple3<String,String,String> columnNames, int fromRowIndex, int toRowIndex, Throwables.TriPredicate<?,?,?,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      filter -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Tuple.Tuple3<String,String,String> columnNames, int fromRowIndex, int toRowIndex, Throwables.TriPredicate<?,?,?,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      filter -
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <T, E extends Exception> DataSet filter(String columnName, Throwables.Predicate<T,E> filter) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      filter -
      Returns:
      Throws:
      E - the e
    • filter

      <T, E extends Exception> DataSet filter(String columnName, Throwables.Predicate<T,E> filter, int max) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      filter -
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <T, E extends Exception> DataSet filter(String columnName, int fromRowIndex, int toRowIndex, Throwables.Predicate<T,E> filter) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      fromRowIndex -
      toRowIndex -
      filter -
      Returns:
      Throws:
      E - the e
    • filter

      <T, E extends Exception> DataSet filter(String columnName, int fromRowIndex, int toRowIndex, Throwables.Predicate<T,E> filter, int max) throws E
      Type Parameters:
      T -
      E -
      Parameters:
      columnName -
      fromRowIndex -
      toRowIndex -
      filter -
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Collection<String> columnNames, Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Collection<String> columnNames, Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      max -
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Collection<String> columnNames, int fromRowIndex, int toRowIndex, Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      Returns:
      Throws:
      E - the e
    • filter

      <E extends Exception> DataSet filter(Collection<String> columnNames, int fromRowIndex, int toRowIndex, Throwables.Predicate<? super NoCachingNoUpdating.DisposableObjArray,E> filter, int max) throws E
      Type Parameters:
      E -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      filter - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      max -
      Returns:
      Throws:
      E - the e
    • map

      <E extends Exception> DataSet map(String fromColumnName, Throwables.Function<?,?,E> mapper, String newColumnName, String copyingColumnName) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnName -
      mapper -
      newColumnName -
      copyingColumnName -
      Returns:
      Throws:
      E - the e
    • map

      <E extends Exception> DataSet map(String fromColumnName, Throwables.Function<?,?,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnName -
      mapper -
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • map

      <E extends Exception> DataSet map(Tuple.Tuple2<String,String> fromColumnNames, Throwables.BiFunction<?,?,?,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnNames -
      mapper -
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • map

      <E extends Exception> DataSet map(Tuple.Tuple3<String,String,String> fromColumnNames, Throwables.TriFunction<?,?,?,?,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnNames -
      mapper -
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • map

      <E extends Exception> DataSet map(Collection<String> fromColumnNames, Throwables.Function<NoCachingNoUpdating.DisposableObjArray,?,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnNames -
      mapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • flatMap

      <E extends Exception> DataSet flatMap(String fromColumnName, Throwables.Function<?,? extends Collection<?>,E> mapper, String newColumnName, String copyingColumnName) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnName -
      mapper -
      newColumnName -
      copyingColumnName -
      Returns:
      Throws:
      E - the e
    • flatMap

      <E extends Exception> DataSet flatMap(String fromColumnName, Throwables.Function<?,? extends Collection<?>,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnName -
      mapper -
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • flatMap

      <E extends Exception> DataSet flatMap(Tuple.Tuple2<String,String> fromColumnNames, Throwables.BiFunction<?,?,? extends Collection<?>,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnNames -
      mapper -
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • flatMap

      <E extends Exception> DataSet flatMap(Tuple.Tuple3<String,String,String> fromColumnNames, Throwables.TriFunction<?,?,?,? extends Collection<?>,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnNames -
      mapper -
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • flatMap

      <E extends Exception> DataSet flatMap(Collection<String> fromColumnNames, Throwables.Function<NoCachingNoUpdating.DisposableObjArray,? extends Collection<?>,E> mapper, String newColumnName, Collection<String> copyingColumnNames) throws E
      Type Parameters:
      E -
      Parameters:
      fromColumnNames -
      mapper - DON't cache or update the input parameter DisposableObjArray or its values(Array)
      newColumnName -
      copyingColumnNames -
      Returns:
      Throws:
      E - the e
    • innerJoin

      DataSet innerJoin(DataSet right, String columnName, String refColumnName)
      Returns a new DataSet that is limited to the rows where there is a match in both this DataSet and right DataSet.
      Parameters:
      right -
      columnName -
      refColumnName -
      Returns:
      a new DataSet
    • innerJoin

      DataSet innerJoin(DataSet right, Map<String,String> onColumnNames)
      Returns a new DataSet that is limited to the rows where there is a match in both this DataSet and right DataSet.
      Parameters:
      right -
      onColumnNames -
      Returns:
      a new DataSet
    • innerJoin

      DataSet innerJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass)
      Returns a new DataSet that is limited to the rows where there is a match in both this DataSet and right DataSet.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      Returns:
      a new DataSet
    • innerJoin

      DataSet innerJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass, IntFunction<? extends Collection> collSupplier)
      Returns a new DataSet that is limited to the rows where there is a match in both this DataSet and right DataSet.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      collSupplier - it's for one-to-many join
      Returns:
      a new DataSet
    • leftJoin

      DataSet leftJoin(DataSet right, String columnName, String refColumnName)
      Returns a new DataSet that has all the rows from this DataSet and the rows from the specified right DataSet if they have a match with the rows from the this DataSet.
      Parameters:
      right -
      columnName -
      refColumnName -
      Returns:
      a new DataSet
    • leftJoin

      DataSet leftJoin(DataSet right, Map<String,String> onColumnNames)
      Returns a new DataSet that has all the rows from this DataSet and the rows from the specified right DataSet if they have a match with the rows from the this DataSet.
      Parameters:
      right -
      onColumnNames -
      Returns:
      a new DataSet
    • leftJoin

      DataSet leftJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass)
      Returns a new DataSet that has all the rows from this DataSet and the rows from the specified right DataSet if they have a match with the rows from the this DataSet.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      Returns:
      a new DataSet
    • leftJoin

      DataSet leftJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass, IntFunction<? extends Collection> collSupplier)
      Returns a new DataSet that has all the rows from this DataSet and the rows from the specified right DataSet if they have a match with the rows from the this DataSet.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      collSupplier - it's for one-to-many join
      Returns:
      a new DataSet
    • rightJoin

      DataSet rightJoin(DataSet right, String columnName, String refColumnName)
      Returns a new DataSet that has all the rows from the specified right DataSet and the rows from this DataSet if they have a match with the rows from the right DataSet.
      Parameters:
      right -
      columnName -
      refColumnName -
      Returns:
      a new DataSet
    • rightJoin

      DataSet rightJoin(DataSet right, Map<String,String> onColumnNames)
      Returns a new DataSet that has all the rows from the specified right DataSet and the rows from this DataSet if they have a match with the rows from the right DataSet.
      Parameters:
      right -
      onColumnNames -
      Returns:
      a new DataSet
    • rightJoin

      DataSet rightJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass)
      Returns a new DataSet that has all the rows from the specified right DataSet and the rows from this DataSet if they have a match with the rows from the right DataSet.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      Returns:
      a new DataSet
    • rightJoin

      DataSet rightJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass, IntFunction<? extends Collection> collSupplier)
      Returns a new DataSet that has all the rows from the specified right DataSet and the rows from this DataSet if they have a match with the rows from the right DataSet.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      collSupplier - it's for one-to-many join
      Returns:
      a new DataSet
    • fullJoin

      DataSet fullJoin(DataSet right, String columnName, String refColumnName)
      Returns a new DataSet that has all the rows from this DataSet and the specified right DataSet, regardless of whether there are any matches.
      Parameters:
      right -
      columnName -
      refColumnName -
      Returns:
      a new DataSet
    • fullJoin

      DataSet fullJoin(DataSet right, Map<String,String> onColumnNames)
      Returns a new DataSet that has all the rows from this DataSet and the specified right DataSet, regardless of whether there are any matches.
      Parameters:
      right -
      onColumnNames -
      Returns:
      a new DataSet
    • fullJoin

      DataSet fullJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass)
      Returns a new DataSet that has all the rows from this DataSet and the specified right DataSet, regardless of whether there are any matches.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      Returns:
      a new DataSet
    • fullJoin

      DataSet fullJoin(DataSet right, Map<String,String> onColumnNames, String newColumnName, Class<?> newColumnClass, IntFunction<? extends Collection> collSupplier)
      Returns a new DataSet that has all the rows from this DataSet and the specified right DataSet, regardless of whether there are any matches.
      Parameters:
      right -
      onColumnNames -
      newColumnName -
      newColumnClass - it can be Object[]/List/Set/Map/Bean
      collSupplier - it's for one-to-many join
      Returns:
      a new DataSet
    • union

      DataSet union(DataSet dataSet)
      Returns a new DataSet. Duplicated row in the specified DataSet will be eliminated.
      Parameters:
      dataSet -
      Returns:
      a new DataSet
    • unionAll

      DataSet unionAll(DataSet dataSet)
      Returns a new DataSet. Duplicated row in the specified DataSet will not be eliminated.
      Parameters:
      dataSet -
      Returns:
      a new DataSet
    • intersect

      DataSet intersect(DataSet other)
      Returns a new DataSet with all rows from this DataSet and which also appear in the specified other in common columns. This operation removes duplicate rows from the final result set.
      Parameters:
      other -
      Returns:
    • intersectAll

      DataSet intersectAll(DataSet other)
      Returns a new DataSet with all rows from this DataSet and which also appear in the specified other in common columns. This operation doesn't remove duplicate rows from the final result set.
      Parameters:
      other -
      Returns:
      See Also:
    • intersection

      DataSet intersection(DataSet dataSet)
      Returns a new DataSet with all rows from this DataSet and which also appear in the specified other in common columns by occurrences. This operation only cares the occurrences of rows in both DataSet. it doesn't remove duplicate.
      Parameters:
      dataSet -
      Returns:
      a new DataSet
      See Also:
    • except

      DataSet except(DataSet other)
      Returns a new DataSet with all rows from this DataSet and which not appear in the specified other in common columns.
      Parameters:
      other -
      Returns:
      See Also:
    • difference

      DataSet difference(DataSet dataSet)
      Returns a new DataSet with different rows in common columns from the specified DataSet, occurrences matter.
      Parameters:
      dataSet -
      Returns:
      a new DataSet
      See Also:
    • symmetricDifference

      DataSet symmetricDifference(DataSet dataSet)
      Parameters:
      dataSet -
      Returns:
      See Also:
    • merge

      DataSet merge(DataSet from)
      Returns a new DataSet by appending the specified from DataSet into this DataSet.
      Parameters:
      from -
      Returns:
    • merge

      DataSet merge(DataSet from, Collection<String> columnNames)
      Returns a new DataSet by appending the specified from DataSet into this DataSet.
      Parameters:
      from -
      columnNames -
      Returns:
    • merge

      DataSet merge(DataSet from, int fromRowIndex, int toRowIndex)
      Returns a new DataSet by appending the specified from DataSet from fromRowIndex to toRowIndex into this DataSet.
      Parameters:
      from -
      fromRowIndex -
      toRowIndex -
      Returns:
    • merge

      DataSet merge(DataSet from, Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Returns a new DataSet by appending the specified columnNames in from DataSet from fromRowIndex to toRowIndex into this DataSet.
      Parameters:
      from -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • merge

      DataSet merge(DataSet a, DataSet b)
      Parameters:
      a -
      b -
      Returns:
    • merge

      DataSet merge(Collection<? extends DataSet> dss)
      Parameters:
      dss -
      Returns:
    • cartesianProduct

      DataSet cartesianProduct(DataSet b)
      Parameters:
      b -
      Returns:
    • split

      Stream<DataSet> split(int chunkSize)
      Returns consecutive sub lists of this DataSet, each of the same chunkSize (the list may be smaller), or an empty List if this DataSet is empty.
      Parameters:
      chunkSize - the desired size of each sub DataSet (the last may be smaller).
      Returns:
    • split

      Stream<DataSet> split(Collection<String> columnNames, int chunkSize)
      Returns consecutive sub lists of this DataSet, each of the same chunkSize (the list may be smaller), or an empty List if this DataSet is empty.
      Parameters:
      columnNames -
      chunkSize - the desired size of each sub DataSet (the last may be smaller).
      Returns:
    • splitToList

      List<DataSet> splitToList(int chunkSize)
      Returns consecutive sub lists of this DataSet, each of the same chunkSize (the list may be smaller), or an empty List if this DataSet is empty.
      Parameters:
      chunkSize -
      Returns:
    • splitToList

      List<DataSet> splitToList(Collection<String> columnNames, int chunkSize)
      Returns consecutive sub lists of this DataSet, each of the same chunkSize (the list may be smaller), or an empty List if this DataSet is empty.
      Parameters:
      columnNames -
      chunkSize -
      Returns:
    • slice

      DataSet slice(Collection<String> columnNames)
      Returns a frozen slice view on this DataSet.
      Parameters:
      columnNames -
      Returns:
      a copy of this DataSet
    • slice

      DataSet slice(int fromRowIndex, int toRowIndex)
      Returns a frozen slice view on this DataSet.
      Parameters:
      fromRowIndex -
      toRowIndex -
      Returns:
      a copy of this DataSet
    • slice

      DataSet slice(Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Returns a frozen slice view on this DataSet.
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
      a copy of this DataSet
    • copy

      DataSet copy()
      Returns the copy of this DataSet. The frozen status of the copy will always be false, even the original DataSet is frozen.
      Returns:
      a copy of this DataSet
    • copy

      DataSet copy(Collection<String> columnNames)
      Returns the copy of this DataSet with specified column name list. The frozen status of the copy will always be false, even the original DataSet is frozen.
      Parameters:
      columnNames -
      Returns:
      a copy of this DataSet
    • copy

      DataSet copy(int fromRowIndex, int toRowIndex)
      Returns the copy of this DataSet from the specified fromRowIndex to toRowIndex. The frozen status of the copy will always be false, even the original DataSet is frozen.
      Parameters:
      fromRowIndex -
      toRowIndex -
      Returns:
      a copy of this DataSet
    • copy

      DataSet copy(Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Returns the copy of this DataSet with specified column name list from the specified fromRowIndex to toRowIndex. The frozen status of the copy will always be false, even the original DataSet is frozen.
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
      a copy of this DataSet
    • clone

      DataSet clone()
      Deeply copy each element in this DataSet by Serialization/Deserialization.
      Returns:
    • clone

      DataSet clone(boolean freeze)
      Deeply copy each element in this DataSet by Serialization/Deserialization.
      Parameters:
      freeze -
      Returns:
    • iterator

      <A, B> BiIterator<A,B> iterator(String columnNameA, String columnNameB)
      Type Parameters:
      A -
      B -
      Parameters:
      columnNameA -
      columnNameB -
      Returns:
    • iterator

      <A, B> BiIterator<A,B> iterator(String columnNameA, String columnNameB, int fromRowIndex, int toRowIndex)
      Type Parameters:
      A -
      B -
      Parameters:
      columnNameA -
      columnNameB -
      fromRowIndex -
      toRowIndex -
      Returns:
    • iterator

      <A, B, C> TriIterator<A,B,C> iterator(String columnNameA, String columnNameB, String columnNameC)
      Type Parameters:
      A -
      B -
      C -
      Parameters:
      columnNameA -
      columnNameB -
      columnNameC -
      Returns:
    • iterator

      <A, B, C> TriIterator<A,B,C> iterator(String columnNameA, String columnNameB, String columnNameC, int fromRowIndex, int toRowIndex)
      Type Parameters:
      A -
      B -
      C -
      Parameters:
      columnNameA -
      columnNameB -
      columnNameC -
      fromRowIndex -
      toRowIndex -
      Returns:
    • paginate

      PaginatedDataSet paginate(int pageSize)
      Parameters:
      pageSize -
      Returns:
    • paginate

      PaginatedDataSet paginate(Collection<String> columnNames, int pageSize)
      Parameters:
      columnNames -
      pageSize -
      Returns:
    • stream

      <T> Stream<T> stream(String columnName)
      Type Parameters:
      T -
      Parameters:
      columnName -
      Returns:
    • stream

      <T> Stream<T> stream(String columnName, int fromRowIndex, int toRowIndex)
      Type Parameters:
      T -
      Parameters:
      columnName -
      fromRowIndex -
      toRowIndex -
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> rowClass)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> rowClass, int fromRowIndex, int toRowIndex)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      fromRowIndex -
      toRowIndex -
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> rowClass, Collection<String> columnNames)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNames -
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> rowClass, Collection<String> columnNames, int fromRowIndex, int toRowIndex)
      Type Parameters:
      T -
      Parameters:
      rowClass - it can be Object[]/List/Set/Map/Bean
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
    • stream

      <T> Stream<T> stream(IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • stream

      <T> Stream<T> stream(int fromRowIndex, int toRowIndex, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • stream

      <T> Stream<T> stream(Collection<String> columnNames, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • stream

      <T> Stream<T> stream(Collection<String> columnNames, int fromRowIndex, int toRowIndex, IntFunction<? extends T> rowSupplier)
      Type Parameters:
      T -
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      rowSupplier - it can be Object[]/List/Set/Map/Bean
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> beanClass, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      prefixAndFieldNameMap -
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> beanClass, int fromRowIndex, int toRowIndex, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      fromRowIndex -
      toRowIndex -
      prefixAndFieldNameMap -
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> beanClass, Collection<String> columnNames, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      columnNames -
      prefixAndFieldNameMap -
      Returns:
    • stream

      <T> Stream<T> stream(Class<? extends T> beanClass, Collection<String> columnNames, int fromRowIndex, int toRowIndex, Map<String,String> prefixAndFieldNameMap)
      Type Parameters:
      T -
      Parameters:
      beanClass -
      columnNames -
      fromRowIndex -
      toRowIndex -
      prefixAndFieldNameMap -
      Returns:
    • apply

      <R, E extends Exception> R apply(Throwables.Function<? super DataSet,? extends R,E> func) throws E
      Type Parameters:
      R -
      E -
      Parameters:
      func -
      Returns:
      Throws:
      E - the e
    • applyIfNotEmpty

      <R, E extends Exception> u.Optional<R> applyIfNotEmpty(Throwables.Function<? super DataSet,? extends R,E> func) throws E
      Type Parameters:
      R -
      E -
      Parameters:
      func -
      Returns:
      Throws:
      E - the e
    • accept

      <E extends Exception> void accept(Throwables.Consumer<? super DataSet,E> action) throws E
      Type Parameters:
      E -
      Parameters:
      action -
      Throws:
      E - the e
    • acceptIfNotEmpty

      <E extends Exception> void acceptIfNotEmpty(Throwables.Consumer<? super DataSet,E> action) throws E
      Type Parameters:
      E -
      Parameters:
      action -
      Throws:
      E - the e
    • freeze

      void freeze()
      Method freeze.
    • isFrozen

      boolean isFrozen()
      Returns:
      true, if successful
    • clear

      void clear()
      Method clear.
    • isEmpty

      boolean isEmpty()
      Checks if is empty.
      Returns:
      true, if is empty
    • trimToSize

      void trimToSize()
      Trim to size.
    • size

      int size()
      Returns the size of this DataSet.
      Returns:
    • properties

      @Beta Properties<String,Object> properties()
      Returns:
    • columnNames

      Stream<String> columnNames()
      Returns:
    • columns

      Returns:
    • columnMap

      Returns:
      key are column name, value is column - an immutable list, backed by the column in this DataSet.
    • println

      void println() throws UncheckedIOException
      Throws:
      UncheckedIOException - the unchecked IO exception
    • println

      void println(Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Parameters:
      columnNames -
      fromRowIndex -
      toRowIndex -
      Throws:
      UncheckedIOException - the unchecked IO exception
    • println

      <W extends Writer> W println(W outputWriter) throws UncheckedIOException
      Type Parameters:
      W -
      Parameters:
      outputWriter -
      Returns:
      Throws:
      UncheckedIOException - the unchecked IO exception
    • println

      <W extends Writer> W println(W outputWriter, Collection<String> columnNames, int fromRowIndex, int toRowIndex) throws UncheckedIOException
      Type Parameters:
      W -
      Parameters:
      outputWriter -
      columnNames -
      fromRowIndex -
      toRowIndex -
      Returns:
      Throws:
      UncheckedIOException - the unchecked IO exception