[
https://issues.apache.org/jira/browse/DRILL-6423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16477809#comment-16477809
]
ASF GitHub Bot commented on DRILL-6423:
---------------------------------------
kkhatua commented on issue #1266: DRILL-6423: Export query result as a CSV file
URL: https://github.com/apache/drill/pull/1266#issuecomment-389609375
Tested with a query on a TPC-H customer table with 1000 row limit.
Things to note:
- The table is filtered for showing only 10 rows of 'FURNITURE' market
segment, and ordered by the customer with the lowest (i.e. most negative)
balances.
- Exporting this prompts to save the result as a CSV (default delimiter is
comma, as seen on the top right). under the profile name.
- The query's profile can be opened in a new window with the link on the top
left.
- Since there are only 10 rows visible, only the 10 rows will be exported
into the CSV.
**Screenshot:**
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Export query result as a CSV file
> ---------------------------------
>
> Key: DRILL-6423
> URL: https://issues.apache.org/jira/browse/DRILL-6423
> Project: Apache Drill
> Issue Type: New Feature
> Components: Web Server
> Reporter: Kunal Khatua
> Assignee: Kunal Khatua
> Priority: Major
> Fix For: 1.14.0
>
>
> This feature request is based on a question posted in the user mailing list:
> [is there any way to download the data through Drill Web
> UI?|https://lists.apache.org/thread.html/bd6b2453c83d818b618ec6334891309f42556d4a7de34d84024a43cd@<user.drill.apache.org>]
> Since the results of the WebUI allows for sorting and filtering as well, it
> can be very useful if there is a way for a user to download the results of an
> executed query for further processing in other tools (like Excel)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
