Hi,   What's the CDH version you are using currently on which you are seeing this issue? Can you share the workflow.xml and the script that you are running? Also kindly share the oozie launcher logs.   Regards Nitish ... View more

Hi,   NOTE:- Parquet is hard coded to write the temporary data in /tmp even though the target directory is different.   Kindly check /tmp for intermediate data, you will see it there.   Regards ... View more

Hi,   Can you please share the sqoop command that you are running?   Regards Nitish ... View more

Hi,   Did you try using -m 1?   Does that work fine?   Regards Nitish ... View more

Hi,   You can use this tag "--temporary-rootdir" to make sure that the temporary data goes into this folder.   Example:- [example] sqoop import --target-dir /<hdfs path>/<import_data_dir> --temporary-rootdir /<dfs path>/<tmp_dir> ...   Regards Nitish ... View more

Hi,   You can try like below example.   Data in source ###########   [root@host-10-17-103-77 ~]# sqoop eval --connect $MYCONN --username $MYUSER --password $MYPSWD --query "create table test_partition(id int,name varchar(30),par varchar(20))" [root@host-10-17-103-77 ~]# sqoop eval --connect $MYCONN --username $MYUSER --password $MYPSWD --query "insert into test_partition values(1,'nitish','par1')" [root@host-10-17-103-77 ~]# sqoop eval --connect $MYCONN --username $MYUSER --password $MYPSWD --query "insert into test_partition values(2,'mohit','par2')" [root@host-10-17-103-77 ~]# sqoop eval --connect $MYCONN --username $MYUSER --password $MYPSWD --query "insert into test_partition values(3,'mohit123','par3')"   Table in Hive:- ############ 0: jdbc:hive2://host-10-17-103-79.coe.clouder> create external table test_sqoop_par(id int,name string) partitioned by (par string) row format delimited fields terminated by '\t' location '/user/systest/test_sqoop_par';   NOTE:- partition column as string is only supported.   Sqoop command:- ############## [root@host-10-17-103-77 ~]# sqoop import --connect $MYCONN --username $MYUSER --password $MYPSWD --hcatalog-database default --hcatalog-table test_sqoop_par --table TEST_PARTITION -m1 --hive-partition-value par   Data in Hive:- ########## 0: jdbc:hive2://host-10-17-103-79.coe.clouder> show partitions test_sqoop_par; +------------+ | partition  | +------------+ | par=par1   | | par=par2   | | par=par3   | +------------+   [root@host-10-17-103-77 ~]# hadoop fs -ls /user/systest/test_sqoop_par Found 3 items drwxr-xr-x   - systest supergroup          0 2019-09-30 18:49 /user/systest/test_sqoop_par/par=par1 drwxr-xr-x   - systest supergroup          0 2019-09-30 18:49 /user/systest/test_sqoop_par/par=par2 drwxr-xr-x   - systest supergroup          0 2019-09-30 18:49 /user/systest/test_sqoop_par/par=par3   Hope above helps.   Regards Nitish   ... View more

Hi,   Not sure at this point what is the issue on that host as I am not able to debug the host related issue.   Have you configured Sqoop gateway on both the hosts?   Regards Nitish ... View more

This means that from the master node the job is failed to be created but when you are running the job from slave node then it is getting created.   Am I right?   If yes then I would request you to check the difference b/w the hosts. Also check if the sqoop gateway has been deployed? If yes then on what node.   There is some setup issue in your cluster which is causing this.   Regards Nitish ... View more

Hi,   I would request you to configure Sqoop gateways on that hosts and install metastore.   KB:- https://my.cloudera.com/knowledge/Creating-and-Executing-Sqoop-Jobs-Remotely-|-Sqoop1-Shared-Metastore-Database?id=70942   Regards Nitish ... View more