无法查看mysql安装程序中的所有配置单元元存储表

uujelgoq 于 2021-05-29 发布在 Hadoop

关注(0)|答案(1)|浏览(372)

我的机器上有ApacheHive-0.12.0和hadoop-1.2.1版本。并将mysql用于hive metastore。
现在，当我为metastore测试启动show tables时，它只显示20行/表。

// My Environment
mysql> use metastore_db
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_metastore_db    |
+---------------------------+
| BUCKETING_COLS            | 
| CDS                       | 
| COLUMNS_V2                | 
| DATABASE_PARAMS           | 
| DBS                       | 
| PARTITION_KEYS            | 
| SDS                       | 
| SD_PARAMS                 | 
| SEQUENCE_TABLE            | 
| SERDES                    | 
| SERDE_PARAMS              | 
| SKEWED_COL_NAMES          | 
| SKEWED_COL_VALUE_LOC_MAP  | 
| SKEWED_STRING_LIST        | 
| SKEWED_STRING_LIST_VALUES | 
| SKEWED_VALUES             | 
| SORT_COLS                 | 
| TABLE_PARAMS              | 
| TBLS                      | 
| VERSION                   | 
+---------------------------+
20 rows in set (0.06 sec)

为什么我看不到下面所有的table。我需要使用其他配置单元版本吗？请建议。

// Need to see all these tables
mysql> show tables;
+ --------------------------- +
| Tables_in_hive_demo  |
+ --------------------------- +
| BUCKETING_COLS |
| CDS |
| COLUMNS_V2 |
| DATABASE_PARAMS |
| DBS |
| DB_PRIVS |
| GLOBAL_PRIVS |
| IDXS |
| INDEX_PARAMS |
| NUCLEUS_TABLES |
| PARTITIONS |
| PARTITION_EVENTS |
| PARTITION_KEYS |
| PARTITION_KEY_VALS |
| PARTITION_PARAMS |
| PART_COL_PRIVS |
| PART_COL_STATS |
| PART_PRIVS |
| ROLES |
| ROLE_MAP |
| SDS |
| SD_PARAMS |
| SEQUENCE_TABLE |
| SERDES |
| SERDE_PARAMS |
| SKEWED_COL_NAMES |
| SKEWED_COL_VALUE_LOC_MAP |
| SKEWED_STRING_LIST |
| SKEWED_STRING_LIST_VALUES |
| SKEWED_VALUES |
| SORT_COLS |
| TABLE_PARAMS |
| TAB_COL_STATS |
| TBLS |
| TBL_COL_PRIVS |
| TBL_PRIVS |
| TYPES |
| TYPE_FIELDS |
| VERSION |
+ --------------------------- +
39 rowsinset (0.00 sec)

hadoop mysql Hive Metadata metastore

来源：https://stackoverflow.com/questions/31367445/unable-to-view-all-the-hive-metastore-tables-in-mysql-setup

1条答案

按热度按时间

ercv8c1e1#

尝试用可用的sql脚本（在您的例子中是mysql）升级配置单元模式。

mysql> use metastore_db
Database changed

mysql> SOURCE $HIVE_HOME/scripts/metastore/upgrade/mysql/hive-schema-0.12.0.mysql.sql;

mysql> CREATE USER 'dbuser'@'%' IDENTIFIED BY 'dbpassword'; 

mysql> GRANT all on *.* to 'dbuser'@localhost identified by 'dbpassword';

mysql> flush privileges;

现在重新询问你的table。它现在应该显示所有的表了。

mysql> show tables;

赞(0）回复(0）举报 2021-05-30

我来回答

无法查看mysql安装程序中的所有配置单元元存储表

1条答案

相关问题

热门标签

最新问答