deephaven.TableTools¶

Tools for users to manipulate tables.

base64Fingerprint(source)¶

Compute the SHA256 hash of the input table and return it in base64 string format.

Parameters: source – (com.illumon.iris.db.tables.Table) - The table to fingerprint
Returns: (java.lang.String) The SHA256 hash of the table data and TableDefinition

byteCol(name, *data)¶

Creates a new ColumnHolder of type byte that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int or list of ints
a numpy.ndarray of integer or floating point values. NaN values will be mapped to NULL_BYTE constant values, and all other values simply cast.
a pandas.Series whose values are a numpy array described above

charCol(name, *data)¶

Creates a new ColumnHolder of type char that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int
a string - will be interpreted as list of characters
a numpy.ndarray of integer or one-character string type
a pandas.Series whose values are a numpy array described above
an iterable of integers or strings - if string, only the first character will be used

col(name, *data)¶

Returns a ColumnHolder that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int, bool, float, datetime, date, string or iterable of (one) such
numpy.ndarray containing boolean, numerical, datetime64, object, or string data (type inferred)
pandas.Series object whose values are such a numpy array

colSource(*args)¶

Creates a column of appropriate type, used for creating in-memory tables.

Parameters: data – variable argument for the data
Returns: (com.illumon.iris.db.v2.sources.ColumnSource<T>) a Deephaven ColumnSource of inferred type

data structure:

a java object, or list of java objects
an int, bool, float, datetime, date, string or iterable of (one) such
pandas.Series object whose values are such a numpy array

computeFingerprint(source)¶

Compute the SHA256 hash of the input table. The hash is computed using every value in each row, using toString for unrecognized objects.

The hash also includes the input table definition column names and types.

Parameters: source – (com.illumon.iris.db.tables.Table) - The table to fingerprint
Returns: (byte[]) The SHA256 hash of the table data and TableDefinition

diff(*args)¶

Computes the difference of two tables for use in verification.

Overload 1

param actualResult: (com.illumon.iris.db.tables.Table) - first Deephaven table object to compare
param expectedResult: (com.illumon.iris.db.tables.Table) - second Deephaven table object to compare
param maxDiffLines: (long) - stop comparing after this many differences are found
return: (java.lang.String) String report of the detected differences

Overload 2

param actualResult: (com.illumon.iris.db.tables.Table) - first Deephaven table object to compare
param expectedResult: (com.illumon.iris.db.tables.Table) - second Deephaven table object to compare
param maxDiffLines: (long) - stop comparing after this many differences are found
param itemsToSkip: (java.util.EnumSet<com.illumon.iris.db.tables.utils.TableDiff.DiffItems>) - EnumSet of checks not to perform, such as checking column order, or exact match of double values
return: (java.lang.String) String report of the detected differences

diffPair(actualResult, expectedResult, maxDiffLines, itemsToSkip)¶

Computes the difference of two tables for use in verification.

Parameters

actualResult – (com.illumon.iris.db.tables.Table) - first Deephaven table object to compare
expectedResult – (com.illumon.iris.db.tables.Table) - second Deephaven table object to compare
maxDiffLines – (long) - stop comparing after this many differences are found
itemsToSkip – (java.util.EnumSet<com.illumon.iris.db.tables.utils.TableDiff.DiffItems>) - EnumSet of checks not to perform, such as checking column order, or exact match of double values

Returns

(com.fishlib.base.Pair<java.lang.String,java.lang.Long>) a pair of String report of the detected differences, and the first different row (0 if there are no different data values)

doubleCol(name, *data)¶

Creates a new ColumnHolder of type double that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int or float or list of ints or floats
a numpy.ndarray of integer or floating point values. NaN values will be mapped to NULL_DOUBLE
constant values, and all other values simply cast.
a pandas.Series whose values are a numpy array described above

emptyTable(*args)¶

Returns a new, empty Deephaven Table.

Overload 1

param size: (long) - the number of rows to allocate space for
return: (com.illumon.iris.db.tables.Table) a Deephaven Table with no columns.

Overload 2

param size: (long) - the number of rows to allocate space for
param tableDefinition: (com.illumon.iris.db.tables.TableDefinition) - the TableDefinition (column names and properties) to use for the new table
return: (com.illumon.iris.db.tables.Table) a Deephaven Table with columns.

floatCol(name, *data)¶

Creates a new ColumnHolder of type float that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

a int or float or list of ints or floats
a numpy.ndarray of integer or floating point values. NaN values will be mapped to NULL_FLOAT constant values, and all other values simply cast.
a pandas.Series whose values are a numpy array described above

getKey(groupByColumnSources, row)¶

Returns a SmartKey for the specified row from a set of ColumnSources.

Parameters

groupByColumnSources – (com.illumon.iris.db.v2.sources.ColumnSource[]) - a set of ColumnSources from which to retrieve the data
row – (long) - the row number for which to retrieve data

Returns

(java.lang.Object) a Deephaven SmartKey object

getPrevKey(groupByColumnSources, row)¶

Returns a SmartKey for the row previous to the specified row from a set of ColumnSources.

Parameters

groupByColumnSources – (com.illumon.iris.db.v2.sources.ColumnSource[]) - a set of ColumnSources from which to retrieve the data
row – (long) - the row number for which to retrieve the previous row’s data

Returns

(java.lang.Object) a Deephaven SmartKey object

html(source)¶

Returns a printout of a table formatted as HTML. Limit use to small tables to avoid running out of memory.

Parameters: source – (com.illumon.iris.db.tables.Table) - a Deephaven table object
Returns: (java.lang.String) a String of the table printout formatted as HTML

intCol(name, *data)¶

Creates a new ColumnHolder of type int that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int or list of ints
a numpy.ndarray of integer or floating point values. NaN values will be mapped to NULL_INT constant values, and all other values simply cast.
a pandas.Series whose values are a numpy array described above

longCol(name, *data)¶

Creates a new ColumnHolder of type long that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int or list of ints
a numpy.ndarray of integer or floating point values. NaN values will be mapped to NULL_LONG constant values, and all other values simply cast.
a pandas.Series whose values are a numpy array described above

merge(*args)¶

Concatenates multiple Deephaven Tables into a single Table.

For historical tables, the resultant table will have rows from the same table together, in the order they are specified as inputs.

For ticking tables, the original result will be similarly ordered; however as tables grow the new rows

for each table may be appended to the end of the result and intermixed. To ensure input order, you must annotate each table with a column indicating the source and then sort the result based on that column.

Overload 1

param theList: (java.util.List<com.illumon.iris.db.tables.Table>) - a List of Tables to be concatenated
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 2

param tables: (java.util.Collection<com.illumon.iris.db.tables.Table>) - a Collection of Tables to be concatenated
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 3

param tables: (com.illumon.iris.db.tables.Table…) - a list of Tables to be concatenated
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

mergeSorted(keyColumn, *tables)¶

Concatenates multiple sorted Deephaven Tables into a single Table sorted by the specified key column.

The input tables must each individually be sorted by keyColumn, otherwise results are undefined.

Overload 1

param keyColumn: (java.lang.String) - the column to use when sorting the concatenated results
param tables: (com.illumon.iris.db.tables.Table…) - sorted Tables to be concatenated
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 2

param keyColumn: (java.lang.String) - the column to use when sorting the concatenated results
param tables: (java.util.Collection<com.illumon.iris.db.tables.Table>) - a Collection of sorted Tables to be concatenated
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

newTable(*args)¶

Creates a new DynamicTable.

Overload 1

param size: (long) - the number of rows to allocate
param names: (java.util.List<java.lang.String>) - a List of column names
param columnSources: (java.util.List<com.illumon.iris.db.v2.sources.ColumnSource>) - a List of the ColumnSource(s)
return: (com.illumon.iris.db.v2.DynamicTable) a Deephaven DynamicTable

Overload 2

param size: (long) - the number of rows to allocate
param columns: (java.util.Map<java.lang.String,com.illumon.iris.db.v2.sources.ColumnSource>) - a Map of column names and ColumnSources
return: (com.illumon.iris.db.v2.DynamicTable) a Deephaven DynamicTable

Overload 3

param definition: (com.illumon.iris.db.tables.TableDefinition) - the TableDefinition (column names and properties) to use for the new table
return: (com.illumon.iris.db.v2.DynamicTable) an empty Deephaven DynamicTable object

Overload 4

param columnHolders: (com.illumon.iris.db.v2.utils.ColumnHolder…) - a list of ColumnHolders from which to create the table
return: (com.illumon.iris.db.v2.DynamicTable) a Deephaven DynamicTable

objColSource(*values)¶

Creates a column of appropriate object type, used for creating in-memory tables.

Parameters: data – variable argument for the data
Returns: (com.illumon.iris.db.v2.sources.ColumnSource) a Deephaven ColumnSource of inferred type

data structure:

a java object, or list of java objects
an int, bool, float, datetime, date, string or iterable of (one) such

numpy.ndarray containing boolean, numerical, datetime64, object, or string data (type inferred)
pandas.Series object whose values are such a numpy array

readBin(*args)¶

Loads a binary log file as an in-memory DB table. Requires access to the listener class that matches the file to be loaded.

Overload 1

param namespace: (java.lang.String) - namespace to search for the Listener needed to import the data
param tableName: (java.lang.String) - table name to find for the Listener needed to import the data
param sourceDirectory: (java.io.File) - file system path of the log file
param sourceFileNameGlob: (java.lang.String) - file pattern to use to find log file(s) to import
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 2

param namespace: (java.lang.String) - namespace to search for the Listener needed to import the data
param tableName: (java.lang.String) - table name to find for the Listener needed to import the data
param sourceFiles: (java.lang.String…) - list of names of files to import
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 3

param namespace: (java.lang.String) - namespace to search for the Listener needed to import the data
param tableName: (java.lang.String) - table name to find for the Listener needed to import the data
param sourceFiles: (java.io.File…) - list of File objects to import
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 4

param namespace: (java.lang.String) - namespace to search for the Listener needed to import the data
param tableName: (java.lang.String) - table name to find for the Listener needed to import the data
param tableType: (com.illumon.iris.db.v2.locations.TableType) - table type this table definition
param sourceFiles: (java.io.File…) - list of File objects to import
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 5

param namespace: (java.lang.String) - namespace to search for the Listener needed to import the data
param tableName: (java.lang.String) - table name to find for the Listener needed to import the data
param tableDefinition: (com.illumon.iris.db.tables.TableDefinition) - use this table definition rather than looking one up
param sourceFiles: (java.io.File…) - list of File objects to import
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

Overload 6

param key: (com.illumon.iris.db.v2.locations.TableKey) - Interface that specifies key fields for a table-keyed object.
param sourceFiles: (java.io.File…) - list of File objects to import
return: (com.illumon.iris.db.tables.Table) a Deephaven table object

readCsv(*args)¶

Returns a memory table created from importing CSV data. The first row must be column names. Column data types are inferred from the data.

Overload 1

param is: (java.io.InputStream) - an InputStream providing access to the CSV data.
return: (com.illumon.iris.db.v2.DynamicTable) a Deephaven DynamicTable object

Overload 2

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 3

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
param format: (java.lang.String) - an Apache Commons CSV format name to be used to parse the CSV
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 4

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
param format: (java.lang.String) - an Apache Commons CSV format name to be used to parse the CSV
param progress: (com.illumon.util.progress.StatusCallback) - a StatusCallback object that can be used to log progress details or update a progress bar. If passed explicitly as null, a StatusCallback instance will be created to log progress to the current logger.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 5

param file: (java.io.File) - a file object providing access to the CSV file to be read
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 6

param file: (java.io.File) - a file object providing access to the CSV file to be read
param progress: (com.illumon.util.progress.StatusCallback) - a StatusCallback object that can be used to log progress details or update a progress bar. If passed explicitly as null, a StatusCallback instance will be created to log progress to the current logger.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 7

param file: (java.io.File) - a file object providing access to the CSV file to be read
param format: (java.lang.String) - an Apache Commons CSV format name to be used to parse the CSV
param progress: (com.illumon.util.progress.StatusCallback) - a StatusCallback object that can be used to log progress details or update a progress bar. If passed explicitly as null, a StatusCallback instance will be created to log progress to the current logger.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

readHeaderlessCsv(*args)¶

Returns a memory table created from importing CSV data. Column data types are inferred from the data.

Overload 1

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 2

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
param header: (java.util.Collection<java.lang.String>) - Column names to use for the resultant table.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 3

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
param header: (java.lang.String…) - Column names to use for the resultant table.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 4

param filePath: (java.lang.String) - the fully-qualified path to a CSV file to be read
param format: (java.lang.String) - an Apache Commons CSV format name to be used to parse the CSV
param progress: (com.illumon.util.progress.StatusCallback) - a StatusCallback object that can be used to log progress details or update a progress bar. If passed explicitly as null, a StatusCallback instance will be created to log progress to the current logger.
param header: (java.util.Collection<java.lang.String>) - Column names to use for the resultant table.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

Overload 5

param file: (java.io.File) - a file object providing access to the CSV file to be read
param format: (java.lang.String) - an Apache Commons CSV format name to be used to parse the CSV
param progress: (com.illumon.util.progress.StatusCallback) - a StatusCallback object that can be used to log progress details or update a progress bar. If passed explicitly as null, a StatusCallback instance will be created to log progress to the current logger.
param header: (java.util.Collection<java.lang.String>) - Column names to use for the resultant table, or null if column names should be automatically generated.
return: (com.illumon.iris.db.tables.Table) a Deephaven Table object

roundDecimalColumns(*args)¶

Produce a new table with all the columns of this table, in the same order, but with double and

float columns rounded to longs.

Overload 1

param table: com.illumon.iris.db.tables.Table
return: (com.illumon.iris.db.tables.Table) The new Table, with all double and float columns rounded to longs.

Overload 2

param table: com.illumon.iris.db.tables.Table
param columns: (java.lang.String…) - The names of the double and float columns to round.
return: (com.illumon.iris.db.tables.Table) The new Table, with the specified columns rounded to longs.

roundDecimalColumnsExcept(table, *columnsNotToRound)¶

Produce a new table with all the columns of this table, in the same order, but with all double and: float columns rounded to longs, except for the specified columnsNotToRound.

Parameters

table – com.illumon.iris.db.tables.Table
columnsNotToRound – (java.lang.String…) - The names of the double and float columns not to round to longs

Returns

(com.illumon.iris.db.tables.Table) The new Table, with columns modified as explained above

shortCol(name, *data)¶

Creates a new ColumnHolder of type short that can be used when creating in-memory tables.

Parameters

name – name for the column
data – variable argument for the data

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

data structure:

an int or list of ints
a numpy.ndarray of integer or floating point values. NaN values will be mapped to NULL_SHORT constant values, and all other values simply cast.
a pandas.Series whose values are a numpy array described above

show(*args)¶

Prints the first few rows of a table to standard output.

Overload 1

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param columns: (java.lang.String…) - varargs of column names to display

Overload 2

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param columns: (java.lang.String…) - varargs of column names to display

Overload 3

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param columns: (java.lang.String…) - varargs of column names to display

Overload 4

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param columns: (java.lang.String…) - varargs of column names to display

Overload 5

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param out: (java.io.PrintStream) - a PrintStream destination to which to print the data
param columns: (java.lang.String…) - varargs of column names to display

Overload 6

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param delimiter: (java.lang.String) - a String value to use between printed values
param out: (java.io.PrintStream) - a PrintStream destination to which to print the data
param showIndex: (boolean) - a boolean indicating whether to also print index details
param columns: (java.lang.String…) - varargs of column names to display

showCommaDelimited(*args)¶

Prints the first few rows of a table to standard output, with commas between values.

Overload 1

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param columns: (java.lang.String…) - varargs of column names to display

Overload 2

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param columns: (java.lang.String…) - varargs of column names to display

showWithIndex(*args)¶

Prints the first few rows of a table to standard output, and also prints the details of the index and record positions that provided the values.

Overload 1

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param columns: (java.lang.String…) - varargs of column names to display

Overload 2

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param columns: (java.lang.String…) - varargs of column names to display

Overload 3

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param maxRowCount: (long) - the number of rows to return
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param out: (java.io.PrintStream) - a PrintStream destination to which to print the data
param columns: (java.lang.String…) - varargs of column names to display

Overload 4

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param firstRow: (long) - the firstRow to display
param lastRow: (long) - the lastRow (exclusive) to display
param out: (java.io.PrintStream) - a PrintStream destination to which to print the data
param columns: (java.lang.String…) - varargs of column names to display

Overload 5

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param firstRow: (long) - the firstRow to display
param lastRow: (long) - the lastRow (exclusive) to display
param columns: (java.lang.String…) - varargs of column names to display

string(*args)¶

Returns the first few rows of a table as a pipe-delimited string.

Overload 1

param t: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param columns: (java.lang.String…) - varargs of columns to include in the result
return: (java.lang.String) a String

Overload 2

param t: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param size: (int) - the number of rows to return
param columns: (java.lang.String…) - varargs of columns to include in the result
return: (java.lang.String) a String

Overload 3

param t: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param columns: (java.lang.String…) - varargs of columns to include in the result
return: (java.lang.String) a String

Overload 4

param t: (com.illumon.iris.db.tables.Table) - a Deephaven table object
param size: (int) - the number of rows to return
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param columns: (java.lang.String…) - varargs of columns to include in the result
return: (java.lang.String) a String

stringCol(name, *data)¶

Returns a ColumnHolder of type String that can be used when creating in-memory tables.

Parameters

name – (java.lang.String) - name of the column
data – (java.lang.String…) - a list of values for the column

Returns

(com.illumon.iris.db.v2.utils.ColumnHolder) a Deephaven ColumnHolder object

writeCsv(*args)¶

Writes a DB table out as a CSV.

Overload 1

param sourcePath: (java.lang.String) - path to the table files to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 2

param sourcePath: (java.lang.String) - path to the table files to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param nullsAsEmpty: boolean
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 3

param sourcePath: (java.lang.String) - path to the table files to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 4

param sourcePath: (java.lang.String) - path to the table files to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param nullsAsEmpty: (boolean) - if nulls should be written as blank instead of ‘(null)’
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 5

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param compressed: (boolean) - whether to compress (bz2) the file being written
param destPath: (java.lang.String) - path to the CSV file to be written
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 6

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param compressed: (boolean) - whether to compress (bz2) the file being written
param destPath: (java.lang.String) - path to the CSV file to be written
param nullsAsEmpty: (boolean) - if nulls should be written as blank instead of ‘(null)’
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 7

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 8

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param nullsAsEmpty: (boolean) - if nulls should be written as blank instead of ‘(null)’
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 9

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param out: (java.io.PrintStream) - the stream to write to
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 10

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param out: (java.io.PrintStream) - the stream to write to
param nullsAsEmpty: (boolean) - if nulls should be written as blank instead of ‘(null)’
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 11

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param compressed: (boolean) - whether to zip the file being written
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 12

param source: (com.illumon.iris.db.tables.Table) - a Deephaven table object to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param compressed: (boolean) - whether to zip the file being written
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param nullsAsEmpty: (boolean) - if nulls should be written as blank instead of ‘(null)’
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 13

param sources: (com.illumon.iris.db.tables.Table[]) - an array of Deephaven table objects to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param compressed: (boolean) - whether to compress (bz2) the file being written
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param separator: (java.lang.String) - a String (normally a single character) to be used as the field delimiter
param columns: (java.lang.String…) - a list of columns to include in the export

Overload 14

param sources: (com.illumon.iris.db.tables.Table[]) - an array of Deephaven table objects to be exported
param destPath: (java.lang.String) - path to the CSV file to be written
param compressed: (boolean) - whether to compress (bz2) the file being written
param timeZone: (com.illumon.iris.db.tables.utils.DBTimeZone) - a DBTimeZone constant relative to which DBDateTime data should be adjusted
param separator: (java.lang.String) - a String (normally a single character) to be used as the field delimiter
param nullsAsEmpty: (boolean) - if nulls should be written as blank instead of ‘(null)’
param columns: (java.lang.String…) - a list of columns to include in the export

deephaven.TableTools¶

Deephaven

Navigation

Related Topics