Member since
10-25-2016
12
Posts
2
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5800 | 11-04-2016 10:23 AM | |
5221 | 10-27-2016 09:01 AM |
02-14-2018
12:57 PM
Resolved, by deleting all tables in sentry database in MySQL and then recreating them from Cloudera Manager, and this time by logging into database as root instead of cm user.
... View more
11-04-2016
10:23 AM
1 Kudo
I finaly solved the problem! probably was a problem of creating tables on mysql. to solve this error: Error: Index column size too large. The maximum column size is 767 bytes It's necessary to create the sentry tables using ROW_FORMAT = DYNAMIC. In the cloudera version CDH 5.7.1.1 in the scritps /opt/cloudera/parcels/CDH-5.7.1-1.cdh5.7.1.p0.11/lib/sentry/scripts/sentrystore/upgrade/sentry-mysql-1.5.0.sql the ROW_FORMAT option is omitted, the default is COMPACT. I must use the scripts of version CDH 5.7.0.1 /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p1464.1349/lib/sentry/scripts/sentrystore/upgrade/sentry-mysql-1.5.0.sql where the option ROW_FORMAT = DYNAMIC is explicit. With this script i created correctly the sentry table. After I restart the service i have created the role on HUE and beeline without any problem. My only doubt is, why cdh 5.7.1.1 doesn't contain the option ROW_FORMAT?
... View more