Re: is there any way to download the data through Drill Web UI?

[Saurabh Mahapatra]

You are amazing, Kunal. Thanks!

On Wed, May 16, 2018 at 10:51 AM, Kunal Khatua <ku...@apache.org> wrote:

> I've filed https://issues.apache.org/jira/browse/DRILL-6423 and opened a
> PR for this. (https://github.com/apache/drill/pull/1266)
> This allows you to export the visible table in the results page as a CSV.
> That means, you can actually sort or filter the results in the UI and then
> choose the export option. Also added a field to specify the delimiter
> (default is comma).
>
> On 5/15/2018 7:03:48 PM, Robert Hou <r...@mapr.com> wrote:
> I think BI tools should have a way to export the data to csv. Tableau does.
>
>
> Thanks.
>
>
> --Robert
>
> 
> From: Saurabh Mahapatra
> Sent: Tuesday, May 15, 2018 6:56 PM
> To: Divya Gehlot
> Cc: user@drill.apache.org
> Subject: Re: is there any way to download the data through Drill Web UI?
>
> Hi Vitalii, all,
>
> How hard would it be to do this in the UI? The data has already been
> fetched. At the very worst, it could just be another query that does
> exactly what you suggested, CTAS to CSV.
>
> Exporting to CSV is a very common task done by almost every BI user. I
> know we never intended the web UI tool to be a BI one but we should enhance
> it.
>
> What are your thoughts?
>
> Thanks,
> Saurabh
>
> Sent from my iPhone
>
>
>
> > On May 15, 2018, at 6:34 PM, Divya Gehlot wrote:
> >
> > Hi Saurabh ,
> > Yes I am looking button on the WEB UI as I have people in my team(BI
> analysts) who are not big data evangelist and they prefer the feasible way
> to download the data , ad they query for their analysis
> >
> > Thanks,
> > Divya
> >
> >> On 14 May 2018 at 22:54, Saurabh Mahapatra wrote:
> >> Hi Divya,
> >>
> >> Are you looking for a button in the UI that downloads the table if
> interests you, see into a (say) CSV file?
> >>
> >> Thanks,
> >> Saurabh
> >>
> >> Sent from my iPhone
> >>
> >>
> >>
> >> > On May 14, 2018, at 7:21 AM, Vitalii Diravka wrote:
> >> >
> >> > Hi Divya,
> >> >
> >> > Consider using of CTAS for your query with picking any storage format
> [1]:
> >> > parquet, json, csv, tsv, psv (csv-family formats have limitations).
> >> >
> >> > [1]
> >> > https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.
> apache.org_docs_create-2Dtable-2Das-2Dctas_-23setting-2Dthe-2Dstorage-
> 2Dformat=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=GXRJhB4g1YFDJsrcglHwUA=
> bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k=
> hR79dhvhq1fvrDEhh6RQLY1532H2nB9RjnzptDqhGaM=
> >> >
> >> > Kind regards
> >> > Vitalii
> >> >
> >> >
> >> > On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht
> >> > wrote:
> >> >
> >> >> You can look at using the REST API to send a query and receive the
> results
> >> >> back through http(s) (pending on how you configured Drill.
> >> >> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.
> apache.org_docs_rest-2Dapi_=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=
> GXRJhB4g1YFDJsrcglHwUA=bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k=
> vgJzQoYaIFb0AI7Lq1Kw6zeG-ib4fczMGg5RzyYsrzE=
> >> >>
> >> >> --Andries
> >> >>
> >> >>
> >> >>
> >> >> On 5/14/18, 1:20 AM, "Divya Gehlot" wrote:
> >> >>
> >> >> Hi,
> >> >> Can I download the select query data through Drill Web UI or any
> other
> >> >> means ?
> >> >>
> >> >>
> >> >> Thanks,
> >> >> Divya
> >> >>
> >> >>
> >> >>
> >
>

Re: is there any way to download the data through Drill Web UI?

[Kunal Khatua]

I've filed https://issues.apache.org/jira/browse/DRILL-6423 and opened a PR for 
this. (https://github.com/apache/drill/pull/1266)
This allows you to export the visible table in the results page as a CSV. That 
means, you can actually sort or filter the results in the UI and then choose 
the export option. Also added a field to specify the delimiter (default is 
comma). 

On 5/15/2018 7:03:48 PM, Robert Hou <r...@mapr.com> wrote:
I think BI tools should have a way to export the data to csv. Tableau does.


Thanks.


--Robert


From: Saurabh Mahapatra
Sent: Tuesday, May 15, 2018 6:56 PM
To: Divya Gehlot
Cc: user@drill.apache.org
Subject: Re: is there any way to download the data through Drill Web UI?

Hi Vitalii, all,

How hard would it be to do this in the UI? The data has already been fetched. 
At the very worst, it could just be another query that does exactly what you 
suggested, CTAS to CSV.

Exporting to CSV is a very common task done by almost every BI user. I know we 
never intended the web UI tool to be a BI one but we should enhance it.

What are your thoughts?

Thanks,
Saurabh

Sent from my iPhone



> On May 15, 2018, at 6:34 PM, Divya Gehlot wrote:
>
> Hi Saurabh ,
> Yes I am looking button on the WEB UI as I have people in my team(BI 
> analysts) who are not big data evangelist and they prefer the feasible way to 
> download the data , ad they query for their analysis
>
> Thanks,
> Divya
>
>> On 14 May 2018 at 22:54, Saurabh Mahapatra wrote:
>> Hi Divya,
>>
>> Are you looking for a button in the UI that downloads the table if interests 
>> you, see into a (say) CSV file?
>>
>> Thanks,
>> Saurabh
>>
>> Sent from my iPhone
>>
>>
>>
>> > On May 14, 2018, at 7:21 AM, Vitalii Diravka wrote:
>> >
>> > Hi Divya,
>> >
>> > Consider using of CTAS for your query with picking any storage format [1]:
>> > parquet, json, csv, tsv, psv (csv-family formats have limitations).
>> >
>> > [1]
>> > https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_create-2Dtable-2Das-2Dctas_-23setting-2Dthe-2Dstorage-2Dformat=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=GXRJhB4g1YFDJsrcglHwUA=bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k=hR79dhvhq1fvrDEhh6RQLY1532H2nB9RjnzptDqhGaM=
>> >
>> > Kind regards
>> > Vitalii
>> >
>> >
>> > On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht
>> > wrote:
>> >
>> >> You can look at using the REST API to send a query and receive the results
>> >> back through http(s) (pending on how you configured Drill.
>> >> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rest-2Dapi_=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=GXRJhB4g1YFDJsrcglHwUA=bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k=vgJzQoYaIFb0AI7Lq1Kw6zeG-ib4fczMGg5RzyYsrzE=
>> >>
>> >> --Andries
>> >>
>> >>
>> >>
>> >> On 5/14/18, 1:20 AM, "Divya Gehlot" wrote:
>> >>
>> >> Hi,
>> >> Can I download the select query data through Drill Web UI or any other
>> >> means ?
>> >>
>> >>
>> >> Thanks,
>> >> Divya
>> >>
>> >>
>> >>
>

Re: is there any way to download the data through Drill Web UI?

[Robert Hou]

I think BI tools should have a way to export the data to csv.  Tableau does.


Thanks.


--Robert


From: Saurabh Mahapatra <saurabhmahapatr...@gmail.com>
Sent: Tuesday, May 15, 2018 6:56 PM
To: Divya Gehlot
Cc: user@drill.apache.org
Subject: Re: is there any way to download the data through Drill Web UI?

Hi Vitalii, all,

How hard would it be to do this in the UI? The data has already been fetched. 
At the very worst, it could just be another query that does exactly what you 
suggested, CTAS to CSV.

Exporting to CSV is a very common task done by almost every BI user. I know we 
never intended the web UI tool to be a BI one but we should enhance it.

What are your thoughts?

Thanks,
Saurabh

Sent from my iPhone



> On May 15, 2018, at 6:34 PM, Divya Gehlot <divya.htco...@gmail.com> wrote:
>
> Hi Saurabh ,
> Yes I am looking button on the WEB UI as I have people in my team(BI 
> analysts) who are not big data evangelist and they prefer the feasible way to 
> download the data , ad they query for their analysis
>
> Thanks,
> Divya
>
>> On 14 May 2018 at 22:54, Saurabh Mahapatra <saurabhmahapatr...@gmail.com> 
>> wrote:
>> Hi Divya,
>>
>> Are you looking for a button in the UI that downloads the table if interests 
>> you, see into a (say) CSV file?
>>
>> Thanks,
>> Saurabh
>>
>> Sent from my iPhone
>>
>>
>>
>> > On May 14, 2018, at 7:21 AM, Vitalii Diravka <vitalii.dira...@gmail.com> 
>> > wrote:
>> >
>> > Hi Divya,
>> >
>> > Consider using of CTAS for your query with picking any storage format [1]:
>> > parquet, json, csv, tsv, psv (csv-family formats have limitations).
>> >
>> > [1]
>> > https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_create-2Dtable-2Das-2Dctas_-23setting-2Dthe-2Dstorage-2Dformat=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=GXRJhB4g1YFDJsrcglHwUA=bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k=hR79dhvhq1fvrDEhh6RQLY1532H2nB9RjnzptDqhGaM=
>> >
>> > Kind regards
>> > Vitalii
>> >
>> >
>> > On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht <aengelbre...@mapr.com>
>> > wrote:
>> >
>> >> You can look at using the REST API to send a query and receive the results
>> >> back through http(s) (pending on how you configured Drill.
>> >> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rest-2Dapi_=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=GXRJhB4g1YFDJsrcglHwUA=bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k=vgJzQoYaIFb0AI7Lq1Kw6zeG-ib4fczMGg5RzyYsrzE=
>> >>
>> >> --Andries
>> >>
>> >>
>> >>
>> >> On 5/14/18, 1:20 AM, "Divya Gehlot" <divya.htco...@gmail.com> wrote:
>> >>
>> >>Hi,
>> >>Can I download the select query data through Drill Web UI or any other
>> >>means ?
>> >>
>> >>
>> >>Thanks,
>> >>Divya
>> >>
>> >>
>> >>
>

Re: is there any way to download the data through Drill Web UI?

[Saurabh Mahapatra]

Hi Vitalii, all,

How hard would it be to do this in the UI? The data has already been fetched. 
At the very worst, it could just be another query that does exactly what you 
suggested, CTAS to CSV.

Exporting to CSV is a very common task done by almost every BI user. I know we 
never intended the web UI tool to be a BI one but we should enhance it. 

What are your thoughts?

Thanks,
Saurabh

Sent from my iPhone



> On May 15, 2018, at 6:34 PM, Divya Gehlot  wrote:
> 
> Hi Saurabh ,
> Yes I am looking button on the WEB UI as I have people in my team(BI 
> analysts) who are not big data evangelist and they prefer the feasible way to 
> download the data , ad they query for their analysis 
> 
> Thanks,
> Divya 
> 
>> On 14 May 2018 at 22:54, Saurabh Mahapatra  
>> wrote:
>> Hi Divya,
>> 
>> Are you looking for a button in the UI that downloads the table if interests 
>> you, see into a (say) CSV file?
>> 
>> Thanks,
>> Saurabh 
>> 
>> Sent from my iPhone
>> 
>> 
>> 
>> > On May 14, 2018, at 7:21 AM, Vitalii Diravka  
>> > wrote:
>> > 
>> > Hi Divya,
>> > 
>> > Consider using of CTAS for your query with picking any storage format [1]:
>> > parquet, json, csv, tsv, psv (csv-family formats have limitations).
>> > 
>> > [1]
>> > https://drill.apache.org/docs/create-table-as-ctas/#setting-the-storage-format
>> > 
>> > Kind regards
>> > Vitalii
>> > 
>> > 
>> > On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht 
>> > wrote:
>> > 
>> >> You can look at using the REST API to send a query and receive the results
>> >> back through http(s) (pending on how you configured Drill.
>> >> https://drill.apache.org/docs/rest-api/
>> >> 
>> >> --Andries
>> >> 
>> >> 
>> >> 
>> >> On 5/14/18, 1:20 AM, "Divya Gehlot"  wrote:
>> >> 
>> >>Hi,
>> >>Can I download the select query data through Drill Web UI or any other
>> >>means ?
>> >> 
>> >> 
>> >>Thanks,
>> >>Divya
>> >> 
>> >> 
>> >> 
> 

Re: is there any way to download the data through Drill Web UI?

[Divya Gehlot]

Hi Saurabh ,
Yes I am looking button on the WEB UI as I have people in my team(BI
analysts) who are not big data evangelist and they prefer the feasible way
to download the data , ad they query for their analysis

Thanks,
Divya

On 14 May 2018 at 22:54, Saurabh Mahapatra 
wrote:

> Hi Divya,
>
> Are you looking for a button in the UI that downloads the table if
> interests you, see into a (say) CSV file?
>
> Thanks,
> Saurabh
>
> Sent from my iPhone
>
>
>
> > On May 14, 2018, at 7:21 AM, Vitalii Diravka 
> wrote:
> >
> > Hi Divya,
> >
> > Consider using of CTAS for your query with picking any storage format
> [1]:
> > parquet, json, csv, tsv, psv (csv-family formats have limitations).
> >
> > [1]
> > https://drill.apache.org/docs/create-table-as-ctas/#setting-
> the-storage-format
> >
> > Kind regards
> > Vitalii
> >
> >
> > On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht <
> aengelbre...@mapr.com>
> > wrote:
> >
> >> You can look at using the REST API to send a query and receive the
> results
> >> back through http(s) (pending on how you configured Drill.
> >> https://drill.apache.org/docs/rest-api/
> >>
> >> --Andries
> >>
> >>
> >>
> >> On 5/14/18, 1:20 AM, "Divya Gehlot"  wrote:
> >>
> >>Hi,
> >>Can I download the select query data through Drill Web UI or any
> other
> >>means ?
> >>
> >>
> >>Thanks,
> >>Divya
> >>
> >>
> >>
>

Re: is there any way to download the data through Drill Web UI?

[Saurabh Mahapatra]

Hi Divya,

Are you looking for a button in the UI that downloads the table if interests 
you, see into a (say) CSV file?

Thanks,
Saurabh 

Sent from my iPhone



> On May 14, 2018, at 7:21 AM, Vitalii Diravka  
> wrote:
> 
> Hi Divya,
> 
> Consider using of CTAS for your query with picking any storage format [1]:
> parquet, json, csv, tsv, psv (csv-family formats have limitations).
> 
> [1]
> https://drill.apache.org/docs/create-table-as-ctas/#setting-the-storage-format
> 
> Kind regards
> Vitalii
> 
> 
> On Mon, May 14, 2018 at 4:45 PM Andries Engelbrecht 
> wrote:
> 
>> You can look at using the REST API to send a query and receive the results
>> back through http(s) (pending on how you configured Drill.
>> https://drill.apache.org/docs/rest-api/
>> 
>> --Andries
>> 
>> 
>> 
>> On 5/14/18, 1:20 AM, "Divya Gehlot"  wrote:
>> 
>>Hi,
>>Can I download the select query data through Drill Web UI or any other
>>means ?
>> 
>> 
>>Thanks,
>>Divya
>> 
>> 
>> 

Re: is there any way to download the data through Drill Web UI?

[Andries Engelbrecht]

You can look at using the REST API to send a query and receive the results back 
through http(s) (pending on how you configured Drill.
https://drill.apache.org/docs/rest-api/

--Andries



On 5/14/18, 1:20 AM, "Divya Gehlot"  wrote:

Hi,
Can I download the select query data through Drill Web UI or any other
means ?


Thanks,
Divya

is there any way to download the data through Drill Web UI?

[Divya Gehlot]

Hi,
Can I download the select query data through Drill Web UI or any other
means ?


Thanks,
Divya