org.apache.hadoop.hive.ql.parse.SemanticException: line 1:17 Path is not legal

[Prashanth R <r....@gmail.com>]

Hi,

I am trying to load data that is in HDFS to the hive table whose data store
is in s3. However, while performing a load operation, i get this error:

org.apache.hadoop.hive.ql.parse.SemanticException: line 1:17 Path is not
legal 'hdfs://<hostname>/output/*': Move from: hdfs://<hostname>/output/*
to: s3://<bucket>/mslog is not valid. Please check that values for params "
default.fs.name" and "hive.metastore.warehouse.dir" do not conflict.
        at
org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.applyConstraints(LoadSemanticAnalyzer.java:155)
        at
org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.analyzeInternal(LoadSemanticAnalyzer.java:211)
        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:125)
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:304)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:379)
        at
org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:114)
        at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:378)
        at
org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:366)
        at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)

If anyone can chime in to help, that will be awesome.



-- 
- Prash