sqoop建表,如何使用sqoop在Hive中创建外部表。需要建议

Using sqoop I can create managed table but not the externale table.

Please let me know what are the best practices to unload data from data warehouse and load them in Hive external table.

1.The tables in warehouse are partitioned. Some are date wise partitioned some are state wise partitioned.

Please put your thoughts or practices used in production environment.

解决方案

Sqoop does not support creating Hive external tables. Instead you might:

Use the Sqoop codegen command to generate the SQL for creating the Hive internal table that matches your remote RDBMS table (see http://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_literal_sqoop_codegen_literal)

Modify the generated SQL to create a Hive external table

Execute the modified SQL in Hive

Run your Sqoop import command, loading into the pre-created Hive external table