We need to remove automatic table detection for scrambles and let users to specify scrambles directly if one wants to use AQP with VerdictDB. This needs to be done because:
It is currently very difficult to support automatic table detection properly for complex queries (e.g., ones with nested queries) with multiple scramble types.
It provides more freedom to users to specify which scramble to use for a given query. This is possible because we now allow users to view available scrambles (with SHOW SCRAMBLES command).
We may go back to automatic table replacement for scrambles once we figure out the proper way to do it, but until then we think we should let users to specify which scramble to use for his/her queries.
We need to remove automatic table detection for scrambles and let users to specify scrambles directly if one wants to use AQP with VerdictDB. This needs to be done because:
SHOW SCRAMBLEScommand).We may go back to automatic table replacement for scrambles once we figure out the proper way to do it, but until then we think we should let users to specify which scramble to use for his/her queries.