Script:
namespace <- "yournamespace"
ans <- execute_sql_query(
query="select `rows`, AVG(a) as avg_a from `tiledb://TileDB-Inc/quickstart_dense` GROUP BY `rows`",
name="rows-query",
namespace=namespace)
show(ans)
ans <- execute_sql_query(
query="select `rows`, AVG(a) as avg_a from `tiledb://TileDB-Inc/oops_a_typo` GROUP BY `rows`",
name="rows-query",
namespace=namespace)
show(ans)
Output:
avg_a rows
1 2.5000 1
2 6.5000 2
3 10.5000 3
4 14.5000 4
Error: tiledbcloud: received error response: Server returned 400 response status code.
Message: Error 1146: Table 'test.tiledb://TileDB-Inc/oops_a_typo' doesn't exist
Execution halted