Apache Drill Error

[Rajasimman Selvaraj]

Hi ,
   I am getting the following error while starting the drill in Mac OS for the 
first time.
Unable to locate an executable at 
"/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1)

I have the java JDK installed in my machine as listed below.
RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ java -version
java version "1.8.0_101"
Java(TM) SE Runtime Environment (build 1.8.0_101-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.101-b13, mixed mode)
RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ 

Please help me to get the drill start and running in my Mac OS.

Regards,
S.RajaSimman.

Re: Apache Drill Error

[Padma Penumarthy]

Trying commenting out the following line in 
distribution/target/apache-drill-1.9.0-SNAPSHOT/apache-drill-1.9.0-SNAPSHOT/bin/drill-config.sh

export JAVA_HOME

Thanks,
Padma


> On Sep 20, 2016, at 7:17 PM, Rajasimman Selvaraj  
> wrote:
> 
> Hi ,
>   I am getting the following error while starting the drill in Mac OS for the 
> first time.
> Unable to locate an executable at 
> "/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1)
> 
> I have the java JDK installed in my machine as listed below.
> RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ java -version
> java version "1.8.0_101"
> Java(TM) SE Runtime Environment (build 1.8.0_101-b13)
> Java HotSpot(TM) 64-Bit Server VM (build 25.101-b13, mixed mode)
> RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ 
> 
> Please help me to get the drill start and running in my Mac OS.
> 
> Regards,
> S.RajaSimman.

Re: Apache Drill Error

[Padma Penumarthy]

Sorry, I meant Try (not Trying)

> On Sep 21, 2016, at 10:08 AM, Padma Penumarthy  
> wrote:
> 
> Trying commenting out the following line in 
> distribution/target/apache-drill-1.9.0-SNAPSHOT/apache-drill-1.9.0-SNAPSHOT/bin/drill-config.sh
> 
> export JAVA_HOME
> 
> Thanks,
> Padma
> 
> 
>> On Sep 20, 2016, at 7:17 PM, Rajasimman Selvaraj > > wrote:
>> 
>> Hi ,
>>   I am getting the following error while starting the drill in Mac OS for 
>> the first time.
>> Unable to locate an executable at 
>> "/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1)
>> 
>> I have the java JDK installed in my machine as listed below.
>> RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ java -version
>> java version "1.8.0_101"
>> Java(TM) SE Runtime Environment (build 1.8.0_101-b13)
>> Java HotSpot(TM) 64-Bit Server VM (build 25.101-b13, mixed mode)
>> RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ 
>> 
>> Please help me to get the drill start and running in my Mac OS.
>> 
>> Regards,
>> S.RajaSimman.
> 

Re: Apache Drill Error

[Robin Moffatt]

Thanks, that fixed the problem for me on Mac with Drill 1.8. I had the same
error as OP (Unable to locate an executable at
"/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1))

$ diff drill-config.sh drill-config.sh.bak
395c395
< #export JAVA_HOME
---
> export JAVA_HOME

On 21 September 2016 at 18:08, Padma Penumarthy 
wrote:

> Trying commenting out the following line in
> distribution/target/apache-drill-1.9.0-SNAPSHOT/apache-
> drill-1.9.0-SNAPSHOT/bin/drill-config.sh
>
> export JAVA_HOME
>
> Thanks,
> Padma
>
>
> > On Sep 20, 2016, at 7:17 PM, Rajasimman Selvaraj 
> wrote:
> >
> > Hi ,
> >   I am getting the following error while starting the drill in Mac OS
> for the first time.
> > Unable to locate an executable at "/System/Library/Frameworks/
> JavaVM.framework/Versions/A/bin/java" (-1)
> >
> > I have the java JDK installed in my machine as listed below.
> > RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$ java -version
> > java version "1.8.0_101"
> > Java(TM) SE Runtime Environment (build 1.8.0_101-b13)
> > Java HotSpot(TM) 64-Bit Server VM (build 25.101-b13, mixed mode)
> > RajaSimmans-MBP:apache-drill-1.8.0 Hadoop$
> >
> > Please help me to get the drill start and running in my Mac OS.
> >
> > Regards,
> > S.RajaSimman.
>
>

Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Team,

I have configured drill on 4 node cluster and getting error while creating
storage plugin for Oracle DB.

Error : Please retry: error (unable to create/ update storage)

Oracle DB Version : *12.1.0.2.0*

Following steps followed to create storage plugin:
1. copied ojdbc7.jar to jars/3rdparty folder
2. Storage plugin configuration
{
  "type": "jdbc",
  "driver": "oracle.jdbc.driver.OracleDriver",
  "url": "jdbc:oracle:thin:<>/<>@<>:<>/ORCL",
  "enabled": true
}
3. drill-override.conf file
drill.exec: {
  cluster-id: "drillbits1",
  drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
apache-drill-1.11.0",
  zk.connect: "<>:<"
}

Thanks and Regards,
Akshay

FW: Apache Drill- Error setting up remote intermediate fragment execution

[Surneni Tilak]

Hi Team,

I have successfully launched  a Drill cluster on 3 docker containers with Zoo 
keeper  Quorum and accessing data from a remote node on which Drill is not 
installed . I am able to list all the drill bits from each node and  run  
queries on a single drill bit , But I am facing issue when I am trying to run a 
query which distributes the query to the other drill bits by creating the 
intermediate fragments.  I have gone through the documentation but It couldn't 
help. I got the below error message in Drill shell  and the detailed  error log 
mentioned below. Please help me on resolving this.

Error in Drill Shell:

Error: CONNECTION ERROR: Error setting up remote intermediate fragment execution

Nodes with failures drillslave-7dccb67657-9qv4l, drillslave-7dccb67657-rhfgt

[Error Id: 5d701a0d-988b-4845-83f6-b029ad6825a8 on 
drillmaster-76d6885c59-wpksz:31010] (state=,code=0)


Error Log:





2018-04-11 07:26:17,391 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,401 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute
d 1 out of 1 using 1 threads. Time: 2ms total, 2.798853ms avg, 2ms max.
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute
d 1 out of 1 using 1 threads. Earliest start: 0.699000 ?s, Latest start: 
0.699000 ?s, Average start: 0.699000 ?s .
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - Beginning partition pr
uning, pruning class: 
org.apache.drill.exec.planner.logical.partition.PruneScanRule$DirPruneScanFilterOnScanRule
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - No partition columns a
re projected from the scan..continue. Total pruning elapsed time: 0 ms
2018-04-11 07:26:17,611 [BitServer-3] ERROR o.a.d.e.rpc.ConnectionMultiListener 
- Failed to establish connection
java.util.concurrent.ExecutionException: 
java.nio.channels.UnresolvedAddressException
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) 
~[netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
org.apache.drill.exec.rpc.ConnectionMultiListener$ConnectionHandler.operationComplete(ConnectionMultiListener.java:89)
 [drill-
rpc-1.12.0.jar:1.12.0]
at 
org.apache.drill.exec.rpc.ConnectionMultiListener$ConnectionHandler.operationComplete(ConnectionMultiListener.java:76)
 [drill-
rpc-1.12.0.jar:1.12.0]
at 
io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:507)
 [netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:481)
 [netty-common-4.0.48.Final.jar:4.0.48.Fina
l]
at 
io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:420)
 [netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:122) 
[netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.connect(AbstractNioChannel.java:241)
 [netty-transport-4.0.48.Final.j
ar:4.0.48.Final]
at 
io.netty.channel.DefaultChannelPipeline$HeadContext.connect(DefaultChannelPipeline.java:1226)
 [netty-transport-4.0.48.Final.ja
r:4.0.48.Final]
at 
io.netty.channel.AbstractChannelHandlerContext.invokeConnect(AbstractChannelHandlerContext.java:539)
 [netty-transport-4.0.48.F
inal.jar:4.0.48.Final]
at 
io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:524)
 [netty-transport-4.0.48.Final.j
ar:4.0.48.Final]
at 
io.netty.channel.ChannelOutboundHandlerAdapter.connect(ChannelOutboundHandlerAdapter.java:47)
 [netty-transport-4.0.48.Final.ja
r:4.0.

Re: Apache Drill- Error setting up remote intermediate fragment execution

[Sorabh Hamirwasia]

Hi Surneni,

This looks to be an issue with your network setup. The address or hostname 
known to a Drillbit about another Drillbit is not resolved correctly while 
trying to make connection.


Thanks,
Sorabh



From: Surneni Tilak 
Sent: Wednesday, April 11, 2018 8:30 AM
To: user@drill.apache.org
Subject: FW: Apache Drill- Error setting up remote intermediate fragment 
execution

Hi Team,

I have successfully launched  a Drill cluster on 3 docker containers with Zoo 
keeper  Quorum and accessing data from a remote node on which Drill is not 
installed . I am able to list all the drill bits from each node and  run  
queries on a single drill bit , But I am facing issue when I am trying to run a 
query which distributes the query to the other drill bits by creating the 
intermediate fragments.  I have gone through the documentation but It couldn't 
help. I got the below error message in Drill shell  and the detailed  error log 
mentioned below. Please help me on resolving this.

Error in Drill Shell:

Error: CONNECTION ERROR: Error setting up remote intermediate fragment execution

Nodes with failures drillslave-7dccb67657-9qv4l, drillslave-7dccb67657-rhfgt

[Error Id: 5d701a0d-988b-4845-83f6-b029ad6825a8 on 
drillmaster-76d6885c59-wpksz:31010] (state=,code=0)


Error Log:





2018-04-11 07:26:17,391 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,401 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute
d 1 out of 1 using 1 threads. Time: 2ms total, 2.798853ms avg, 2ms max.
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute
d 1 out of 1 using 1 threads. Earliest start: 0.699000 ?s, Latest start: 
0.699000 ?s, Average start: 0.699000 ?s .
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - Beginning partition pr
uning, pruning class: 
org.apache.drill.exec.planner.logical.partition.PruneScanRule$DirPruneScanFilterOnScanRule
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - No partition columns a
re projected from the scan..continue. Total pruning elapsed time: 0 ms
2018-04-11 07:26:17,611 [BitServer-3] ERROR o.a.d.e.rpc.ConnectionMultiListener 
- Failed to establish connection
java.util.concurrent.ExecutionException: 
java.nio.channels.UnresolvedAddressException
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) 
~[netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
org.apache.drill.exec.rpc.ConnectionMultiListener$ConnectionHandler.operationComplete(ConnectionMultiListener.java:89)
 [drill-
rpc-1.12.0.jar:1.12.0]
at 
org.apache.drill.exec.rpc.ConnectionMultiListener$ConnectionHandler.operationComplete(ConnectionMultiListener.java:76)
 [drill-
rpc-1.12.0.jar:1.12.0]
at 
io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:507)
 [netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:481)
 [netty-common-4.0.48.Final.jar:4.0.48.Fina
l]
at 
io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:420)
 [netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:122) 
[netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.connect(AbstractNioChannel.java:241)
 [netty-transport-4.0.48.Final.j
ar:4.0.48.Final]
at 
io.netty.channel.DefaultChannelPipeline$HeadContext.connect(DefaultChannelPipeline.java:1226)
 [netty-transport-4.0.48.Final.ja
r:4.0.48.Final]
 

Re: Apache Drill- Error setting up remote intermediate fragment execution

[Sorabh Hamirwasia]

Sent too soon.


Hi Surneni,

This looks to be an issue with your network setup. The address or hostname 
known to a Drillbit about another Drillbit is not resolved correctly while 
trying to make connection.


Nodes with failure: drillslave-7dccb67657-9qv4l, drillslave-7dccb67657-rhfgt


Can you please verify if above 2 nodes can ping each other using the hostname?


If not may be you can try to update the /etc/hosts file to provide a mapping 
between hostname and corresponding IP address.


with org.apache.drill.exec.rpc.RpcException: Command failed while establishing 
connection.  Failure type CONNECTION..
2018-04-11 07:26:17,705 [BitServer-6] ERROR o.a.d.e.rpc.ConnectionMultiListener 
- Failed to establish connection
java.util.concurrent.ExecutionException: 
java.nio.channels.UnresolvedAddressException
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) 
~[netty-common-4.0.48.Final.jar:4.0.48.Final]


Thanks,
Sorabh



From: Sorabh Hamirwasia
Sent: Wednesday, April 11, 2018 9:04 AM
To: user@drill.apache.org
Subject: Re: Apache Drill- Error setting up remote intermediate fragment 
execution


Hi Surneni,

This looks to be an issue with your network setup. The address or hostname 
known to a Drillbit about another Drillbit is not resolved correctly while 
trying to make connection.


Thanks,
Sorabh



From: Surneni Tilak 
Sent: Wednesday, April 11, 2018 8:30 AM
To: user@drill.apache.org
Subject: FW: Apache Drill- Error setting up remote intermediate fragment 
execution

Hi Team,

I have successfully launched  a Drill cluster on 3 docker containers with Zoo 
keeper  Quorum and accessing data from a remote node on which Drill is not 
installed . I am able to list all the drill bits from each node and  run  
queries on a single drill bit , But I am facing issue when I am trying to run a 
query which distributes the query to the other drill bits by creating the 
intermediate fragments.  I have gone through the documentation but It couldn't 
help. I got the below error message in Drill shell  and the detailed  error log 
mentioned below. Please help me on resolving this.

Error in Drill Shell:

Error: CONNECTION ERROR: Error setting up remote intermediate fragment execution

Nodes with failures drillslave-7dccb67657-9qv4l, drillslave-7dccb67657-rhfgt

[Error Id: 5d701a0d-988b-4845-83f6-b029ad6825a8 on 
drillmaster-76d6885c59-wpksz:31010] (state=,code=0)


Error Log:





2018-04-11 07:26:17,391 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,401 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute
d 1 out of 1 using 1 threads. Time: 2ms total, 2.798853ms avg, 2ms max.
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute
d 1 out of 1 using 1 threads. Earliest start: 0.699000 ?s, Latest start: 
0.699000 ?s, Average start: 0.699000 ?s .
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - Beginning partition pr
uning, pruning class: 
org.apache.drill.exec.planner.logical.partition.PruneScanRule$DirPruneScanFilterOnScanRule
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - No partition columns a
re projected from the scan..continue. Total pruning elapsed time: 0 ms
2018-04-11 07:26:17,611 [BitServer-3] ERROR o.a.d.e.rpc.ConnectionMultiListener 
- Failed to establish connection
java.util.concurrent.ExecutionException: 
java.nio.channels.UnresolvedAddressException
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) 
~[netty-common-4.0.48.Final.jar:4.0.48.Final]
at 
org.apache.drill.exec.rpc.ConnectionMultiLis

RE: Apache Drill- Error setting up remote intermediate fragment execution

[Surneni Tilak]

Hi Sorabh,

Thanks for your quick response. It resolved my problem .

Best regards, 
_
Tilak Surneni 

-Original Message-
From: Sorabh Hamirwasia [mailto:shamirwa...@mapr.com] 
Sent: Wednesday, April 11, 2018 6:09 PM
To: user@drill.apache.org
Subject: Re: Apache Drill- Error setting up remote intermediate fragment 
execution

Sent too soon.


Hi Surneni,

This looks to be an issue with your network setup. The address or hostname 
known to a Drillbit about another Drillbit is not resolved correctly while 
trying to make connection.


Nodes with failure: drillslave-7dccb67657-9qv4l, drillslave-7dccb67657-rhfgt


Can you please verify if above 2 nodes can ping each other using the hostname?


If not may be you can try to update the /etc/hosts file to provide a mapping 
between hostname and corresponding IP address.


with org.apache.drill.exec.rpc.RpcException: Command failed while establishing 
connection.  Failure type CONNECTION..
2018-04-11 07:26:17,705 [BitServer-6] ERROR o.a.d.e.rpc.ConnectionMultiListener 
- Failed to establish connection
java.util.concurrent.ExecutionException: 
java.nio.channels.UnresolvedAddressException
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) 
~[netty-common-4.0.48.Final.jar:4.0.48.Final]


Thanks,
Sorabh



From: Sorabh Hamirwasia
Sent: Wednesday, April 11, 2018 9:04 AM
To: user@drill.apache.org
Subject: Re: Apache Drill- Error setting up remote intermediate fragment 
execution


Hi Surneni,

This looks to be an issue with your network setup. The address or hostname 
known to a Drillbit about another Drillbit is not resolved correctly while 
trying to make connection.


Thanks,
Sorabh



From: Surneni Tilak 
Sent: Wednesday, April 11, 2018 8:30 AM
To: user@drill.apache.org
Subject: FW: Apache Drill- Error setting up remote intermediate fragment 
execution

Hi Team,

I have successfully launched  a Drill cluster on 3 docker containers with Zoo 
keeper  Quorum and accessing data from a remote node on which Drill is not 
installed . I am able to list all the drill bits from each node and  run  
queries on a single drill bit , But I am facing issue when I am trying to run a 
query which distributes the query to the other drill bits by creating the 
intermediate fragments.  I have gone through the documentation but It couldn't 
help. I got the below error message in Drill shell  and the detailed  error log 
mentioned below. Please help me on resolving this.

Error in Drill Shell:

Error: CONNECTION ERROR: Error setting up remote intermediate fragment execution

Nodes with failures drillslave-7dccb67657-9qv4l, drillslave-7dccb67657-rhfgt

[Error Id: 5d701a0d-988b-4845-83f6-b029ad6825a8 on 
drillmaster-76d6885c59-wpksz:31010] (state=,code=0)


Error Log:





2018-04-11 07:26:17,391 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,392 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,401 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.exec.store.dfs.FileSelection - FileSelection.getStatus
es() took 0 ms, numFiles: 1
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute d 1 out of 1 using 
1 threads. Time: 2ms total, 2.798853ms avg, 2ms max.
2018-04-11 07:26:17,404 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Execute d 1 out of 1 using 
1 threads. Earliest start: 0.699000 ?s, Latest start: 0.699000 ?s, Average 
start: 0.699000 ?s .
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - Beginning partition pr uning, pruning 
class: 
org.apache.drill.exec.planner.logical.partition.PruneScanRule$DirPruneScanFilterOnScanRule
2018-04-11 07:26:17,408 [25324766-53a8-f988-20b4-65bbe0aa6cf9:foreman] INFO  
o.a.d.e.p.l.partition.PruneScanRule - No partition columns a re projected from 
the scan..continue. Total pruning elapsed time: 0 ms
2018-04-11 07:26:17,611 [BitS

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Arjun kr]

Hi Akshay,


Did you copy jdbc driver to all the drill nodes and restarted drillbits ?


Thanks,


Arjun



From: Akshay Joshi 
Sent: Tuesday, October 31, 2017 9:46 PM
To: user@drill.apache.org
Subject: Apache drill : Error while creating storage plugin for Oracle DB

Hi Team,

I have configured drill on 4 node cluster and getting error while creating
storage plugin for Oracle DB.

Error : Please retry: error (unable to create/ update storage)

Oracle DB Version : *12.1.0.2.0*

Following steps followed to create storage plugin:
1. copied ojdbc7.jar to jars/3rdparty folder
2. Storage plugin configuration
{
  "type": "jdbc",
  "driver": "oracle.jdbc.driver.OracleDriver",
  "url": "jdbc:oracle:thin:<>/<>@<>:<>/ORCL",
  "enabled": true
}
3. drill-override.conf file
drill.exec: {
  cluster-id: "drillbits1",
  drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
apache-drill-1.11.0",
  zk.connect: "<>:<"
}

Thanks and Regards,
Akshay

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Arjun,

Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and restarted
the drillbits on all nodes.

Thanks and Regards,
Akshay
On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:

> Hi Akshay,
>
>
> Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
>
>
> Thanks,
>
>
> Arjun
>
>
> 
> From: Akshay Joshi 
> Sent: Tuesday, October 31, 2017 9:46 PM
> To: user@drill.apache.org
> Subject: Apache drill : Error while creating storage plugin for Oracle DB
>
> Hi Team,
>
> I have configured drill on 4 node cluster and getting error while creating
> storage plugin for Oracle DB.
>
> Error : Please retry: error (unable to create/ update storage)
>
> Oracle DB Version : *12.1.0.2.0*
>
> Following steps followed to create storage plugin:
> 1. copied ojdbc7.jar to jars/3rdparty folder
> 2. Storage plugin configuration
> {
>   "type": "jdbc",
>   "driver": "oracle.jdbc.driver.OracleDriver",
>   "url": "jdbc:oracle:thin:<>/<>@<>:<>/ORCL",
>   "enabled": true
> }
> 3. drill-override.conf file
> drill.exec: {
>   cluster-id: "drillbits1",
>   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> apache-drill-1.11.0",
>   zk.connect: "<>:<"
> }
>
> Thanks and Regards,
> Akshay
>

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Arjun kr]

Do you see any specific error message in drillbit.log ?

Thanks,

Arjun


From: Akshay Joshi 
Sent: Tuesday, October 31, 2017 11:10 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Arjun,

Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and restarted
the drillbits on all nodes.

Thanks and Regards,
Akshay
On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:

> Hi Akshay,
>
>
> Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
>
>
> Thanks,
>
>
> Arjun
>
>
> 
> From: Akshay Joshi 
> Sent: Tuesday, October 31, 2017 9:46 PM
> To: user@drill.apache.org
> Subject: Apache drill : Error while creating storage plugin for Oracle DB
>
> Hi Team,
>
> I have configured drill on 4 node cluster and getting error while creating
> storage plugin for Oracle DB.
>
> Error : Please retry: error (unable to create/ update storage)
>
> Oracle DB Version : *12.1.0.2.0*
>
> Following steps followed to create storage plugin:
> 1. copied ojdbc7.jar to jars/3rdparty folder
> 2. Storage plugin configuration
> {
>   "type": "jdbc",
>   "driver": "oracle.jdbc.driver.OracleDriver",
>   "url": "jdbc:oracle:thin:<>/<>@<>:<>/ORCL",
>   "enabled": true
> }
> 3. drill-override.conf file
> drill.exec: {
>   cluster-id: "drillbits1",
>   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> apache-drill-1.11.0",
>   zk.connect: "<>:<"
> }
>
> Thanks and Regards,
> Akshay
>

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Arjun,

No error message getting logged in drillbit.log once I click on "create"
button.

Thanks,
Akshay

On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:

>
> Do you see any specific error message in drillbit.log ?
>
> Thanks,
>
> Arjun
>
> 
> From: Akshay Joshi 
> Sent: Tuesday, October 31, 2017 11:10 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Arjun,
>
> Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and restarted
> the drillbits on all nodes.
>
> Thanks and Regards,
> Akshay
> On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:
>
> > Hi Akshay,
> >
> >
> > Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
> >
> >
> > Thanks,
> >
> >
> > Arjun
> >
> >
> > ____
> > From: Akshay Joshi 
> > Sent: Tuesday, October 31, 2017 9:46 PM
> > To: user@drill.apache.org
> > Subject: Apache drill : Error while creating storage plugin for Oracle DB
> >
> > Hi Team,
> >
> > I have configured drill on 4 node cluster and getting error while
> creating
> > storage plugin for Oracle DB.
> >
> > Error : Please retry: error (unable to create/ update storage)
> >
> > Oracle DB Version : *12.1.0.2.0*
> >
> > Following steps followed to create storage plugin:
> > 1. copied ojdbc7.jar to jars/3rdparty folder
> > 2. Storage plugin configuration
> > {
> >   "type": "jdbc",
> >   "driver": "oracle.jdbc.driver.OracleDriver",
> >   "url": "jdbc:oracle:thin:<>/<>@<>:<>/
> ORCL",
> >   "enabled": true
> > }
> > 3. drill-override.conf file
> > drill.exec: {
> >   cluster-id: "drillbits1",
> >   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> > apache-drill-1.11.0",
> >   zk.connect: "<>:<"
> > }
> >
> > Thanks and Regards,
> > Akshay
> >
>

RE: Apache drill : Error while creating storage plugin for Oracle DB

[Kunal Khatua]

There are other logs that might be reporting the error. 

Look at the other logs in the Drill UI ... one of them that can carry more 
information would be drillbit.out 

-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com] 
Sent: Tuesday, October 31, 2017 11:06 AM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Arjun,

No error message getting logged in drillbit.log once I click on "create"
button.

Thanks,
Akshay

On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:

>
> Do you see any specific error message in drillbit.log ?
>
> Thanks,
>
> Arjun
>
> 
> From: Akshay Joshi 
> Sent: Tuesday, October 31, 2017 11:10 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for 
> Oracle DB
>
> Hi Arjun,
>
> Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and 
> restarted the drillbits on all nodes.
>
> Thanks and Regards,
> Akshay
> On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:
>
> > Hi Akshay,
> >
> >
> > Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
> >
> >
> > Thanks,
> >
> >
> > Arjun
> >
> >
> > ____
> > From: Akshay Joshi 
> > Sent: Tuesday, October 31, 2017 9:46 PM
> > To: user@drill.apache.org
> > Subject: Apache drill : Error while creating storage plugin for 
> > Oracle DB
> >
> > Hi Team,
> >
> > I have configured drill on 4 node cluster and getting error while
> creating
> > storage plugin for Oracle DB.
> >
> > Error : Please retry: error (unable to create/ update storage)
> >
> > Oracle DB Version : *12.1.0.2.0*
> >
> > Following steps followed to create storage plugin:
> > 1. copied ojdbc7.jar to jars/3rdparty folder 2. Storage plugin 
> > configuration {
> >   "type": "jdbc",
> >   "driver": "oracle.jdbc.driver.OracleDriver",
> >   "url": 
> > "jdbc:oracle:thin:<>/<>@<>:<>/
> ORCL",
> >   "enabled": true
> > }
> > 3. drill-override.conf file
> > drill.exec: {
> >   cluster-id: "drillbits1",
> >   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> > apache-drill-1.11.0",
> >   zk.connect: "<>:<"
> > }
> >
> > Thanks and Regards,
> > Akshay
> >
>

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Arjun kr]

Can you try with CURL as well ?

curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1", 
"config": {"type": "jdbc", "enabled": true,"driver": 
"oracle.jdbc.driver.OracleDriver", 
"url":"jdbc:oracle:thin:/@:/" }}' 
http://< drill_server>:8047/storage/oracle1.json

Please refer to this blog for curl command if you have HTTPS enabled.

http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.html

Also assume that you are able to connect with this connection URL using any 
other jdbc application.

Thanks,

Arjun
____________
From: Kunal Khatua 
Sent: Tuesday, October 31, 2017 11:57 PM
To: user@drill.apache.org
Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB

There are other logs that might be reporting the error.

Look at the other logs in the Drill UI ... one of them that can carry more 
information would be drillbit.out

-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
Sent: Tuesday, October 31, 2017 11:06 AM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Arjun,

No error message getting logged in drillbit.log once I click on "create"
button.

Thanks,
Akshay

On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:

>
> Do you see any specific error message in drillbit.log ?
>
> Thanks,
>
> Arjun
>
> ____
> From: Akshay Joshi 
> Sent: Tuesday, October 31, 2017 11:10 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for
> Oracle DB
>
> Hi Arjun,
>
> Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and
> restarted the drillbits on all nodes.
>
> Thanks and Regards,
> Akshay
> On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:
>
> > Hi Akshay,
> >
> >
> > Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
> >
> >
> > Thanks,
> >
> >
> > Arjun
> >
> >
> > 
> > From: Akshay Joshi 
> > Sent: Tuesday, October 31, 2017 9:46 PM
> > To: user@drill.apache.org
> > Subject: Apache drill : Error while creating storage plugin for
> > Oracle DB
> >
> > Hi Team,
> >
> > I have configured drill on 4 node cluster and getting error while
> creating
> > storage plugin for Oracle DB.
> >
> > Error : Please retry: error (unable to create/ update storage)
> >
> > Oracle DB Version : *12.1.0.2.0*
> >
> > Following steps followed to create storage plugin:
> > 1. copied ojdbc7.jar to jars/3rdparty folder 2. Storage plugin
> > configuration {
> >   "type": "jdbc",
> >   "driver": "oracle.jdbc.driver.OracleDriver",
> >   "url":
> > "jdbc:oracle:thin:<>/<>@<>:<>/
> ORCL",
> >   "enabled": true
> > }
> > 3. drill-override.conf file
> > drill.exec: {
> >   cluster-id: "drillbits1",
> >   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> > apache-drill-1.11.0",
> >   zk.connect: "<>:<"
> > }
> >
> > Thanks and Regards,
> > Akshay
> >
>

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Arjun/Kunal,

Error message is not getting logged in drillbit.out  as well once "create"
button is clicked. None of the log files is getting updated in drill UI.

Tried with curl command and getting the same error *(unable to create/
update storage) *without much stacktrace about error. PFB more details
about curl command and o/p. HTTPS is not enabled.
Just to add I am able to connect my oracle DB using sqldeveloper client.

*COMMAND*
curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
"config": {"type": "jdbc", "enabled": true,"driver":
"oracle.dbc.driver.OracleDriver",
"url":"jdbc:oracle:thin:/@:/"
}}' http://<>:8047/storage/query.json

*CURL O/P*
* About to connect() to <> port 8047 (#0)
*   Trying <>... connected
* Connected to <> (<>) port 8047 (#0)
> POST /storage/query.json HTTP/1.1
> User-Agent: curl/7.19.7 <>
> Host: <>:8047
> Accept: */*
> Content-Type: application/json
> Content-Length: 179
>
< HTTP/1.1 200 OK
< Content-Type: application/json
< Content-Length: 59
< Server: Jetty(9.1.5.v20140505)
<
{
  "result" : "error (unable to create/ update storage)"
* Connection #0 to host <> left intact
* Closing connection #0
}

Kindly let me know if any other thoughts.

Thanks,
Akshay


On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:

>
> Can you try with CURL as well ?
>
> curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": 
> "oracle.jdbc.driver.OracleDriver",
> "url":"jdbc:oracle:thin:/@ server>:/" }}' http://<
> drill_server>:8047/storage/oracle1.json
>
> Please refer to this blog for curl command if you have HTTPS enabled.
>
> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.html
>
> Also assume that you are able to connect with this connection URL using
> any other jdbc application.
>
> Thanks,
>
> Arjun
> 
> From: Kunal Khatua 
> Sent: Tuesday, October 31, 2017 11:57 PM
> To: user@drill.apache.org
> Subject: RE: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> There are other logs that might be reporting the error.
>
> Look at the other logs in the Drill UI ... one of them that can carry more
> information would be drillbit.out
>
> -Original Message-
> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
> Sent: Tuesday, October 31, 2017 11:06 AM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Arjun,
>
> No error message getting logged in drillbit.log once I click on "create"
> button.
>
> Thanks,
> Akshay
>
> On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:
>
> >
> > Do you see any specific error message in drillbit.log ?
> >
> > Thanks,
> >
> > Arjun
> >
> > 
> > From: Akshay Joshi 
> > Sent: Tuesday, October 31, 2017 11:10 PM
> > To: user@drill.apache.org
> > Subject: Re: Apache drill : Error while creating storage plugin for
> > Oracle DB
> >
> > Hi Arjun,
> >
> > Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and
> > restarted the drillbits on all nodes.
> >
> > Thanks and Regards,
> > Akshay
> > On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:
> >
> > > Hi Akshay,
> > >
> > >
> > > Did you copy jdbc driver to all the drill nodes and restarted
> drillbits ?
> > >
> > >
> > > Thanks,
> > >
> > >
> > > Arjun
> > >
> > >
> > > 
> > > From: Akshay Joshi 
> > > Sent: Tuesday, October 31, 2017 9:46 PM
> > > To: user@drill.apache.org
> > > Subject: Apache drill : Error while creating storage plugin for
> > > Oracle DB
> > >
> > > Hi Team,
> > >
> > > I have configured drill on 4 node cluster and getting error while
> > creating
> > > storage plugin for Oracle DB.
> > >
> > > Error : Please retry: error (unable to create/ update storage)
> > >
> > > Oracle DB Version : *12.1.0.2.0*
> > >
> > > Following steps followed to create storage plugin:
> > > 1. copied ojdbc7.jar to jars/3rdparty folder 2. Storage plugin
> > > configuration {
> > >   "type": "jdbc",
> > >   "driver": "oracle.jdbc.driver.OracleDriver",
> > >   "url":
> > > "jdbc:oracle:thin:<>/<>@<>:<>/
> > ORCL",
> > >   "enabled": true
> > > }
> > > 3. drill-override.conf file
> > > drill.exec: {
> > >   cluster-id: "drillbits1",
> > >   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> > > apache-drill-1.11.0",
> > >   zk.connect: "<>:<"
> > > }
> > >
> > > Thanks and Regards,
> > > Akshay
> > >
> >
>

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Arjun/Kunal,

Just to add to my previous mail I am using *Apache Drill version 1.11.0.*

Thanks,
Akshay

On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi 
wrote:

> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out  as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:/@ server>:/" }}' http://<>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <> port 8047 (#0)
> *   Trying <>... connected
> * Connected to <> (<>) port 8047 (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <>
> > Host: <>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
>   "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver", 
>> "url":"jdbc:oracle:thin:/@> server>:/" }}' http://<
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.html
>>
>> Also assume that you are able to connect with this connection URL using
>> any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> 
>> From: Kunal Khatua 
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -Original Message-
>> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> Hi Arjun,
>>
>> No error message getting logged in drillbit.log once I click on "create"
>> button.
>>
>> Thanks,
>> Akshay
>>
>> On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > 
>> > From: Akshay Joshi 
>> > Sent: Tuesday, October 31, 2017 11:10 PM
>> > To: user@drill.apache.org
>> > Subject: Re: Apache drill : Error while creating storage plugin for
>> > Oracle DB
>> >
>> > Hi Arjun,
>> >
>> > Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and
>> > restarted the drillbits on all nodes.
>> >
>> > Thanks and Regards,
>> > Akshay
>> > On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:
>> >
>> > > Hi Akshay,
>> > >
>> > >
>> > > Did you copy jdbc driver to all the drill nodes and restarted
>> drillbits ?
>> > >
>> > >
>> > > Thanks,
>> > >
>> > >
>> > > Arjun
>> > >
>> > >
>> > > 
>> > > From: Akshay Joshi 
>> > > Sent: Tuesday, October 31, 2017 9:46 PM
>> > > To: user@drill.apache.org
>> > > Subject: Apache drill : Error while creating storage plugin for
>> > > Oracle DB
>> > >
>> > > Hi Team,
>> > >
>> > > I have configured drill on 4 node cluster and getting error while
>> > creating
>> > > storage plugin for Oracle DB.
>> > >
>> > > Error : Please retry: error (unable to create/ update storage)
>> > >
>> > > Oracle DB Version : *12.1.0.2.0*
>> > >
>> > > Following steps followed to create storage plugin:
>> > > 1. copied ojdbc7.jar to jars/3rdparty folder 2. Storage plugin
>> > > configuration {
>> > >   "type": "jdbc",
>> > >   "driver": "oracle.jdbc.driver.OracleDriver",
>> > >   "url":
>> > > "jdbc:oracle:thin:<>/<>@<>:<>/
>> > ORCL",
>> > >   "enabled": true
>> > > }
>> > > 3. drill-override.conf file
>> > > drill.exec: {
>> > >   cluster-id: "drillbits1",
>> > >   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
>> > > apache-drill-1.11.0",
>> > >   zk.connect: "<>:<"
>> > > }
>> > >
>> > > Thanks and Regards,
>> > > Akshay
>> > >
>> >
>>
>
>

RE: Apache drill : Error while creating storage plugin for Oracle DB

[Kunal Khatua]

Could you file a JIRA for this? I see the potential sources where the bug 
originated and there doesn’t seem to be sufficient logging, so it gets hard to 
narrow it down. 

-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com] 
Sent: Tuesday, October 31, 2017 10:04 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Arjun/Kunal,

Just to add to my previous mail I am using *Apache Drill version 1.11.0.*

Thanks,
Akshay

On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi 
wrote:

> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out  as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/ 
> update storage) *without much stacktrace about error. PFB more details 
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d 
> '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:/@ server>:/" }}' http://<>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <> port 8047 (#0)
> *   Trying <>... connected
> * Connected to <> (<>) port 8047 
> (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <>
> > Host: <>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
>   "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d 
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver", 
>> "url":"jdbc:oracle:thin:/@> server>:/" }}' http://<
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
>> html
>>
>> Also assume that you are able to connect with this connection URL 
>> using any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> 
>> From: Kunal Khatua 
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for 
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry 
>> more information would be drillbit.out
>>
>> -Original Message-
>> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for 
>> Oracle DB
>>
>> Hi Arjun,
>>
>> No error message getting logged in drillbit.log once I click on "create"
>> button.
>>
>> Thanks,
>> Akshay
>>
>> On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > 
>> > From: Akshay Joshi 
>> > Sent: Tuesday, October 31, 2017 11:10 PM
>> > To: user@drill.apache.org
>> > Subject: Re: Apache drill : Error while creating storage plugin for 
>> > Oracle DB
>> >
>> > Hi Arjun,
>> >
>> > Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and 
>> > restarted the drillbits on all nodes.
>> >
>> > Thanks and Regards,
>> > Akshay
>> > On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr  wrote:
>>

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Arjun kr]

Hi Akshay,


Just wondering if the issue is only with Oracle storage plugin. Are you able to 
create storage plugin other than oracle , say dfs or cp ?


Thanks,


Arjun


From: Kunal Khatua 
Sent: Wednesday, November 1, 2017 11:12 AM
To: user@drill.apache.org
Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB

Could you file a JIRA for this? I see the potential sources where the bug 
originated and there doesn’t seem to be sufficient logging, so it gets hard to 
narrow it down.

-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
Sent: Tuesday, October 31, 2017 10:04 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Arjun/Kunal,

Just to add to my previous mail I am using *Apache Drill version 1.11.0.*

Thanks,
Akshay

On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi 
wrote:

> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out  as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d
> '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:/@ server>:/" }}' http://<>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <> port 8047 (#0)
> *   Trying <>... connected
> * Connected to <> (<>) port 8047
> (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <>
> > Host: <>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
>   "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver",
>> "url":"jdbc:oracle:thin:/@> server>:/" }}' http://<
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
>> html
>>
>> Also assume that you are able to connect with this connection URL
>> using any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> 
>> From: Kunal Khatua 
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -Original Message-
>> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> Hi Arjun,
>>
>> No error message getting logged in drillbit.log once I click on "create"
>> button.
>>
>> Thanks,
>> Akshay
>>
>> On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr  wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > 
>> > From: Akshay Joshi 
>> > Sent: Tuesday, October 31, 2017 11:10 PM
>> > To: user@drill.apache.org
>> > Subject: Re: Apache drill : Error while creati

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Arjun/Kunal,

Yes I am able to create storage plugins other than oracle.
I have created plugin for Alluxio. dfs and cp were default plugins.
As well I am able to trigger queries using these plugins.

Thanks,
Akshay

On Wed, 1 Nov 2017 at 11:20 AM, Arjun kr  wrote:

> Hi Akshay,
>
>
> Just wondering if the issue is only with Oracle storage plugin. Are you
> able to create storage plugin other than oracle , say dfs or cp ?
>
>
> Thanks,
>
>
> Arjun
>
> 
> From: Kunal Khatua 
> Sent: Wednesday, November 1, 2017 11:12 AM
> To: user@drill.apache.org
> Subject: RE: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Could you file a JIRA for this? I see the potential sources where the bug
> originated and there doesn’t seem to be sufficient logging, so it gets hard
> to narrow it down.
>
> -Original Message-
> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
> Sent: Tuesday, October 31, 2017 10:04 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Arjun/Kunal,
>
> Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
>
> Thanks,
> Akshay
>
> On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi 
> wrote:
>
> > Hi Arjun/Kunal,
> >
> > Error message is not getting logged in drillbit.out  as well once
> "create"
> > button is clicked. None of the log files is getting updated in drill UI.
> >
> > Tried with curl command and getting the same error *(unable to create/
> > update storage) *without much stacktrace about error. PFB more details
> > about curl command and o/p. HTTPS is not enabled.
> > Just to add I am able to connect my oracle DB using sqldeveloper client.
> >
> > *COMMAND*
> > curl -v -X POST -H "Content-Type: application/json" -d
> > '{"name":"oracle1",
> > "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> > OracleDriver",
> > "url":"jdbc:oracle:thin:/@ > server>:/" }}' http://<>:
> > 8047/storage/query.json
> >
> > *CURL O/P*
> > * About to connect() to <> port 8047 (#0)
> > *   Trying <>... connected
> > * Connected to <> (<>) port 8047
> > (#0)
> > > POST /storage/query.json HTTP/1.1
> > > User-Agent: curl/7.19.7 <>
> > > Host: <>:8047
> > > Accept: */*
> > > Content-Type: application/json
> > > Content-Length: 179
> > >
> > < HTTP/1.1 200 OK
> > < Content-Type: application/json
> > < Content-Length: 59
> > < Server: Jetty(9.1.5.v20140505)
> > <
> > {
> >   "result" : "error (unable to create/ update storage)"
> > * Connection #0 to host <> left intact
> > * Closing connection #0
> > }
> >
> > Kindly let me know if any other thoughts.
> >
> > Thanks,
> > Akshay
> >
> >
> > On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:
> >
> >>
> >> Can you try with CURL as well ?
> >>
> >> curl -v -X POST -H "Content-Type: application/json" -d
> >> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
> >> "oracle.jdbc.driver.OracleDriver",
> >> "url":"jdbc:oracle:thin:/@ >> server>:/" }}' http://<
> >> drill_server>:8047/storage/oracle1.json
> >>
> >> Please refer to this blog for curl command if you have HTTPS enabled.
> >>
> >> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
> >> html
> >>
> >> Also assume that you are able to connect with this connection URL
> >> using any other jdbc application.
> >>
> >> Thanks,
> >>
> >> Arjun
> >> 
> >> From: Kunal Khatua 
> >> Sent: Tuesday, October 31, 2017 11:57 PM
> >> To: user@drill.apache.org
> >> Subject: RE: Apache drill : Error while creating storage plugin for
> >> Oracle DB
> >>
> >> There are other logs that might be reporting the error.
> >>
> >> Look at the other logs in the Drill UI ... one of them that can carry
> >> more information would be drillbit.out
> >>
> >> -Original Message-
> >> From: Akshay Joshi [mailto:joshiakshay0

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Arjun kr]

Noticed that you are specifying property 
'drill.exec.sys.store.provider.local.path' inside 'drill.exec' section. Can you 
try correcting it ? if it does not work , Please create JIRA with details as 
Kunal suggested.

Shared entry :

3. drill-override.conf file
drill.exec: {
  cluster-id: "drillbits1",
  drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
apache-drill-1.11.0",
  zk.connect: "<>:<"
}

Correct it as given below.

drill.exec: {
  cluster-id: "drillbits1",
  sys.store.provider.local.path="/u01/bdcsce/drill/
apache-drill-1.11.0",
  zk.connect: "<>:<"
}

Thanks,

Arjun


From: Arjun kr 
Sent: Wednesday, November 1, 2017 11:20 AM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Akshay,


Just wondering if the issue is only with Oracle storage plugin. Are you able to 
create storage plugin other than oracle , say dfs or cp ?


Thanks,


Arjun


From: Kunal Khatua 
Sent: Wednesday, November 1, 2017 11:12 AM
To: user@drill.apache.org
Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB

Could you file a JIRA for this? I see the potential sources where the bug 
originated and there doesn’t seem to be sufficient logging, so it gets hard to 
narrow it down.

-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
Sent: Tuesday, October 31, 2017 10:04 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB

Hi Arjun/Kunal,

Just to add to my previous mail I am using *Apache Drill version 1.11.0.*

Thanks,
Akshay

On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi 
wrote:

> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out  as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d
> '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:/@ server>:/" }}' http://<>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <> port 8047 (#0)
> *   Trying <>... connected
> * Connected to <> (<>) port 8047
> (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <>
> > Host: <>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
>   "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver",
>> "url":"jdbc:oracle:thin:/@> server>:/" }}' http://<
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
>> html
>>
>> Also assume that you are able to connect with this connection URL
>> using any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> 
>> From: Kunal Khatua 
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -Original Message-
>> From: Akshay Joshi [mailto

Re: Apache drill : Error while creating storage plugin for Oracle DB

[Akshay Joshi]

Hi Arjun,

I tried this and still getting the same error.

Thanks,
Akshay
On Wed, 1 Nov 2017 at 12:30 PM, Arjun kr  wrote:

>
> Noticed that you are specifying property
> 'drill.exec.sys.store.provider.local.path' inside 'drill.exec' section. Can
> you try correcting it ? if it does not work , Please create JIRA with
> details as Kunal suggested.
>
> Shared entry :
>
> 3. drill-override.conf file
> drill.exec: {
>   cluster-id: "drillbits1",
>   drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> apache-drill-1.11.0",
>   zk.connect: "<>:<"
> }
>
> Correct it as given below.
>
> drill.exec: {
>   cluster-id: "drillbits1",
>   sys.store.provider.local.path="/u01/bdcsce/drill/
> apache-drill-1.11.0",
>   zk.connect: "<>:<"
> }
>
> Thanks,
>
> Arjun
>
> 
> From: Arjun kr 
> Sent: Wednesday, November 1, 2017 11:20 AM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Akshay,
>
>
> Just wondering if the issue is only with Oracle storage plugin. Are you
> able to create storage plugin other than oracle , say dfs or cp ?
>
>
> Thanks,
>
>
> Arjun
>
> 
> From: Kunal Khatua 
> Sent: Wednesday, November 1, 2017 11:12 AM
> To: user@drill.apache.org
> Subject: RE: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Could you file a JIRA for this? I see the potential sources where the bug
> originated and there doesn’t seem to be sufficient logging, so it gets hard
> to narrow it down.
>
> -Original Message-
> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
> Sent: Tuesday, October 31, 2017 10:04 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Arjun/Kunal,
>
> Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
>
> Thanks,
> Akshay
>
> On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi 
> wrote:
>
> > Hi Arjun/Kunal,
> >
> > Error message is not getting logged in drillbit.out  as well once
> "create"
> > button is clicked. None of the log files is getting updated in drill UI.
> >
> > Tried with curl command and getting the same error *(unable to create/
> > update storage) *without much stacktrace about error. PFB more details
> > about curl command and o/p. HTTPS is not enabled.
> > Just to add I am able to connect my oracle DB using sqldeveloper client.
> >
> > *COMMAND*
> > curl -v -X POST -H "Content-Type: application/json" -d
> > '{"name":"oracle1",
> > "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> > OracleDriver",
> > "url":"jdbc:oracle:thin:/@ > server>:/" }}' http://<>:
> > 8047/storage/query.json
> >
> > *CURL O/P*
> > * About to connect() to <> port 8047 (#0)
> > *   Trying <>... connected
> > * Connected to <> (<>) port 8047
> > (#0)
> > > POST /storage/query.json HTTP/1.1
> > > User-Agent: curl/7.19.7 <>
> > > Host: <>:8047
> > > Accept: */*
> > > Content-Type: application/json
> > > Content-Length: 179
> > >
> > < HTTP/1.1 200 OK
> > < Content-Type: application/json
> > < Content-Length: 59
> > < Server: Jetty(9.1.5.v20140505)
> > <
> > {
> >   "result" : "error (unable to create/ update storage)"
> > * Connection #0 to host <> left intact
> > * Closing connection #0
> > }
> >
> > Kindly let me know if any other thoughts.
> >
> > Thanks,
> > Akshay
> >
> >
> > On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr  wrote:
> >
> >>
> >> Can you try with CURL as well ?
> >>
> >> curl -v -X POST -H "Content-Type: application/json" -d
> >> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
> >> "oracle.jdbc.driver.OracleDriver",
> >> "url":"jdbc:oracle:thin:/@ >> server>:/" }}' http://<
> >> drill_server>:8047/storage/oracle1.json
> >>
> >> Please refer to this blog for curl command if you have HTTPS enabled.
> >>
> >> http://ww