scoop import --connect jdbc:mysql://quickstart:3306/retail_db --username=retail_dba --password=cloudera --table=categories --where "\'category_id\' between 1 and 22" --hive-import --m 1

SHOW TABLES;
SELECT * FROM categories;