hive> list jars; /opt/apache-hive-2.0.1-bin/lib/hadoop-aws-2.7.1.jar /opt/apache-hive-2.0.1-bin/lib/aws-java-sdk-1.7.4.jar hive>
On Tue, Oct 25, 2016 at 4:27 PM, Rajendra Bhat <rajhalk...@gmail.com> wrote: > yes, I have added the jar on hive prompt. > > On Tue, Oct 25, 2016 at 4:25 PM, aft <aft...@gmail.com> wrote: > >> On Tue, Oct 25, 2016 at 6:11 AM, Rajendra Bhat <rajhalk...@gmail.com> >> wrote: >> > Hi, >> > >> > i am getting below error on create extrnal table. I have copied >> > hadoop-aws-2.7.1.jar and aws-java-sdk-1.7.4.jar to hive_home/lib folder. >> > please let me know where should need to place supporting jar.. >> > >> > >> > hive> create external table kv (key int, value string) location >> > 's3a://myntra-datasciences/cip/test'; >> > FAILED: Execution Error, return code 1 from >> > org.apache.hadoop.hive.ql.exec.DDLTask. >> > MetaException(message:java.lang.RuntimeException: >> > java.lang.ClassNotFoundException: Class >> > org.apache.hadoop.fs.s3a.S3AFileSystem not found) >> >> Have you added the jars at hive prompt with "add jar " command? >> >> > >> > -- >> > Thanks and >> > Regards >> > >> > Rajendra Bhat >> > > > > -- > Thanks and > Regards > > Rajendra Bhat > -- Thanks and Regards Rajendra Bhat