Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Lesson 1 of Cloudera Live Tutorial

avatar
Explorer

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

Who agreed with this topic