[
https://issues.apache.org/jira/browse/DRILL-6423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16477919#comment-16477919
]
ASF GitHub Bot commented on DRILL-6423:
---------------------------------------
vdiravka commented on issue #1266: DRILL-6423: Export query result as a CSV file
URL: https://github.com/apache/drill/pull/1266#issuecomment-389630332
1. What is the maximum number of rows can be shown? Does that number depends
on the machine resources?
2. Is it possible to save the data with Repeated values?
Since CTAS with `store.format`='csv' for such json doesn't work [(link to
code)](https://github.com/apache/drill/blob/master/exec/java-exec/src/main/codegen/templates/StringOutputRecordWriter.java#L110):
```
# cat test.json
{a:["aaa"]}
```
```
0: jdbc:drill:zk=local> create table test as select * from
dfs.'/tmp/test.json';
Error: SYSTEM ERROR: UnsupportedOperationException: Repeated types are not
supported.
```
----------------------------------------------------------------
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:
us...@infra.apache.org
> 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)
