1. 아래와 같은 에러 발생 시
1 2 | FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 | cs |
2. 최신 버전의 드라이버로 갱신
1 2 3 4 5 6 7 8 9 10 11 12 | $ wget http://repo.maven.apache.org/maven2/mysql/mysql-connector-java/6.0.6/mysql-connector-java-6.0.6.jar --2017-10-16 09:30:49-- http://repo.maven.apache.org/maven2/mysql/mysql-connector-java/6.0.6/mysql-connector-java-6.0.6.jar Resolving repo.maven.apache.org (repo.maven.apache.org)... 151.101.24.215 Connecting to repo.maven.apache.org (repo.maven.apache.org)|151.101.24.215|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 2001778 (1.9M) [application/java-archive] Saving to: ‘mysql-connector-java-6.0.6.jar’ mysql-connector-java-6. 100%[============================>] 1.91M 414KB/s in 8.6s 2017-10-16 09:30:58 (227 KB/s) - ‘mysql-connector-java-6.0.6.jar’ saved [2001778/2001778] | cs |
* 기존의 connector.jar 파일을 대체하고 서비스 재기동을 합니다.
'Big Data Platform > Hive' 카테고리의 다른 글
| hive 내장 집계 함수 (0) | 2017.10.16 |
|---|---|
| [경고] Establishing SSL connection without server's identity verification is not recommended. (0) | 2017.10.16 |
| 에러 The server time zone value 'KST' is unrecognized or represents more than one time zone (0) | 2017.10.16 |
| 에러 Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient (0) | 2017.10.16 |
| Hive & MySQL 환경 구축 (hadoop 완전 분산형) (0) | 2017.10.13 |