sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ruiming Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SENTRY-260) Add support to use DB2 as database for sentry metastore
Date Thu, 19 Jun 2014 00:23:25 GMT

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

Ruiming Zhou commented on SENTRY-260:
-------------------------------------

Your DB2 (express) version  may be ok. It is the database set up. the default pagesize can
be specified at database creation time. If they are not, a default page size (4k) will be
taken for the database by DB2, which is too small in this sentry schema because it use a previllege_name
column has size 4k for index, that required a big pagesize more than the default.

example to specify the pagesize for database, which I use 32K pagesize.

CREATE DATABASE TEST1C AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US COLLATE USING
IDENTITY PAGESIZE 32 K

However, we are thinking about including the bufferpool and pagesize DDL in the db2 script
instead of using the default one. Will add another patch later once I have it. 

> Add support to use DB2  as database for sentry metastore
> --------------------------------------------------------
>
>                 Key: SENTRY-260
>                 URL: https://issues.apache.org/jira/browse/SENTRY-260
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.4.0
>            Reporter: Ruiming Zhou
>            Assignee: Ruiming Zhou
>              Labels: newbie
>             Fix For: 1.4.0
>
>         Attachments: SENTRY-260-1.patch, SENTRY-260.patch
>
>
> Currently Sentry supports derby, mysql, oracle, postgres to back its Metastore.  We like
to have DB2 database to be supported.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message