Below export command worked for me. CREATE table departments_export (departmentid int(11), department_name varchar(45), created_date T1MESTAMP); sqoop export --connect jdbc:mysql://<host>:3306/DB --username cloudera --password *** \ --table departments_export \ --export-dir '/user/cloudera/departments_new/*' \ -m 1 \ --input-fields-terminated-by ','; Sample input: 103,Finance,2020-10-10 10:10:00 ... View more

Thanks, I checked that information. ... View more

I didn't notice that actually. That because a little different version of HDP 2.6.2 to HDP 2.6.3.. And as I know, JDK 1.8 minimum requirement will be adopted HDP 3.0+.... ... View more

Hi @Gaurav Bapat, As you are using python 2.7.5 you might be hitting the same bug mentioned in about link. You can refer to this Link . https://access.redhat.com/articles/2039753#controlling-certificate-verification-7 and try disabling the certificates. hope this helps ... View more

So indeed it was a corrupted client, in that case please accept my first answer. ... View more

I'm just interesting. Why does it setup these options in hive config from ambari web? Well, actually, that means is if I want to use hive ORC file format with advanced TBLPROPERTIES such as "orc.compress, orc.compress.size, orc.stripe.size, orc,create.index....etc", I have to specify these tblproperties options every times when I'm trying to create hive table ORC file format. ... View more

Check users info in mysql.user. mysql> select User,Password,Host from mysql.user; Normally, create user DDL pattern is like this below. CREATE USER 'peter'@'localhost' IDENTFIED BY 'password'; GRANT ALL PRIGILEGES ON *.* TO 'peter'@'localhost'; CREATE USER 'peter'@'fqdn' IDENTFIED BY 'password'; GRANT ALL PRIGILEGES ON *.* TO 'peter'@'fqdn'; CREATE USER 'peter'@'%' IDENTFIED BY 'password'; GRANT ALL PRIGILEGES ON *.* TO 'peter'@'%'; FLUSH PRIVILEGES; ... View more

1st. If you were executed spark cmd with master(local), then check the connection host and port in that local server. 2nd. Check your firewall & iptables status whether it is of or off. ... View more