[
https://issues.apache.org/jira/browse/PHOENIX-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14985504#comment-14985504
]
maghamravikiran commented on PHOENIX-763:
-----------------------------------------
Support for integrating Sqoop and Phoenix can be tracked through
https://issues.apache.org/jira/browse/SQOOP-2649. Currently, the patch is
available for 1.4.6 v of Sqoop.
Ex.
1. sqoop import --connect jdbc:mysql://localhost/test --username root -P
--verbose --table employee --phoenix-table EMP
2. sqoop import --connect jdbc:mysql://localhost/test --username root -P
--verbose --query "SELECT id AS ID,name AS NAME FROM employee WHERE
\$CONDITIONS" --target-dir /tmp/employee --phoenix-table EMP
3. sqoop import --connect jdbc:mysql://localhost/test --username root -P
--verbose --query "SELECT rowid,name FROM employee WHERE \$CONDITIONS"
--target-dir /tmp/employee --phoenix-table EMP --phoenix-column-mapping
"rowid;ID,name;NAME"
4. sqoop import --connect jdbc:mysql://localhost/test --username root -P
--verbose --query "SELECT rowid,name FROM employee WHERE \$CONDITIONS"
--target-dir /tmp/employee --phoenix-table EMP --phoenix-column-mapping
"rowid;ID,name;NAME" --phoenix-bulkload
Arguments:
--phoenix-table : Required . The phoenix table
--phoenix-column-mapping: Optional. This property should be specified if
the column names between sqoop table and phoenix table differ.
--phoenix-bulkload Optional . Bulk loads data onto the
phoenix table.
> Support for Sqoop
> -----------------
>
> Key: PHOENIX-763
> URL: https://issues.apache.org/jira/browse/PHOENIX-763
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 3.0.0
> Reporter: James Taylor
> Assignee: mravi
> Labels: patch
> Attachments: PHOENIX-763.patch
>
>
> Not sure anything required from our end, but you should be able to use Sqoop
> to create and populate Phoenix tables.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
