I’m trying to connect to my psotgresql database through dremio’s jdbc driver and sparksql. I have set up everything to what I believe is the correct configuration through spark but I keep getting the following error:
Intermediate Configuration and Plugin files, in order of precedence:
17/07/20 18:18:23 ERROR DremioJdbc41Factory: Failed to create prepared statement: VALIDATION ERROR: Table ‘schema1.table1’ not found `
A few things:
- The table is definitely there as I can see it in my dremio ui and it is accessible through there
- It seems that sparksql isn’t establishing a connection through dremio as it doesn’t matter what the database name is at the end of the jdbc url (jdbc:dremio:direct=127.0.1.1:31010:testData) as I always get the same error.
Am I doing something wrong?