Here is the link that has syntax to compute statisitcs on hive partitioned table. https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_dataintegration/content/cost-based-opt.html ANALYZE TABLE employees PARTITION (dt) COMPUTE STATISTICS ... View more

Run analyze table <table name> compute statistics; ... View more

Are you able to ping each host from Ambari server nodes and vice-versa? The error says "org.apache.ambari.server.HostNotFoundException: Host not found, hostname=ctsc00675971901.cts.com" ... View more

yes, you will have to choose some other column. ... View more

yes, you will have to choose some other column. ... View more

Is id_person part of primary key? If it is part of primary_key, it won't work. ... View more

yes you can. Also, to investigate why it is using only one mapper, can you check your mapper size and size of that you are trying to import? How did you calculate your split size? ... View more

Are you able to ping sandbox.hortonworks.com from your windows machine? If not, try using IP address instead of hostname. ... View more

You can use Ambari views(HDFS, Hive, Pig) within Ambari web interface. ... View more

Take a look at below properties. You can reduce the retention time of local logs. yarn.nodemanager.log.retain-seconds: Time in seconds to retain user logs on the individual nodes if log aggregation is disabled. Default is 10800 yarn.nodemanager.log.deletion-threads-count: Determines the number of threads used by the NodeManagers to clean-up logs once the log-retention time is hit for local log files when aggregation is disabled. ... View more