You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by monish kaul <ka...@gmail.com> on 2015/02/24 11:51:26 UTC
Rest support to data-source addition
Hi,
I have installed a 4 node drill cluster which is up and running(on EC2).
But, in order to add cassandra as a data source I need to access drill UI.
As per what i checked I am unable to access drill UI from public ip but a
curl on local machine works just fine - I believe this is due to binding
issue with the inbuilt jetty server which drill is using.
Any roundabout for the same ? Can I somehow add a data source using rest
service ?
Regards,
Monish
Re: Rest support to data-source addition
Posted by Yash Sharma <ya...@gmail.com>.
Hi Monish,
Hanifi has already pointed out the solution.
Just to add on -
A Cassandra config would be like -
{
"type": "cassandra",
"host": "localhost",
"port": 9042,
"enabled": true
}
Make sure that Cassandra is up on port 9042 of the box. Replace the
localhost with the host IP otherwise.
A curl request (assuming drill and cassandra both on localhost) would be
like -
curl -X POST -H “Content-Type: application/json” -d ‘{ “name”:cassandra,
“config”:{“type”: “cassandra”, “host”: “localhost”, “port”: 9042,
“enabled”: true}}’ http://localhost:8047/storage/cassandra.json
In case you find that your plugin is still not enabled, you can do that
manually by -
curl -X GET http://localhost:8047/storage/cassandra/enable/true
Hope its helpful.
Thanks
On Wed, Feb 25, 2015 at 4:57 AM, Hanifi Gunes <hg...@maprtech.com> wrote:
> +drill-user
>
> Monish,
>
> Try the following and make sure to enable the plugin. Note that I just made
> up the contents of config.
>
> POST /storage/{name}.json
> Example: POST /storage/cassandra.json
> Request body:
> {
> "name" : "cssndr",
> "config" : {
> "type" : "cassandra",
> *"enabled" : true,*
> "connection" : "cassandra:///"
> }
> }
>
> Response body:
> {
> "result" : "success"
> }
>
> Regards.
> -Hanifi
>
> On Tue, Feb 24, 2015 at 2:51 AM, monish kaul <ka...@gmail.com> wrote:
>
> > Hi,
> >
> > I have installed a 4 node drill cluster which is up and running(on EC2).
> > But, in order to add cassandra as a data source I need to access drill
> UI.
> > As per what i checked I am unable to access drill UI from public ip but a
> > curl on local machine works just fine - I believe this is due to binding
> > issue with the inbuilt jetty server which drill is using.
> > Any roundabout for the same ? Can I somehow add a data source using rest
> > service ?
> >
> > Regards,
> > Monish
> >
>
Re: Rest support to data-source addition
Posted by Yash Sharma <ya...@gmail.com>.
Hi Monish,
Hanifi has already pointed out the solution.
Just to add on -
A Cassandra config would be like -
{
"type": "cassandra",
"host": "localhost",
"port": 9042,
"enabled": true
}
Make sure that Cassandra is up on port 9042 of the box. Replace the
localhost with the host IP otherwise.
A curl request (assuming drill and cassandra both on localhost) would be
like -
curl -X POST -H “Content-Type: application/json” -d ‘{ “name”:cassandra,
“config”:{“type”: “cassandra”, “host”: “localhost”, “port”: 9042,
“enabled”: true}}’ http://localhost:8047/storage/cassandra.json
In case you find that your plugin is still not enabled, you can do that
manually by -
curl -X GET http://localhost:8047/storage/cassandra/enable/true
Hope its helpful.
Thanks
On Wed, Feb 25, 2015 at 4:57 AM, Hanifi Gunes <hg...@maprtech.com> wrote:
> +drill-user
>
> Monish,
>
> Try the following and make sure to enable the plugin. Note that I just made
> up the contents of config.
>
> POST /storage/{name}.json
> Example: POST /storage/cassandra.json
> Request body:
> {
> "name" : "cssndr",
> "config" : {
> "type" : "cassandra",
> *"enabled" : true,*
> "connection" : "cassandra:///"
> }
> }
>
> Response body:
> {
> "result" : "success"
> }
>
> Regards.
> -Hanifi
>
> On Tue, Feb 24, 2015 at 2:51 AM, monish kaul <ka...@gmail.com> wrote:
>
> > Hi,
> >
> > I have installed a 4 node drill cluster which is up and running(on EC2).
> > But, in order to add cassandra as a data source I need to access drill
> UI.
> > As per what i checked I am unable to access drill UI from public ip but a
> > curl on local machine works just fine - I believe this is due to binding
> > issue with the inbuilt jetty server which drill is using.
> > Any roundabout for the same ? Can I somehow add a data source using rest
> > service ?
> >
> > Regards,
> > Monish
> >
>
Fwd: Rest support to data-source addition
Posted by Hanifi Gunes <hg...@maprtech.com>.
+drill-user
Monish,
Try the following and make sure to enable the plugin. Note that I just made
up the contents of config.
POST /storage/{name}.json
Example: POST /storage/cassandra.json
Request body:
{
"name" : "cssndr",
"config" : {
"type" : "cassandra",
*"enabled" : true,*
"connection" : "cassandra:///"
}
}
Response body:
{
"result" : "success"
}
Regards.
-Hanifi
On Tue, Feb 24, 2015 at 2:51 AM, monish kaul <ka...@gmail.com> wrote:
> Hi,
>
> I have installed a 4 node drill cluster which is up and running(on EC2).
> But, in order to add cassandra as a data source I need to access drill UI.
> As per what i checked I am unable to access drill UI from public ip but a
> curl on local machine works just fine - I believe this is due to binding
> issue with the inbuilt jetty server which drill is using.
> Any roundabout for the same ? Can I somehow add a data source using rest
> service ?
>
> Regards,
> Monish
>
Fwd: Rest support to data-source addition
Posted by Hanifi Gunes <hg...@maprtech.com>.
+drill-user
Monish,
Try the following and make sure to enable the plugin. Note that I just made
up the contents of config.
POST /storage/{name}.json
Example: POST /storage/cassandra.json
Request body:
{
"name" : "cssndr",
"config" : {
"type" : "cassandra",
*"enabled" : true,*
"connection" : "cassandra:///"
}
}
Response body:
{
"result" : "success"
}
Regards.
-Hanifi
On Tue, Feb 24, 2015 at 2:51 AM, monish kaul <ka...@gmail.com> wrote:
> Hi,
>
> I have installed a 4 node drill cluster which is up and running(on EC2).
> But, in order to add cassandra as a data source I need to access drill UI.
> As per what i checked I am unable to access drill UI from public ip but a
> curl on local machine works just fine - I believe this is due to binding
> issue with the inbuilt jetty server which drill is using.
> Any roundabout for the same ? Can I somehow add a data source using rest
> service ?
>
> Regards,
> Monish
>
Re: Rest support to data-source addition
Posted by Hanifi Gunes <hg...@maprtech.com>.
Monish,
Try the following and make sure to enable the plugin. Note that I just made
up the contents of config.
POST /storage/{name}.json
Example: POST /storage/cassandra.json
Request body:
{
"name" : "cssndr",
"config" : {
"type" : "cassandra",
*"enabled" : true,*
"connection" : "cassandra:///"
}
}
Response body:
{
"result" : "success"
}
Regards.
-Hanifi
On Tue, Feb 24, 2015 at 2:51 AM, monish kaul <ka...@gmail.com> wrote:
> Hi,
>
> I have installed a 4 node drill cluster which is up and running(on EC2).
> But, in order to add cassandra as a data source I need to access drill UI.
> As per what i checked I am unable to access drill UI from public ip but a
> curl on local machine works just fine - I believe this is due to binding
> issue with the inbuilt jetty server which drill is using.
> Any roundabout for the same ? Can I somehow add a data source using rest
> service ?
>
> Regards,
> Monish
>