Accessing system tables
Options
![UserBird](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar12.png)
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hi, we are trying to do a SELECT statement on a system table from a Python recipe. We also tried it using an SQL recipe. However, we are getting the following error from Dataiku:
declare cursor statement may not reference system tables
Is there a way to work around this?
Answers
-
Hi,
Unfortunately, there isn't. You might be able to copy information from the system table to a regular table and then query the regular table.
(Note that Aster DB is not officially supported)