Not sure if I'm not using it as expected, but I'm trying to query ranger for a specific policy, and there are thousands of policies http://....:6080/service/public/api/policy?tables=my_test_table&databases=abc&repositoryName=test_hive&repositoryType=hive this does not return anything, so we turned logging at the DB level to see = what queries were being run and we noticed SELECT t0.id AS a1, t0.ADDED_BY_ID AS a2, t0.CREATE_TIME AS a3, t0.description AS a4, t0.guid AS a5, t0.is_audit_enabled AS a6, t0.is_enabled AS a7, t0.name AS a8, t0.policy_type AS a9, t0.resource_signature AS a10, t0.service AS a11, t0.UPDATE_TIME AS a12, t0.UPD_BY_ID AS a13, t0.version AS a14 FROM x_policy t0, x_service_def t2, x_service t1 WHERE (((((1 =3D 1) AND (LOWER(t2.name) =3D 'hive')) AND ((t1.type =3D t2.id) AND (t1.id =3D t0.service))) AND (LOWER(t1.name) =3D 'test_hive')) AND (t1.id =3D t0.service)) ORDER BY t0.id ASC LIMIT 0, 200 My first question is why does it not use all four parameters and just 2 to query? I was then able to find the policy by querying http://....:6080/service/public/api/policy?tables=3Dmy_test_table&databases=abc&repositoryName=test_hive&repositoryType=hive&pageSize=200&starIndex=0 http://....:6080/service/public/api/policy?tables=3Dmy_test_table&databases=abc&repositoryName=test_hive&repositoryType=hive&pageSize=200&startIndex=200 However there is nothing in the response which tells me how many pages there are to query through? Am I missing something? Thanks, We've moved! Please note our new address below. John Mattucci Next Pathway ------------------------------------ 79 Wellington Street West TD South Tower Suite 705, P.O. Box 24 Toronto, ON M5K 1A1 Cell: 647-907-6823 Fax: 416-307-2724 <mailto:mp...@nextpathway.com>jmattu...@nextpathway.com<mailto:jmattu...@nextpathway.com> www.nextpathway.com<http://www.nextpathway.com/> This communication may contain privileged or confidential information. If you are not the intended recipient or received this communication in error, please notify the sender immediately and delete the message and attachments, if any, without copying or disclosing the foregoing.
