1. 在hvie关联hbase创建外部表时报错:
hive> CREATE EXTERNAL table dmp_user_register(key string,address string,gpsx string,gpsy string,loginid string,nettype string,runmode string,apkversion string,channel string,city string,coolacount string, > cpbversion string,hardware string,imei string,imsi string,logintime string,meid string,netip string,online string,operator string,phonenum string,pkgname string,product string,province string,registertime string,sdkver string, > sn string,state string,vercode string) > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' > WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:addr,cf:gpsx,cf:gpsy,cf:id,cf:nt,cf:rm,cf:av,cf:ch,cf:ct,cf:cy,cf:cpb,cf:hdv,cf:imei,cf:imsi,cf:lgt, > cf:meid,cf:ip,cf:ol,cf:op,cf:ph,cf:pkg,cf:md,cf:prv,cf:rt,cf:sdk,cf:sn,cf:st,cf:vc") > TBLPROPERTIES ("hbase.table.name" = "dmp_user_register"); FAILED: Error in metadata: MetaException(message:Column Family cf is not defined in hbase table dmp_user_register) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
解决:问题在hbase.columns.mapping子句中出现了空格和换行等不可见字符,本例中就是出现了换行符造成的。把hbase.columns.mapping后面的字段映射放在一行无空格等特殊字符即可。
相关推荐
1、内容概要:Hadoop+Spark+Hive+HBase+Oozie+Kafka+Flume+Flink+Elasticsearch+Redash等大数据集群及组件搭建指南(详细搭建步骤+实践过程问题总结)。 2、适合人群:大数据运维、大数据相关技术及组件初学者。 3、...
jdk1.8.0_131、apache-zookeeper-3.8.0、hadoop-3.3.2、hbase-2.4.12 mysql5.7.38、mysql jdbc驱动mysql-connector-java-8.0.8-dmr-bin.jar、 apache-hive-3.1.3 2.本文软件均安装在自建的目录/export/server/下 ...
全套的Hadoop+Hbase+Spark+Hive搭建指导手册
HADOOP+HBASE+HIVE整合工程和文档
Hadoop+ZooKeeper+HBase+hive(HQL)安装步骤
hadoop2.2+hbase0.96+hive0.12安装整合详细高可靠文档及经验总结
Centos+Hadoop+Hive+HBase
hadoop+hbase+hive集群搭建
七月在线七月在线## Note, this file is written by cloud-init on first boot of an instance
Hadoop+HBase+Hive+lucene分布式搜索引擎分析系统
Hadoop+Zookeeper+Hbase+Hive部署
从零开始hadoop+zookeeper+hbase+hive集群安装搭建,内附详细配置、测试、常见error等图文,按照文档一步一步搭建肯定能成功。(最好用有道云打开笔记)
redhat 6.4 hadoop2.7+hbase1.0+hive1.2+zookeeper3.4.6安装配置, ntp配置
Hadoop2.2.0+HBase.96+Hive0.12简单集群环境的搭建
hadoop + zookeeper +hive + hbase安装学习共12页word资料.pdf
Docker(Hadoop_3.3.1+HBase_2.4.16+Zookeeper_3.7.1+Hive_3.1.3 )配置文件 搭建集群环境
hadoop+spark+hive Linux centos大数据集群搭建,简单易懂,从0到1搭建大数据集群
hadoop+hive+hbase在线装,超级简单
Hadoop hbase hive sqoop集群环境安装配置及使用文档
用于生产环境的hadoop2.2.0和hbase0.96.2、hive0.12的集成安装 经过测试环境