Member since
11-18-2018
2
Posts
0
Kudos Received
0
Solutions
11-18-2018
09:05 AM
thanks for replying,i will change the version
... View more
11-18-2018
08:59 AM
when i exec mysql> source /var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql; then i found one table cannot be created in mysql 8.0.3 CREATE TABLE members ( member_id INTEGER,
group_id INTEGER NOT NULL, user_id INTEGER NOT NULL, CONSTRAINT PK_members PRIMARY KEY (member_id), CONSTRAINT FK_members_group_id FOREIGN KEY (group_id) REFERENCES groups (group_id), CONSTRAINT FK_members_user_id FOREIGN KEY (user_id) REFERENCES users (user_id), CONSTRAINT UNQ_members_0 UNIQUE (group_id, user_id)); error: ERROR 1064 (42000): 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 'groups (
group_id INTEGER,
principal_id BIGINT NOT NULL,
group_name VARCHA' at line 1
ERROR 1064 (42000): 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 'groups (group_id),
CONSTRAINT FK_members_user_id FOREIGN KEY (user_id) REFEREN' at line 6 please tell me how should i change the syntax,thanks
... View more
Labels:
- Labels:
-
Apache Ambari