hive笔记

妖狐艹你老母 2023-03-03 11:13 50阅读 0赞

## 1、显示数据库，列名 ##

Apache

<property>
    	<name>hive.cli.print.header</name>
    	<value>true</value>
    </property>
    
    <property>
    	<name>hive.cli.print.current.db</name>
    	<value>true</value>
    </property>

HDP

hive-site中修改为true

![format_png][]

custom hive-site中添加一列属性

![format_png 1][] ![format_png 2][]

## 2、hive中注释乱码 ##

![format_png 3][]

（1）修改表字段注解和表注解

alter table COLUMNS_V2 modify column COMMENT varchar(4000) character set utf8;
    alter table TABLE_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;

（2）修改分区字段注解

alter table PARTITION_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8 ;
    alter table PARTITION_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8;

（3）修改索引注解

alter table INDEX_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;

（4）修改metastore数据库连接

apache

hive-site

<property>
    	  <name>javax.jdo.option.ConnectionURL</name>
    	  <value>jdbc:mysql://hadoop100:3306/metastore?createDatabaseIfNotExist=true</value>
    	  <description>JDBC connect string for a JDBC metastore</description>
    	</property>

hdp

![format_png 4][]

注意：要重新创建表

![format_png 5][]

[format_png]: /images/20230208/0a25ffef568849abac51188d674da248.png
[format_png 1]: http://imgconvert.csdnimg.cn/aHR0cDovL2h5dW5iYXIudG9wL3dwLWNvbnRlbnQvdXBsb2Fkcy8yMDIwLzA3LyVFNSU5QiVCRSVFNyU4OSU4Ny0xNTMucG5n?x-oss-process=image/format,png
[format_png 2]: /images/20230208/83431dbb6ccb4ca7901ec7ab0c092ab9.png
[format_png 3]: /images/20230208/ec88d3378dc24739bdc910800edeaa27.png
[format_png 4]: /images/20230208/e5de5e81914540cc8626a6fc36e001db.png
[format_png 5]: /images/20230208/86adab0242b14d4388688eb267824cbe.png