SQL • tiledbcloud

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