here's apache jira to track it but it shows as not fixed because it breaks compatibility with future Hive releases and that has no effect on HDP 2.3.4. https://issues.apache.org/jira/browse/HIVE-12357 ... View more

also as a good practice, since you achieved the intended result, please accept one of the answers you see fit to close out the thread. ... View more

yes correct, but if table is already external, then I don't see a point in need to sqoop data out of Hive as you can just work with those files directly. ... View more

unless you're using orc, the files you use for Hive are in their raw form. You can just browse to /apps/hive/warehouse dir and look at them. No need to use sqoop. ... View more

HWX does not support upgrade of individual components except for Spark and that's a recent change. You need to upgrade the whole stack, Phoenix 4.6 is not supported by HWX yet, that said, nothing stops you from upgrading Phoenix yourself. Refer to the Phoenix docs for upgrade information https://phoenix.apache.org/upgrading.html Phoenix 4.6 has been out for some time and 4.7 is going to be out really soon, if you don't want to lose support with HWX, I suggest you wait for the next maintenance release and/or major release and 4.6 should be included. ... View more

THP on Centos7 is not a big deal but no biggie, you should turn swappinness to 0. I have a script with some important parameters, take a look. https://github.com/dbist/scripts/blob/master/administration/hbase.sh also check for number of open files. ... View more

you can always check the release notes for what's supported and added but so far I don't see support for Spark and Pig, there is work in integrating Sqoop with Atlas. Here are the latest Release Notes http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-... ... View more

@Hani Al-Shater can you paste the command you use to execute the topology and paste the supervisor logs? ... View more