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)

Reply via email to