question sqoop import to a phoenix table in Archives of Support Questions (Read Only)

sqoop import to a phoenix table

arunpoy — Mon, 27 Jun 2016 15:37:42 GMT

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.

jyadav — Mon, 27 Jun 2016 15:45:48 GMT

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

Also looks like sqoop pheonix integration is on roadmap.

ssubhas — Mon, 27 Jun 2016 16:39:50 GMT

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.

Thanks and Regards,

Sindhu

arunpoy — Mon, 27 Jun 2016 16:48:15 GMT

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.