Hi @dharam p This might work with a free form import, try the same with the --query and --split-by on the command, for example; sqoop import -connect jdbc:oracle:thin:@192.168..:1521:orcl --username --P --query 'SELECT * FROM SDO_GR_RDT_1' --split-by <provide a column here to use for split by> --target-dir /user/SDO_GR_RDT_1/ --driver oracle.jdbc.OracleDriver ... View more

I checked my tez directory [root@node2 ~]# ls -l /usr/hdp/3.1.0.0-78/tez/ total 0 drwxr-xr-x 2 tez  hadoop 44 May 27 00:57 conf lrwxrwxrwx 1 root root   13 May 27 01:12 conf;5ceb0f32 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 01:34 conf;5ceb1477 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 02:09 conf;5ceb1c24 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 03:58 conf;5ceb3650 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 06:50 conf;5ceb5dd1 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 18:55 conf;5cec0874 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 19:13 conf;5cec0c93 -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 19:17 conf;5cec0d9c -> /etc/tez/conf lrwxrwxrwx 1 root root   13 May 27 19:21 conf;5cec0e81 -> /etc/tez/conf I think every unsuccessful attempt added a new line. I removed all [root@node2 ~]# rm -rf /usr/hdp/3.1.0.0-78/tez/* Using Ambari I reinstalled tez client for this node only. It worked. ... View more

@dharam p Beautiful if that worked out then you should "Accept" the appropriate answer and close this thread. ... View more