What are the minor problems encountered in the use of Hive

This article is to share with you what are several minor problems encountered in the use of Hive, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Without saying much, let's take a look at it.

1. Use commands such as show tables; in Hive to report an error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

Solution: execute alter database hive character set latin1 in the hive database in mysql

Change the character set of the hive Metabase and the problem can be solved! But at this time, if you build a table with Chinese in it, you will make a mistake.

2. Sqoop cannot import data into Hive. Error: Warning: / usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation.

Solution: just remove the configuration of HBase and ZooKeeper from the configuration file.

Remove HBASE and ZOOKEEPER from SQOOP_HOME/bin/configure-sqoop.

3. If the data Times is wrong in Sqoop and the prompt file already exists, it must exist at this time. You can look in HDFS. There is usually one in the / user/$ {user_name} directory.

If the-- create-hive-table option is used, both the file and the table must be cleared.

4. When LOAD, be sure to specify the data type, otherwise the default ByteArray cannot be converted to String5. The jdbc driver forgot to copy to the lib directory

6. Log at show tables: MetaException (message:Version information not found in metastore. )

Set hive.metastore.schema.verification to false

Hive.metastore.schema.verification false above are some of the minor problems encountered in the use of Hive. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.