You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (Jira)" <ji...@apache.org> on 2022/03/29 18:54:00 UTC
[jira] [Resolved] (HIVE-26027) [Hive] SemanticException Invalid path with ofs/o3fs
[ https://issues.apache.org/jira/browse/HIVE-26027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naveen Gangam resolved HIVE-26027.
----------------------------------
Resolution: Information Provided
> [Hive] SemanticException Invalid path with ofs/o3fs
> ---------------------------------------------------
>
> Key: HIVE-26027
> URL: https://issues.apache.org/jira/browse/HIVE-26027
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: All Versions
> Reporter: Soumitra Sulav
> Assignee: Naveen Gangam
> Priority: Major
>
> Import and export queries fail with ozone schemes i.e. ofs/o3fs.
> *Error stacktrace (also observed with o3fs) :*
> {code:java}
> > export table test to 'ofs://ozone1/ozonestage/hivetest/tmp/testtemptable/';
> going to print operations logs
> printed operations logs
> Getting log thread is interrupted, since query is done!
> Error: Error while compiling statement: FAILED: SemanticException Invalid path only the following file systems accepted for export/import : hdfs,pfile,file,s3,s3a,adl,abfs,abfss,gs (state=42000,code=40000)
> org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException Invalid path only the following file systems accepted for export/import : hdfs,pfile,file,s3,s3a,adl,abfs,abfss,gs
> at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:357)
> at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:343)
> at org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:334)
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:275)
> at org.apache.hive.beeline.Commands.executeInternal(Commands.java:1007)
> at org.apache.hive.beeline.Commands.execute(Commands.java:1217)
> at org.apache.hive.beeline.Commands.sql(Commands.java:1146)
> at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1499)
> at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1357)
> at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1136)
> at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1084)
> at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:546)
> at org.apache.hive.beeline.BeeLine.main(BeeLine.java:528)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:318)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:232)
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException Invalid path only the following file systems accepted for export/import : hdfs,pfile,file,s3,s3a,adl,abfs,abfss,gs
> at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:356)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:207)
> at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:261)
> at org.apache.hive.service.cli.operation.Operation.run(Operation.java:272)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:549)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:535)
> at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:315)
> at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:567)
> at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1557)
> at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1542)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> at org.apache.thrift.server.TServlet.doPost(TServlet.java:83)
> at org.apache.hive.service.cli.thrift.ThriftHttpServlet.doPost(ThriftHttpServlet.java:237)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:791)
> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)
> at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
> at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602)
> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
> at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
> at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
> at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
> at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
> at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
> at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
> at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
> at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
> at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:763)
> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
> at org.eclipse.jetty.server.Server.handle(Server.java:516)
> at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
> at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
> at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
> at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
> at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540)
> at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395)
> at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161)
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
> at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
> at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
> at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
> at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
> at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
> at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: Invalid path only the following file systems accepted for export/import : hdfs,pfile,file,s3,s3a,adl,abfs,abfss,gs
> at org.apache.hadoop.hive.ql.parse.EximUtil.getValidatedURI(EximUtil.java:297)
> at org.apache.hadoop.hive.ql.parse.repl.dump.TableExport$Paths.<init>(TableExport.java:236)
> at org.apache.hadoop.hive.ql.parse.ExportSemanticAnalyzer.analyzeExport(ExportSemanticAnalyzer.java:111)
> at org.apache.hadoop.hive.ql.parse.AcidExportSemanticAnalyzer.analyzeAcidExport(AcidExportSemanticAnalyzer.java:195)
> at org.apache.hadoop.hive.ql.parse.AcidExportSemanticAnalyzer.analyze(AcidExportSemanticAnalyzer.java:73)
> at org.apache.hadoop.hive.ql.parse.RewriteSemanticAnalyzer.analyzeInternal(RewriteSemanticAnalyzer.java:72)
> at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:290)
> at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:221)
> at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:105)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:194)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:614)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:560)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:554)
> at org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:127)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:200)
> ... 51 more
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)