Errors and logs in colab

[domoritz]

I tried quak in colab and it works out of the box which is amazing: https://colab.research.google.com/drive/13gA8FfYbwiOIfJLAiXOtjjLHeeLybVqT?usp=sharing. Unfortunately, I see a bunch of errors and logs below the table that are not useful for users.

[manzt]

This is good to know. I forgot that Google Colab prints logging errors directly below the output.

I also can reproduce these errors on the client when trying out the wasm example with the same data (npx vite). There appear to be some SQL syntax errors generated creating a tmp index:

DataCubeIndexer.js:132 Error: Parser Error: syntax error at or near "50000000000"
LINE 1: ...82439e AS SELECT (TIME_BUCKET(INTERVAL 50000000000 year, "date_of_birth")) AS ...

DataCubeIndexer.js:132 Error: Binder Error: column "weight" must appear in the GROUP BY clause or must be part of an aggregate function.
Either add it to the GROUP BY list, or use "ANY_VALUE(weight)" if the exact value of "weight" is not important.
    at U.onMessage (async_bindings.ts:150:23)

Not sure when I'll be able to dig deeper. Maybe a quick fix would be to suppress the errors in Colab.

[domoritz]

I think showing errors is not that big of an issue. Showing all the logs is a problem for casual users.

[manzt]

ahh ok i misunderstood!

[domoritz]

Thanks or the fix. The query bugs are a separate issue imo. I added #21