[jira] [Commented] (SENTRY-1894) Update field size in package.jdo for dataNucleus to match size in sql

["Hadoop QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SENTRY-1894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16135783#comment-16135783 ] 

Hadoop QA commented on SENTRY-1894:
-----------------------------------

Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12882963/SENTRY-1894.001.patch against master.

{color:red}Overall:{color} -1 due to 3 errors

{color:red}ERROR:{color} mvn test exited 1
{color:red}ERROR:{color} Failed: org.apache.sentry.provider.db.tools.TestSentryShellHive
{color:red}ERROR:{color} Failed: org.apache.sentry.provider.db.tools.TestSentryShellHive

Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/3163/console

This message is automatically generated.

> Update field size in package.jdo for dataNucleus to match size in sql
> ---------------------------------------------------------------------
>
>                 Key: SENTRY-1894
>                 URL: https://issues.apache.org/jira/browse/SENTRY-1894
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>    Affects Versions: 2.0.0
>            Reporter: Na Li
>            Assignee: Na Li
>         Attachments: SENTRY-1894.001.patch
>
>
> The unique index (`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`,`ACTION`,`WITH_GRANT_OPTION`)" in `SENTRY_DB_PRIVILEGE` at package.jdo file is too large. When running datanucleus schema tool, it complains "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes"
> The size of the fields `SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME` are 4000, but the corresponding size in sql is only 128.
> We should match the size defined in package.jdo to what's in sql script, and remove `URI` from being part of the unique id. After those change, the datanucleus schema tool finishes successfully with command "mvn datanucleus:schema-create -X -e"



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)