oracle jdbc storage, perform query to table hosted in a different schema

[ignazio deiudicibus]

Hi all,

I'm having trouble in querying tables that belongs to a schema of another
user (say user KARL).
I can query the tables of that schema like this:
select * from KARL.table1
how can I do the same in drill? Is that possible??

here's my storage configuration:
{
  "type": "jdbc",
  "driver": "oracle.jdbc.OracleDriver",
  "url": "jdbc:oracle:thin:IGNAZIO/PASSWORD@1.2.3.4:1521/SID",
  "username": null,
  "password": null,
  "enabled": true
}

thank in advance

-- 
ignazio

<i.deiudici...@legalmail.it>