Excel Add-In for Apache HBase

Build 21.0.7930

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
DatetimeFormatThe format used when inserting datetime values into the database.
IncludeDisabledTablesSpecifies whether to retrieve the disabled table.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from Apache HBase.
ReadonlyYou can use this property to enforce read-only access to Apache HBase from the provider.
ResetTableMetadataOnDeleteSpecifies whether to reset the catch table after executing the Delete Statement.
RetrieveSelectedColumnsOnlySpecifies whether to retrieve selected columns only when executing a SELECT statement.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
TypeDetectionSchemeDetermines how to determine the data type of columns.
UseSQLFilteringSpecifies whether to use the ScannerFilter when executing the Select Statement.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930