Question: Can I import RDBMS table data (table doesn't have a primary key) to hive using sqoop? If yes, then can you please give the sqoop import command.

I have tried with sqoop import general command, but it failed.

Answer: 
You can import data from RDBMS into hive without Primarykey. 

First you need to create a table in hive.After that you need to write the following code:

```
sqoop import \
    --connect jdbc:mysql://localhost/test_db \
    --username root \
    --password **** \
    --table <RDBMS-Table-name> \
    --target-dir /user/root/user_data \
    --hive-import \ 
    --hive-table <hive-table-name> \
    --create-hive-table \
    -m 1 (or) --split-by <RDBMS-Column>

```
Use the following in your command:

```
--autoreset-to-one-mapper

```

`Import` should use one mapper if a table has no primary key and no split-by column is provided. It cannot be used with `--split-by <col>` option.