Installer Hive on Mac

The Apache Hive ™ data warehouse software facilitates querying and managing large datasets residing in distributed storage. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL.

---

Introduction Hive:

Lien1

Installation:

Tutorial 1(cn)     Tutorial 2

hive explication: values__tmp__table__1

Tutorial 1

Problème rencontré:

Exception in thread "main"java.lang.RuntimeException: 
java.lang.IllegalArgumentException:java.net.URISyntaxException: 
Relative path in absolute URI:${system:java.io.tmpdir%7D/$%7Bsystem
:user.name%7D atorg.apache.hadoop.hive.ql.session.SessionState.start
R1 R2


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.)
R1

Failed with exception java.io.IOException:java.lang.IllegalArgument
Exception: java.net.URISyntaxException: Relative path in absolute URI:
//${system:user.name}-->${user.name}
R1

hive drop table命令没反应
mysql数据库字符集问题，解决办法把之前的库删掉，重新创建一个，
并修改字符集为latin1, 
R1: alter database hive character set latin1;