Sqoop import with compression always stuck with no completion


#1

All I want is to sqoop import the data and save it as a compress format, I tried default gzip, snappy, neither works. Here is my command:

sqoop import
–connect jdbc:mysql://ms.itversity.com/retail_db
–username=retail_user
–password=itversity
–table=orders
–target-dir=“orders0322snappy”
–compress
–compression-codec org.apache.hadoop.io.compress.SnappyCodec
–as-parquetfile

here is the job history, stuck here:

http://rm01.itversity.com:8088/cluster/app/application_1520592249193_24575

Am I missing anything here?

Thank you very much.


#2

Hi,
try with this command it is running

sqoop import
–connect “jdbc:mysql://ms.itversity.com:3306/retail_db”
–username retail_user
–password itversity
–table orders
–warehouse-dir /user/shreshthasharma2392/sqoop_import/retail_db
–as-parquetfile
–compress
–compression-codec org.apache.hadoop.io.compress.SnappyCodec