Support Questions
Find answers, ask questions, and share your expertise

sqoop import to a phoenix table

Solved Go to solution

sqoop import to a phoenix table

Can a RDBMS table be imported to a phoenix hbase table using Sqoop?

IS there a direct way of doing this and if so can anyone point out the required resources.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: sqoop import to a phoenix table

@ARUNKUMAR RAMASAMY

You can import data into underlying hbase table of phoenix, but data cannot be seen from phoenix.

Sqoop Jira SQOOP-2649 for sqoop-phoenix integration is addressed on Sqoop 1.4.7.

https://issues.apache.org/jira/browse/SQOOP-2649

Thanks and Regards,

Sindhu

View solution in original post

3 REPLIES 3

Re: sqoop import to a phoenix table

@ARUNKUMAR RAMASAMY

You can import to hbase directly using sqoop and then create pheonix table over it.

http://www.dummies.com/how-to/content/importing-data-into-hbase-with-sqoop.html

Also looks like sqoop pheonix integration is on roadmap.

https://phoenix.apache.org/roadmap.html

Re: sqoop import to a phoenix table

@ARUNKUMAR RAMASAMY

You can import data into underlying hbase table of phoenix, but data cannot be seen from phoenix.

Sqoop Jira SQOOP-2649 for sqoop-phoenix integration is addressed on Sqoop 1.4.7.

https://issues.apache.org/jira/browse/SQOOP-2649

Thanks and Regards,

Sindhu

View solution in original post

Re: sqoop import to a phoenix table

Thanks @Jitendra Yadav and @Sindhu, seems this feature of importing directly to a phoenix table is not available till sqoop 1.4.7 gets released.