Hadoop版本:2.8.4
HBase版本:2.1.0
Hive版本:2.3.3
Hadoop HA 与 HBase HA配置完成,且可正常使用。
Hive配置完成后,使用Hive Shell 可以查询、创建数据库,也可以创建表,但是在表中插入数据失败,详细如下所示:
Hive日志如下所示:
以下是 Hive日志的文件信息
2018-09-05T15:29:52,851 INFO [main] conf.HiveConf: Using the default value passed in for log id: 8edc6120-e6f3-477f-bf26-52e0e2fa36db
2018-09-05T15:29:52,851 INFO [main] session.SessionState: Updating thread name to 8edc6120-e6f3-477f-bf26-52e0e2fa36db main
2018-09-05T15:29:52,852 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] ql.Driver: Compiling command(queryId=hadoop_20180905152952_4e1d12b8-06cb-4a91-9fdf-7ca3fafb0051): insert into phil.userinfo values ("abc1", "21")
2018-09-05T15:29:52,854 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Starting Semantic Analysis
2018-09-05T15:29:52,907 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Completed phase 1 of Semantic Analysis
2018-09-05T15:29:52,908 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Get metadata for source tables
2018-09-05T15:29:52,908 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Get metadata for subqueries
2018-09-05T15:29:52,908 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Get metadata for destination tables
2018-09-05T15:29:52,919 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Completed getting MetaData in Semantic Analysis
2018-09-05T15:29:52,960 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Get metadata for source tables
2018-09-05T15:29:52,960 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Get metadata for subqueries
2018-09-05T15:29:52,961 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: Get metadata for destination tables
2018-09-05T15:29:52,976 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] common.FileUtils: Creating directory if it doesn't exist: hdfs://namenodeHaclusterDev/user/hive/warehouse/phil.db/userinfo/.hive-staging_hive_2018-09-05_15-29-52_852_2117193599271128337-1
2018-09-05T15:29:52,996 INFO [8edc6120-e6f3-477f-bf26-52e0e2fa36db main] parse.CalcitePlanner: CBO Succeeded; optimized