[ https://issues.apache.org/jira/browse/RANGER-341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15240719#comment-15240719 ]
Pradeep Agrawal commented on RANGER-341:
----------------------------------------
request_data and request_path columns size has been changed to 4000 with commit.
https://github.com/apache/incubator-ranger/commit/23482defe710346dc0c833caeac927f8c241659d
This issue has been fixed in 0.5 and later version of Ranger
> request_data and request_path columns are short
> -----------------------------------------------
>
> Key: RANGER-341
> URL: https://issues.apache.org/jira/browse/RANGER-341
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 0.4.0, 0.5.0, 0.4.1
> Reporter: Kwangwoo Kim
> Priority: Minor
>
> If hiveql is too long (exceeds 2000 characters), the access audit is not inserted into xa_access_audit table properly. In fact, it rarely happens in ordinary usage of Hive but sometimes when making a partitioned table, which has many columns, or when query string has a lot of spaces, the issue would occur.
> One of the hdfs side access audit example is as below:
> {code:javascript}
> {"resource":"foo/bar","resType":"@table","reqData":"create table if not exists foo.bar \n\t\t ( \n\t\t\tsday string\n\t\t , \n\t\t\tsday_cd string\n\t\t , \n\t\t\tsday_nm string\n\t\t , \n\t\t\tmonth_cd string\n\t\t , \n\t\t\tmonth_wk string\n\t\t , \n\t\t\tyear_wk string\n\t\t , \n\t\t\tyear_wk_ori string\n\t\t , \n\t\t\tquater_cd string\n\t\t , \n\t\t\thalf_cd string\n\t\t , \n\t\t\tyear_cd string\n\t\t , \n\t\t\tyear_nm string\n\t\t , \n\t\t\thalf_nm string\n\t\t , \n\t\t\tquater_nm string\n\t\t , \n\t\t\tyear_wk_nm string\n\t\t , \n\t\t\tmonth_nm string\n\t\t , \n\t\t\tmonth_wk_nm string\n\t\t , \n\t\t\tday_cd string\n\t\t , \n\t\t\tday_nm string\n\t\t , \n\t\t\tweek_nm string\n\t\t , \n\t\t\tweek_cd string\n\t\t , \n\t\t\tholiday_yn string\n\t\t , \n\t\t\tholiday_desc string\n\t\t , \n\t\t\tworking_day int\n\t\t , \n\t\t\tpace_day double\n\t\t , \n\t\t\tpace_month_acc double\n\t\t , \n\t\t\tpace_year_acc double\n\t\t , \n\t\t\tpace_month_tot double\n\t\t , \n\t\t\tpace_year_tot double\n\t\t , \n\t\t\tevent_yn string\n\t\t , \n\t\t\tevent_desc string\n\t\t , \n\t\t\tload_dt string\n\t\t ) \n\t\t \n\t\t \n\t\t \n\t\tROW FORMAT SERDE\n\t\t\t\u0027org.apache.hadoop.hive.ql.io.orc.OrcSerde\u0027\n\t\tSTORED AS INPUTFORMAT\n\t\t\t\u0027org.apache.hadoop.hive.ql.io.orc.OrcInputFormat\u0027\n\t\tOUTPUTFORMAT\n\t\t\t\u0027org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat\u0027\n\t\t \n\t\t \n\t\t \n\t\tTBLPROPERTIES (\n\t\t\t\u0027orc.compress\u0027 \u003d \u0027SNAPPY\u0027\n\t\t)","reqUser":"xxxx","evtTime":"2015-03-25 13:35:55.802","policy":0,"access":"CREATE","result":1,"enforcer":"xasecure-acl","repoType":3,"repo":"hive_base_repo","sess":"10086e96-e8fd-467f-8161-3cd7497e7476","cliType":"HIVESERVER2","cliIP":"000.000.000.000","action":"CREATETABLE","agentHost":"hostname.domain.net","logType":"RangerAudit","id":"3676d57f-8d70-40eb-b6ab-d9b4fcdfd923"}
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)