28798
DISCUSSIONS
102179
MEMBERS
3161
ARTICLES
Hello,
I am trying to run the initial statement that sets up the environment:
sqoop import-all-tables \
-m 12 \
--connect jdbc:mysql://216.121.84.2:3306/retail_db \
--username=retail_dba \
--password=cloudera \
--compression-codec=snappy \
--as-avrodatafile \
--warehouse-dir=/user/hive/warehouse
After running tht statement there are a couple of 'ls' commands to confirm things worked. When I ran those 2 statements I wasn't getting output. After hunting around on the forum I tried replacing the IP address in the connect with the server name. That seemed to help some as I would now see the list of folders.
However, I notice and error stating: FileAlreadyExistsException: Output directory /user/hive/warehouse/categories already exists. I assume this is why when I tried to inspect the contents of the categories folder it appears to be empty.
Any ideas? Is there some sort of cleanup script I need to run if I'm running the sqoop import-all-tables command a 2nd time?
Thanks in advance for your help.
Sincerely,
Tom