You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Pradeep Agrawal <pr...@freestoneinfotech.com> on 2017/04/19 09:23:03 UTC
Review Request 58526: RANGER-1522 : Update consolidated db schema
script for SQLServer DB flavor to reduce execution time
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58526/
-----------------------------------------------------------
Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
Bugs: RANGER-1522
https://issues.apache.org/jira/browse/RANGER-1522
Repository: ranger
Description
-------
**Problem Statement:** Script created for RANGER-1401 need to be created for RANGER 0.7 version and script should be updated without or minimum number of GO statements.
**Proposed Solution :** Create script for Ranger-0.7.0 version in security-admin/db/sqlserver/optimized/0.7.0 location and security-admin/db/sqlserver/optimized/current location.
Diffs
-----
security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql 13be7da
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION
Diff: https://reviews.apache.org/r/58526/diff/1/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
2) From a MSSQL Client tool executed security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal
Re: Review Request 58526: RANGER-1522 : (Ranger-0.7 branch) Update
consolidated db schema script for SQLServer DB flavor to reduce execution
time
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58526/#review173203
-----------------------------------------------------------
Ship it!
Ship It!
- Velmurugan Periasamy
On April 26, 2017, 5:06 p.m., Pradeep Agrawal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/58526/
> -----------------------------------------------------------
>
> (Updated April 26, 2017, 5:06 p.m.)
>
>
> Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-1522
> https://issues.apache.org/jira/browse/RANGER-1522
>
>
> Repository: ranger
>
>
> Description
> -------
>
> **Problem Statement:** Script created for RANGER-1401 need to be created for RANGER 0.7 version and script should be updated without or minimum number of GO statements.
>
> **Proposed Solution :** Create script for Ranger-0.7.0 version in security-admin/db/sqlserver/optimized/0.7.0 location and security-admin/db/sqlserver/optimized/current location.
>
>
> Diffs
> -----
>
> security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql 13be7da
> security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION
>
>
> Diff: https://reviews.apache.org/r/58526/diff/2/
>
>
> Testing
> -------
>
> 1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
> 2) From a MSSQL Client tool executed security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file on database created in previous step.
> 3) Executed DB setup and java patches execution command.
>
> **Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
> **Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
>
>
> Thanks,
>
> Pradeep Agrawal
>
>
Re: Review Request 58526: RANGER-1522 : (Ranger-0.7 branch) Update
consolidated db schema script for SQLServer DB flavor to reduce execution
time
Posted by Gautam Borad <gb...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58526/#review173217
-----------------------------------------------------------
Ship it!
Ship It!
- Gautam Borad
On April 26, 2017, 5:06 p.m., Pradeep Agrawal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/58526/
> -----------------------------------------------------------
>
> (Updated April 26, 2017, 5:06 p.m.)
>
>
> Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-1522
> https://issues.apache.org/jira/browse/RANGER-1522
>
>
> Repository: ranger
>
>
> Description
> -------
>
> **Problem Statement:** Script created for RANGER-1401 need to be created for RANGER 0.7 version and script should be updated without or minimum number of GO statements.
>
> **Proposed Solution :** Create script for Ranger-0.7.0 version in security-admin/db/sqlserver/optimized/0.7.0 location and security-admin/db/sqlserver/optimized/current location.
>
>
> Diffs
> -----
>
> security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql 13be7da
> security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION
>
>
> Diff: https://reviews.apache.org/r/58526/diff/2/
>
>
> Testing
> -------
>
> 1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
> 2) From a MSSQL Client tool executed security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file on database created in previous step.
> 3) Executed DB setup and java patches execution command.
>
> **Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
> **Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
>
>
> Thanks,
>
> Pradeep Agrawal
>
>
Re: Review Request 58526: RANGER-1522 : (Ranger-0.7 branch) Update
consolidated db schema script for SQLServer DB flavor to reduce execution
time
Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58526/
-----------------------------------------------------------
(Updated April 26, 2017, 5:06 p.m.)
Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
Changes
-------
Updated patch after RANGER-1481 and RANGER-1490 commit.
Bugs: RANGER-1522
https://issues.apache.org/jira/browse/RANGER-1522
Repository: ranger
Description
-------
**Problem Statement:** Script created for RANGER-1401 need to be created for RANGER 0.7 version and script should be updated without or minimum number of GO statements.
**Proposed Solution :** Create script for Ranger-0.7.0 version in security-admin/db/sqlserver/optimized/0.7.0 location and security-admin/db/sqlserver/optimized/current location.
Diffs (updated)
-----
security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql 13be7da
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION
Diff: https://reviews.apache.org/r/58526/diff/2/
Changes: https://reviews.apache.org/r/58526/diff/1-2/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
2) From a MSSQL Client tool executed security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal
Re: Review Request 58526: RANGER-1522 : (Ranger-0.7 branch) Update
consolidated db schema script for SQLServer DB flavor to reduce execution
time
Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58526/
-----------------------------------------------------------
(Updated April 19, 2017, 9:24 a.m.)
Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
Changes
-------
updated summary
Summary (updated)
-----------------
RANGER-1522 : (Ranger-0.7 branch) Update consolidated db schema script for SQLServer DB flavor to reduce execution time
Bugs: RANGER-1522
https://issues.apache.org/jira/browse/RANGER-1522
Repository: ranger
Description
-------
**Problem Statement:** Script created for RANGER-1401 need to be created for RANGER 0.7 version and script should be updated without or minimum number of GO statements.
**Proposed Solution :** Create script for Ranger-0.7.0 version in security-admin/db/sqlserver/optimized/0.7.0 location and security-admin/db/sqlserver/optimized/current location.
Diffs
-----
security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql 13be7da
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION
Diff: https://reviews.apache.org/r/58526/diff/1/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
2) From a MSSQL Client tool executed security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal