SSIS Components for Apache HBase

Build 21.0.7930

RetrieveSelectedColumnsOnly

Specifies whether to retrieve selected columns only when executing a SELECT statement.

Data Type

bool

Default Value

false

Remarks

By default, the component will create a generic scanner to retrieve the results from HBase. This enables all values to be returned without HBase filtering out rows containing empty columns that were selected.

When set to 'True', the component will only retrieve the selected columns from HBase. Note in this scenario, HBase will not return rows where a selected column is empty. In such a case, this can cause a different number of rows to be returned for various queries. This setting can improve performance but it should only be used when you know that there are no empty values for the selected columns or in the case that you don't want these rows to be returned.

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