Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

HANA Provider: Add support for fast extent estimation (Request in QGIS) #9143

Closed
qgis-bot opened this issue Jun 22, 2024 · 2 comments · Fixed by #9142
Closed

HANA Provider: Add support for fast extent estimation (Request in QGIS) #9143

qgis-bot opened this issue Jun 22, 2024 · 2 comments · Fixed by #9142
Labels
3.38 QGIS 3.38 new features
Milestone

Comments

@qgis-bot
Copy link
Collaborator

Request for documentation

From pull request qgis/QGIS#57654
Author: @jatsqi
QGIS version: 3.38

HANA Provider: Add support for fast extent estimation

PR Description:

Description

With QRC/1 2024 a new and faster way to estimate extents of spatial column has been added to HANA.
More precisely, users can now use special columns in this table to get an estimation of the extent of a spatial column.
Even though the stored extent is only an estimation, it is often good enough.
Especially for very large tables costly aggregation functions are avoided every time the extent is recomputed.
The extent information in the mentioned HANA table is only available after a delta-merge, so a fallback to the standard behaviour, i.e. via aggregation functions, was added in case the data is unavailable or has not yet been computed.

Summary of changes:

  1. Support for the mentioned fast extent estimation added
  2. Fallback in case of unavailability added
  3. Checkbox to enable behaviour added to HANA connection widget (see image down below, 'Use estimated table metadata')

image

Commits tagged with [need-docs] or [FEATURE]

@github-actions github-actions bot added the 3.38 QGIS 3.38 new features label Jun 22, 2024
@github-actions github-actions bot added this to the QGIS 3.40 milestone Jun 22, 2024
@jatsqi
Copy link
Contributor

jatsqi commented Jun 24, 2024

Hi, I already opened a PR for this (#9142).
This should include all necessary changes to the public documentation.

@selmaVH1
Copy link
Collaborator

Thank you @jatsqi

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
3.38 QGIS 3.38 new features
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants