Move tests for specialized data structures such as TDigest, HLL, ThetaSketches into one test class

[sajjad-moradi]

per @mayankshriv we should create one integration test for these specialized data structures such that:

1. The cluster is set up once at beginning.
2. For each of these features, we can setup the table -> run queries -> delete the table, iteratively

IT for theta sketches is already added in #5514. The other tests need to be moved to that class.