Discover fasterA database for data scientists

Context ctx;
Array array(ctx, "s3://tiledb-test/2d-sparse", TILEDB_READ);
std::vector data(16);
std::vector coords(32);
Query query(ctx, array, TILEDB_READ);
query.set_subarray({1, 4, 1, 4})
     .set_layout(TILEDB_ROW_MAJOR)
     .set_buffer("a", data)
     .set_coordinates(coords);
query.submit();
array.close();
Context ctx = new Context();
Array array = new Array(ctx, "s3://tiledb-test/2d-sparse");
Query query = new Query(array, TILEDB_READ);
query.setSubarray(new NativeArray(ctx, new long[] {1l, 4l, 1l, 4l}, Long.class));
query.setBuffer("a1", new NativeArray(ctx, 16, Integer.class));
query.setCoordinates(new NativeArray(ctx, 32, Long.class));
query.submit();
int[] a1_buff = (int[]) query.getBuffer("a1");
long[] coords = (long[]) query.getBuffer(TILEDB_COORDS);
SELECT AVG(attribute)
FROM `s3://tiledb-test/2d-sparse`;

SELECT dim1, dim2, AVG(attribute1)
OVER (PARTITION BY dim2)
FROM `s3://tiledb-test/2d-sparse`;
>>> import tiledb
>>> array = tiledb.open("s3://tiledb-test/test-array-100x100x30")
>>> array.shape
(100, 100, 30)

>>> array.dtype
dtype("float64")

>>> np.mean(array[:,:,1:10])
0.49943713803540135