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:18:11 UTC

Review Request 58525: 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/58525/
-----------------------------------------------------------

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 1.0.0 version and script should be updated without or minimum number of GO statements.

**Proposed Solution :** Create script for Ranger-1.0.0 version in security-admin/db/sqlserver/optimized/1.0.0 location and security-admin/db/sqlserver/optimized/current location.

Diffs
-----

security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql PRE-CREATION
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION

Diff: https://reviews.apache.org/r/58525/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 58525: RANGER-1522 : 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/58525/#review173216
-----------------------------------------------------------


Ship it!




Ship It!

- Gautam Borad


On April 26, 2017, 5:02 p.m., Pradeep Agrawal wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/58525/
> -----------------------------------------------------------
> 
> (Updated April 26, 2017, 5:02 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 1.0.0 version and script should be updated without or minimum number of GO statements. 
> 
> **Proposed Solution :** Create script for Ranger-1.0.0 version in security-admin/db/sqlserver/optimized/1.0.0 location and security-admin/db/sqlserver/optimized/current location.
> 
> 
> Diffs
> -----
> 
>   security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql PRE-CREATION 
>   security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION 
> 
> 
> Diff: https://reviews.apache.org/r/58525/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 58525: RANGER-1522 : 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/58525/#review173201
-----------------------------------------------------------


Ship it!




Ship It!

- Velmurugan Periasamy


On April 26, 2017, 5:02 p.m., Pradeep Agrawal wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/58525/
> -----------------------------------------------------------
> 
> (Updated April 26, 2017, 5:02 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 1.0.0 version and script should be updated without or minimum number of GO statements. 
> 
> **Proposed Solution :** Create script for Ranger-1.0.0 version in security-admin/db/sqlserver/optimized/1.0.0 location and security-admin/db/sqlserver/optimized/current location.
> 
> 
> Diffs
> -----
> 
>   security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql PRE-CREATION 
>   security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION 
> 
> 
> Diff: https://reviews.apache.org/r/58525/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 58525: RANGER-1522 : Update consolidated db schema script for SQLServer DB flavor to reduce execution time

Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.

(Updated April 26, 2017, 5:02 p.m.)

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 1.0.0 version and script should be updated without or minimum number of GO statements.

**Proposed Solution :** Create script for Ranger-1.0.0 version in security-admin/db/sqlserver/optimized/1.0.0 location and security-admin/db/sqlserver/optimized/current location.

Diffs (updated)
-----

security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql PRE-CREATION
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql PRE-CREATION

Diff: https://reviews.apache.org/r/58525/diff/2/

Changes: https://reviews.apache.org/r/58525/diff/1-2/

Testing
-------

Thanks,

Pradeep Agrawal