[
https://issues.apache.org/jira/browse/HIVE-1902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12981572#action_12981572
]
He Yongqiang commented on HIVE-1902:
------------------------------------
Also forgot this one:
DROP TABLE IF EXISTS `PART_COL_PRIVS`;
CREATE TABLE `PART_COL_PRIVS` (
`PART_COLUMN_GRANT_ID` bigint(20) NOT NULL,
`COLUMN_NAME` varchar(128) character set latin1 collate latin1_bin default
NULL,
`CREATE_TIME` int(11) NOT NULL,
`GRANT_OPTION` smallint(6) NOT NULL,
`GRANTOR` varchar(128) character set latin1 collate latin1_bin default NULL,
`GRANTOR_TYPE` varchar(128) character set latin1 collate latin1_bin default
NULL,
`PART_ID` bigint(20) default NULL,
`PRINCIPAL_NAME` varchar(128) character set latin1 collate latin1_bin default
NULL,
`PRINCIPAL_TYPE` varchar(128) character set latin1 collate latin1_bin default
NULL,
`PART_COL_PRIV` varchar(128) character set latin1 collate latin1_bin default
NULL,
PRIMARY KEY (`PART_COLUMN_GRANT_ID`),
KEY `PART_COL_PRIVS_N49` (`PART_ID`),
KEY `PARTITIONCOLUMNPRIVILEGEINDEX`
(`PART_ID`,`COLUMN_NAME`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`PART_COL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`),
CONSTRAINT `PART_COL_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES
`PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Please refer to the wiki page link for updates.
> create script for the metastore upgrade due to HIVE-78
> ------------------------------------------------------
>
> Key: HIVE-1902
> URL: https://issues.apache.org/jira/browse/HIVE-1902
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Namit Jain
> Assignee: He Yongqiang
> Priority: Blocker
> Fix For: 0.7.0
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
