Shulou(Shulou.com)05/31 Report--

What are the Hive problems, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

1 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT...

Error when starting Hive:

Caused by: javax.jdo.JDOException: Couldnt obtain a new sequence (unique id): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.NestedThrowables:java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

This problem is caused by improper configuration of hive's metadata store MySQL, which can be resolved as follows:

Mysql > set global binlog_format='MIXED';2 For direct MetaStore DB connections, we don't support retries at the client level.

An error was reported when creating tables in Hive:

Create table years (year string, event string) row format delimited fields terminated by'\ t failed: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException (message:For direct MetaStore DB connections, we don't support retries at the client level.)

This is due to a problem with the character set, so you need to configure the character set of MySQL:

Mysql > alter database hive character set latin1;3 HiveConf of name hive.metastore.local does not exist

The following error occurred when executing the Hive client:

WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

This is due to the fact that the hive.metastore.local property is no longer used in the HIVE version of 0.10 0.11 or later. Just delete this parameter from hive-site.xml.

4 Permission denied: user=anonymous, access=EXECUTE, inode= "/ tmp"

The following error is reported at startup Hive:

(Permission denied: user=anonymous, access=EXECUTE, inode= "/ tmp": hadoop:supergroup:drwx-

This is because Hive does not have the permission to hdfs:/tmp directory, so you can assign permission:

Hadoop dfs-chmod-R 777 / tmp

5 Specified key was too long; max key length is 767bytesHive > CREATE TABLE dummy (value STRING), FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException (message:javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class (es): Specified key was too long; max key length is 767bytescom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767bytes

Solution:

Is it helpful for mysql > alter database hive character set latin1; to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.