You are amazing, Kunal. Thanks! On Wed, May 16, 2018 at 10:51 AM, Kunal Khatua <[email protected]> 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 <[email protected]> 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: [email protected] > 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&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=GXRJhB4g1YFDJsrcglHwUA&m= > bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k&s= > hR79dhvhq1fvrDEhh6RQLY1532H2nB9RjnzptDqhGaM&e= > >> > > >> > 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_&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r= > GXRJhB4g1YFDJsrcglHwUA&m=bfnHktP6fel4EqFZ11n921lIVIaQ8cmiOGW6UVnKr8k&s= > vgJzQoYaIFb0AI7Lq1Kw6zeG-ib4fczMGg5RzyYsrzE&e= > >> >> > >> >> --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 > >> >> > >> >> > >> >> > > >
