sqoop import to a phoenix table

[#1]

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.

[#2]

@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

[#3 · Accepted solution]

@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

[#4]

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.