apache zeppelin和hive-创建后找不到临时表

hpxqektj  于 2021-05-29  发布在  Hadoop
关注(0)|答案(0)|浏览(387)

我正在尝试在配置单元中创建一个临时表,如下所示:

  1. %hive
  2. create temporary table tmp3 as select field1, field2 from mytable

当我想查看表中的内容时

  1. %hive
  2. select * from tmp3

我明白了

  1. Error while compiling statement: FAILED: SemanticException [Error 10001]:
  2. Line 1:14 Table not found 'tmp3'
  3. class org.apache.hive.service.cli.HiveSQLException
  4. org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:258)
  5. org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:244)
  6. org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:247)
  7. org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:356)
  8. org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442)
  9. org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
  10. org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
  11. org.apache.zeppelin.scheduler.Job.run(Job.java:176)
  12. org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
  13. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  14. java.util.concurrent.FutureTask.run(FutureTask.java:266)
  15. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  16. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  17. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  18. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  19. java.lang.Thread.run(Thread.java:745)

但是,如果我再次尝试创建临时表,我将得到

  1. Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Temporary table default.tmp3 already exists)
  2. class java.sql.SQLException
  3. org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:283)
  4. org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:356)
  5. org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442)
  6. org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
  7. org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
  8. org.apache.zeppelin.scheduler.Job.run(Job.java:176)
  9. org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
  10. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  11. java.util.concurrent.FutureTask.run(FutureTask.java:266)
  12. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  13. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  14. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  15. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  16. java.lang.Thread.run(Thread.java:745)

因此,表的创建似乎以某种方式完成了,但我不知道在哪里。如果我尝试,table就不会出现 show tables in default .
有关信息:
hive.exec.temporary.table.storage=默认值
hive.scratch.dir.permission=700
hive.exec.local.scratchdir=/tmp/hive
hive.exec.scratchdir=/tmp/hive
我正在使用 hdp 2.5.0.0-1245 提前谢谢。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题