Add support for secondary dimensions

[nikkhils]

Allow users to specify a specific column to be used as a secondary dimension using the add_dimension() API. A secondary dimension does not participate in partitioning of the data. Such a secondary dimension will be used for chunk pruning if the WHERE clause of a SQL query specifies ranges on such a column.

Disable-check: force-changelog-file

Disable-check: commit-count

[github-actions[bot]]

@pmwkaa, @akuzm: please review this pull request.

Powered by pull-review

[codecov[bot]]

Codecov Report

Merging #6021 (7f9032c) into main (44e41c1) will decrease coverage by 0.10%. The diff coverage is 51.13%.

@@            Coverage Diff             @@
##             main    #6021      +/-   ##
==========================================
- Coverage   81.38%   81.29%   -0.10%     
==========================================
  Files         243      243              
  Lines       55940    56011      +71     
  Branches    12385    12399      +14     
==========================================
+ Hits        45526    45532       +6     
- Misses       8088     8108      +20     
- Partials     2326     2371      +45     

Files Changed	Coverage Δ
src/ts_catalog/catalog.h	100.00% <ø> (ø)
src/dimension_slice.c	85.94% <27.77%> (-2.19%)	:arrow_down:
src/hypertable.c	84.62% <33.33%> (-0.13%)	:arrow_down:
src/dimension.c	89.65% <43.90%> (-2.03%)	:arrow_down:
src/chunk.c	89.81% <75.00%> (-0.04%)	:arrow_down:
src/chunk_constraint.c	91.59% <81.81%> (-0.46%)	:arrow_down:

... and 47 files with indirect coverage changes

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more

[nikkhils]

Closing this. A newer draft PR #6727 covers this same functionality now.