phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "maghamravikiran (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-763) Support for Sqoop
Date Mon, 02 Nov 2015 16:42:27 GMT

    [ 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)

Mime
View raw message