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 <[email protected]> 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 <[email protected]> 
>> 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 <[email protected]> 
>> > 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 <[email protected]>
>> > 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" <[email protected]> wrote:
>> >> 
>> >>    Hi,
>> >>    Can I download the select query data through Drill Web UI or any other
>> >>    means ?
>> >> 
>> >> 
>> >>    Thanks,
>> >>    Divya
>> >> 
>> >> 
>> >> 
> 

Reply via email to