在Hive中创建employee表,与mysql的sqoop用户下的相同的表
1在Linux的终端输入以下代码
sqoop create-hive-table --connect jdbc:mysql://localhost:3306/sqoop --table employee --username sqoop --password sqoop --hive-table employee
运行过程最后有显示:
14/06/03 17:43:01 INFO hive.HiveImport: OK 14/06/03 17:43:01 INFO hive.HiveImport: Time taken: 3.447 seconds 14/06/03 17:43:01 INFO hive.HiveImport: Hive import complete. 14/06/03 17:43:01 INFO hive.HiveImport: Export directory is not empty, keeping it.
2在HDFS下查看表employee是否存在hadoop dfs -ls /user/hive/warehouse
运行结果显示:其中:/user/hive/warehouse是hive中表的默认存储路径,这个路径在hive安装时自己可以设置路径Found 1 items drwxr-xr-x - cwjy1202 supergroup 0 2014-06-03 17:43 /user/hive/warehouse/employee
建表成功!!!