phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geoffrey Jacoby (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3887) Bulk export of large query result set
Date Thu, 25 May 2017 17:39:04 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16025083#comment-16025083
] 

Geoffrey Jacoby commented on PHOENIX-3887:
------------------------------------------

[~cmbendre] - some basic contributing guidelines are here: http://phoenix.apache.org/contributing.html

And of course if you have more questions you can ask the community questions here on the JIRA
or on the dev list (subscription info here: http://phoenix.apache.org/mailing_list.html)


> Bulk export of large query result set
> -------------------------------------
>
>                 Key: PHOENIX-3887
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3887
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.8.0
>            Reporter: Chaitanya
>            Priority: Minor
>              Labels: beginner
>   Original Estimate: 504h
>  Remaining Estimate: 504h
>
> Query results with large number of rows can not be consumed by a single JDBC connection.
> To export these results as a CSV file either on a local filesystem or HDFS, we can connect
by Spark / Hive to Phoenix but there can be a tool (or MR job) which can be implemented just
like CsvBulkLoadTool or ./psql.py. This is a very common use case for big results. 
> Similar functionality exists in Postgres via COPY command and in Redshift via UNLOAD
command.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message