Below is one example: https://community.hortonworks.com/questions/41922/hpl-sql-function-creation-issues-in-hive-20.html ... View more

@Joseph Hawkins - You can just have the value as "/grid/hadoop/hdfs/dn,/grid1/hadoop/hdfs/dn" if they are simple directories on the file system. This is the list of directories where the data will be stored. However, if you have Heterogeneous storage (like DISK, SSD, ARCHIVE or RAM_DISK) you would need to append the File URI. Below is a very good article explaining HDFS Metadata Directories: https://hortonworks.com/blog/hdfs-metadata-directories-explained/ ... View more

Below is a blog that talks about SSH tunnel on Windows 10: http://dalaris.com/how-to-create-an-ssh-tunnel-to-a-linux-server-in-windows-10/ ... View more

Zeppelin is an Open source product, so you can use it with any Hadoop distribution: https://zeppelin.apache.org/' On Google there is documentation on how to install Zeppelin on Cloudera etc. Like: http://blog.cloudera.com/blog/2015/07/how-to-install-apache-zeppelin-on-cdh/ ... View more

@Rajesh Balamohan - The below apache jira talks about the issue when Pig on Tez AM use too much memory on a small cluster: https://issues.apache.org/jira/browse/PIG-4948 To resolve this, as mentioned in the jira try setting below properties: Set tez.am.resource.memory.mb to be the same as yarn.scheduler.minimum-allocation-mb the YARN minimum container size. pig.tez.configure.am.memory to true ... View more

Below is a good read: https://hortonworks.com/hadoop-tutorial/using-hive-with-orc-from-apache-spark/ ... View more

@Param NC - There is no way to close a question. Once, you have found a suitable answer to a question, you can Accept the answer. However, there is an option to Unfollow the question (see screenshot), resulting in not receiving any further communication from that question. Hope this helps. ... View more