You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by ignazio deiudicibus <i....@gmail.com> on 2017/04/18 17:01:06 UTC

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

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....@legalmail.it>