@Zack Riesland You should be able to get this done (as a tab separated) by doing the following: hive -e 'use <database>; select * from <table>;' > /tmp/<file>.csv ... View more

I think you need check the folder access. There had two place you need check: `/var/log/hbase` and `/hadoop/hbase/local/jars/tmp/`. Also I had chown those folders under hbase the region start success. Try it and congratulate。 ... View more

Can we check if below job failed. /usr/hdp/current/phoenix-client/bin/sqlline.py zk_host:2181:/hbase-unsecure /path/to/my_script.sql > out.txt Even though it fails I am getting $? as zero. Is there any way to check the same. ... View more

Chris, I added this fs.s3.buffer.dir property under "custom hdfs-site" under the hdfs properties in Ambari - the same place where I added my aws credentials (which are working). But it doesn't appear to be "Sticking". I pointed the property at "/home/s3_temp", which I created on the edge node where I'm testing the distcp tool. But I never see data in there, and my uploads continue to fail with the same errors as before. Any ideas? cc @Chris Nauroth ... View more

I didn't understand the difference between s3 and s3n. This link helped: http://stackoverflow.com/questions/10569455/difference-between-amazon-s3-and-s3n-in-hadoop Thanks again. ... View more

Good to know. Would you mind to mark this answer as solved? Thanks @Zack Riesland ... View more

How about check the last contact in those servers. ... View more

Equivalent lookup for ambari.properties file. http://<ambari_server>:8080/api/v1/services/AMBARI/components/AMBARI_SERVER?fields=RootServiceComponents/properties ... View more

I would be interested in why hive.exec.reducers.max defaults to 1009, and what influences an appropriate choice for this setting. I couldn't find any detail on it in either of the linked articles. ... View more

If you want to investigate this more there is a Hadoop streaming example in the Hadoop the definitive guide book , which might be of help. ( they get a list of files and then spin of reducers based of the files and run some Linux commands in the Reducers. You could essentially do anything you want. ) ... View more