mysql> describe orders;
+-------------------+-------------+------+-----+---------+-------+
| Field             | Type        | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| order_id          | int(11)     | YES  |     | NULL    |       |
| order_date        | varchar(30) | YES  |     | NULL    |       |
| order_customer_id | int(11)     | YES  |     | NULL    |       |
| order_items       | varchar(30) | YES  |     | NULL    |       |
+-------------------+-------------+------+-----+---------+-------+

sqoop import
  --connect "jdbc:mysql://quickstart.cloudera:3306/retail_db"
  --username=root
  --password=cloudera
  --table orders
  --target-dir /user/hive/warehouse/retail_stage.db/orders
  --as-avrodatafile
  --split-by order_id

hive> describe orders;
OK
error_error_error_error_error_error_error   string                  from deserializer
cannot_determine_schema string                  from deserializer
check                   string                  from deserializer
schema                  string                  from deserializer
url                     string                  from deserializer
and                     string                  from deserializer
literal                 string                  from deserializer
Time taken: 1.15 seconds, Fetched: 7 row(s)