TypeDetectionScheme Parameter (Connect-HarperDB Cmdlet)
Comma-separated options for how the provider will scan the data to determine the fields and datatypes in each document collection.
Syntax
Connect-HarperDB -TypeDetectionScheme string
Possible Values
None, RowScanData Type
cstr
Default Value
"RowScan"
Remarks
| None | Setting TypeDetectionScheme to None will return all columns as a string type. |
| RowScan | Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. When TypeDetectionScheme is set to RowScan, the driver will validate all INSERT or update values against the rowscanned datatype the driver has obtained for the column. If this validation fails, an error message will be thrown. This validation behavior can be avoided by setting TypeDetectionScheme to None, or by using a custom schema file for the table and customizing the datatype for the column in this file. |