You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Chaitanya (JIRA)" <ji...@apache.org> on 2017/05/25 12:56:04 UTC
[jira] [Created] (PHOENIX-3887) Bulk export of large query result
set
Chaitanya created PHOENIX-3887:
----------------------------------
Summary: 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
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)