Hive 不显示表格 [英] Hive is not showing tables
问题描述
我是 Hadoop 和 Hive 世界的新手.
I am new to Hadoop and Hive world.
我有一个奇怪的问题.当我在 hive prompt 上工作时.我创建了几个表,而 hive 正在显示这些表.
I have a strange problem. When I was working on hive prompt. I have created few tables and hive was showing those tables.
退出 Hive 会话后,当我再次启动 Hive 终端时显示表格";没有显示任何表格!.我可以在 HDFS 的/user/hive/warehouse"中看到表.
After exiting Hive session when I am again starting Hive terminal "show tables;" is not showing any table!. I can see tables in '/user/hive/warehouse' in HDFS.
我怎么了.你能帮我解决这个问题吗?
What is wrong am I doing. Can you please help me on this?
推荐答案
BalduZ 是对的.在 $HIVE_HOME/conf/hive-site.xml 中设置
BalduZ is right . set this in $HIVE_HOME/conf/hive-site.xml
属性名称 = javax.jdo.option.ConnectionURL
property name = javax.jdo.option.ConnectionURL
属性值 = jdbc:derby:;databaseName=/home/youruser/hive_metadata/metastore_db;create=true
property value = jdbc:derby:;databaseName=/home/youruser/hive_metadata/metastore_db;create=true
下次您可以从任何目录位置运行 hive.这将解决您的问题.
Next time onwards you can run hive from any dir location. This will solve your problem.
这篇关于Hive 不显示表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!