Re: Cannot create external table on S3; class S3AFileSystem not found

2017-12-10 Thread Scott Halgrim
Furcy: Thank you. So. Much. On Dec 10, 2017, 4:34 AM -0800, Furcy Pin , wrote: > Hi Scott, > > I ran into similar issues before. > > > I think that you need to do two things to enable Hive access to s3: > > > 1. add the following jars to your Hive classpath, for instance by using > symlinks > > l

Re: Cannot create external table on S3; class S3AFileSystem not found

2017-12-10 Thread Furcy Pin
Hi Scott, I ran into similar issues before. I think that you need to do two things to enable Hive access to s3: 1. add the following jars to your Hive classpath, for instance by using symlinks ln -s $HADOOP_HOME/share/hadoop/tools/lib/aws-java-sdk-1.7.4.jar $HIVE_HOME/lib/. ln -s $HADOOP_HOME

Re: Cannot create external table on S3; class S3AFileSystem not found

2017-12-09 Thread Scott Halgrim
Thanks, Elliott. I’m using Ubuntu 14.04.5 LTS, Hadoop 2.9.0, and Hive 2.3.2. I hadn’t had a CLASSPATH environment variable set, but I did just set it to have that jar on it and I get the same answer. I don’t really have the installation in “/path/to/…” but everything else in the path is correc

Re: Cannot create external table on S3; class S3AFileSystem not found

2017-12-09 Thread Elliot West
Which distribution are you using? Do you have hadoop-aws on the class path? Is ‘/path/to/hadoop/install’ a literal value or a placeholder that you’ using for the actual location? Cheers, Elliot. On Sat, 9 Dec 2017 at 00:08, Scott Halgrim wrote: > Hi, > > I’ve been struggling with this for a fe