@Jitendra Yadav - yes this has works thanks! This is how the process looks like when I run ps: root 17484 1 99 13:47 pts/0 00:00:59 /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.65-0.b17.el6_7.x86_64/bin/java -server -XX:NewRatio=3 -XX:+UseConcMarkSweepGC -XX:-UseGCOverheadLimit -XX:CMSInitiatingOccupancyFraction=60 -Dsun.zip.disableMemoryMapping=true -Xms512m -Xmx2048m -Djava.security.auth.login.config=/etc/ambari-server/conf/krb5JAASLogin.conf -Djava.security.krb5.conf=/etc/krb5.conf -Djavax.security.auth.useSubjectCredsOnly=false -Djava.library.path=/usr/hdp/current/hadoop-client/lib/native -cp /etc/ambari-server/conf:/usr/lib/ambari-server/*:/usr/share/java/postgresql-jdbc.jar org.apache.ambari.server.controller.AmbariServer It seems setting -Djava.library.path is the only thing required - I have subsequently remove the snappy link in /usr/lib/ambari-server/ and can confirm it still works. ... View more

I saw this error today. Apparently my hdfs file was in .csv but my table structure was in ORC. ... View more

You can try as below li <- read.table(textConnection(c), sep = ","); ... View more

hi: yuo are right now just tnere is a base file 🙂 many thanks ... View more

I know this is the silly question but where can you find the location. I am not able to trace back @srai ... View more

@Paul Schuliger - Are you sure you are trying with port 2222? Please have a look at - https://github.com/hortonworks/tutorials/blob/hdp/tutorials/hortonworks/learning-the-ropes-of-the-hortonworks-sandbox/tutorial.md ... View more

The Optimized Row Columnar (ORC) file format provides a highly efficient way to store Hive data. It just like a File to store group of rows called stripes, along with auxiliary information in a file footer. It just a storage format, nothing to do with ORC/Spark. ... View more

@Roberto Sancho Great.!! :), please accept the answer which helped you to close this thread. ... View more

Thanks you very much for your reply. Based on your suggestions, I have added the following into hive-env.sh through Ambari Hive configuration interface: export HIVE_AUX_JARS_PATH=<my jar full path> and then restart the hive. Now it works as expected in both Hive console and Hue BeesWax UI. Many thanks again. ... View more

Hi @Mamta Chawla, Please feel free to accept an answer which helped you, so that this thread can be closed. Thanks ... View more