Hello,   You can follow the steps outlined here. This is for CDH 6.3:   https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_mc_adding_hosts.html#cmug_topic_7_5_1__title_215   Regards, Steve ... View more

Since Hadoop 2.8, it is possible to make a directory protected and so all its files cannot be deleted, using : fs.protected.directories property.   From documentation: "A comma-separated list of directories which cannot be deleted even by the superuser unless they are empty. This setting can be used to guard important system directories against accidental deletion due to administrator error."   It does not exactly answer the question but it is a possibility. ... View more

You can do alter like I mentioned before: ALTER TABLE test CHANGE col1 col1 int COMMENT 'test comment'; But I do not think you can remove it, but rather to just empty it. Cheers Eric ... View more

Could you share the error ?  Do you have sqoop client being installed on the node ?  whats you mysql cnf file looking  if you have this   skip-networking just comment it out and restart the mysql  i assume it your poc box.   ... View more

@saranvisa you're most welcome! ... View more

hi，man, did you fixed this  problem,i have the same too. ... View more

Not helpful yet, but promising... PIVOT keyword is reserved for future use! https://www.cloudera.com/documentation/enterprise/6/6.2/topics/impala_reserved_words.html ... View more

this helped thanks! ... View more

By default, in Hive, Parquet files are not written with compression enabled.   https://issues.apache.org/jira/browse/HIVE-11912   However, writing files with Impala into a Parquet table will create files with internal Snappy compression (by default). ... View more

Worked for me too. Thank you. ... View more