how to import data from mysql into hive by sqoop1.99.3

Question

I have just installed sqoop 1.99.3 and imported a table into HDFS from mysql.Now I want import a table into hive or hbase from mysql by sqoop,but I don't know how to do this.The command 'sqoop import --connect jdbc:mysql://ip:port/dbName --username root --password mysql-password --table' for sqoop 1.4.* doesn't seem to work.

Answer 1

For habse :
sqoop import --connect jdbc:mysql://ip:port/dbName --username UserName --password MysqlPassword --table TableName --hbase-table HbaseTableName --column-family ColumnFamilyName
for hive :
sqoop import --connect jdbc:mysql://ip:port/dbName --username UserName --password MysqlPassword --table HiveTableName --hive-import,
Substitute table name and column family name as per your requirement.