You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Dmytro Sen <ds...@hortonworks.com> on 2014/05/12 18:13:10 UTC

Review Request 21323: Ambari installation should run the hive schema script for Oracle and Postgres as Metastore DB

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/21323/
-----------------------------------------------------------

Review request for Ambari, Andrew Onischuk and Mahadev Konar.


Bugs: AMBARI-5734
    https://issues.apache.org/jira/browse/AMBARI-5734


Repository: ambari


Description
-------

Hive-metastore package.jdo will create hive metastore schema if the schema does not exist. However, the package does not detect the database flavor. Different database has different synatx. In the case of Oracle, it causes problem such as ORA-01754: a table may contain only one column of type LONG.
The recommended way should be populate hive metastore in advance with scripts provided in /usr/lib/hive/scripts/.... by schematool
instead of using autoCreate.


Diffs
-----

  ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/params.py 5ab1753 
  ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 0e56eb0 
  ambari-server/src/test/python/stacks/2.1/configs/default.json d80c28d 
  ambari-server/src/test/python/stacks/2.1/configs/secured.json 68b04d0 
  ambari-web/app/controllers/wizard/step8_controller.js 4aadcda 

Diff: https://reviews.apache.org/r/21323/diff/


Testing
-------


Thanks,

Dmytro Sen


Re: Review Request 21323: Ambari installation should run the hive schema script for Oracle and Postgres as Metastore DB

Posted by Vitalyi Brodetskyi <vb...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/21323/#review43126
-----------------------------------------------------------

Ship it!


Ship It!

- Vitalyi Brodetskyi


On May 15, 2014, 5:21 p.m., Dmytro Sen wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/21323/
> -----------------------------------------------------------
> 
> (Updated May 15, 2014, 5:21 p.m.)
> 
> 
> Review request for Ambari, Andrew Onischuk, Mahadev Konar, and Vitalyi Brodetskyi.
> 
> 
> Bugs: AMBARI-5734
>     https://issues.apache.org/jira/browse/AMBARI-5734
> 
> 
> Repository: ambari
> 
> 
> Description
> -------
> 
> Hive-metastore package.jdo will create hive metastore schema if the schema does not exist. However, the package does not detect the database flavor. Different database has different synatx. In the case of Oracle, it causes problem such as ORA-01754: a table may contain only one column of type LONG.
> The recommended way should be populate hive metastore in advance with scripts provided in /usr/lib/hive/scripts/.... by schematool
> instead of using autoCreate.
> 
> 
> Diffs
> -----
> 
>   ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/params.py 5ab1753 
>   ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 0e56eb0 
>   ambari-server/src/test/python/stacks/2.1/configs/default.json d80c28d 
>   ambari-server/src/test/python/stacks/2.1/configs/secured.json 68b04d0 
>   ambari-web/app/controllers/wizard/step8_controller.js 4aadcda 
> 
> Diff: https://reviews.apache.org/r/21323/diff/
> 
> 
> Testing
> -------
> 
> [INFO] Reactor Summary:
> [INFO]
> [INFO] Ambari Main ....................................... SUCCESS [8.233s]
> [INFO] Apache Ambari Project POM ......................... SUCCESS [0.357s]
> [INFO] Ambari Web ........................................ SUCCESS [16.613s]
> [INFO] Ambari Views ...................................... SUCCESS [2.899s]
> [INFO] Ambari Server ..................................... SUCCESS [12:57.233s]
> [INFO] Ambari Agent ...................................... SUCCESS [11.556s]
> [INFO] Ambari Client ..................................... SUCCESS [1.478s]
> 
> 
> Thanks,
> 
> Dmytro Sen
> 
>


Re: Review Request 21323: Ambari installation should run the hive schema script for Oracle and Postgres as Metastore DB

Posted by Dmytro Sen <ds...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/21323/
-----------------------------------------------------------

(Updated May 15, 2014, 5:21 p.m.)


Review request for Ambari, Andrew Onischuk, Mahadev Konar, and Vitalyi Brodetskyi.


Bugs: AMBARI-5734
    https://issues.apache.org/jira/browse/AMBARI-5734


Repository: ambari


Description
-------

Hive-metastore package.jdo will create hive metastore schema if the schema does not exist. However, the package does not detect the database flavor. Different database has different synatx. In the case of Oracle, it causes problem such as ORA-01754: a table may contain only one column of type LONG.
The recommended way should be populate hive metastore in advance with scripts provided in /usr/lib/hive/scripts/.... by schematool
instead of using autoCreate.


Diffs
-----

  ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/params.py 5ab1753 
  ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 0e56eb0 
  ambari-server/src/test/python/stacks/2.1/configs/default.json d80c28d 
  ambari-server/src/test/python/stacks/2.1/configs/secured.json 68b04d0 
  ambari-web/app/controllers/wizard/step8_controller.js 4aadcda 

Diff: https://reviews.apache.org/r/21323/diff/


Testing
-------

[INFO] Reactor Summary:
[INFO]
[INFO] Ambari Main ....................................... SUCCESS [8.233s]
[INFO] Apache Ambari Project POM ......................... SUCCESS [0.357s]
[INFO] Ambari Web ........................................ SUCCESS [16.613s]
[INFO] Ambari Views ...................................... SUCCESS [2.899s]
[INFO] Ambari Server ..................................... SUCCESS [12:57.233s]
[INFO] Ambari Agent ...................................... SUCCESS [11.556s]
[INFO] Ambari Client ..................................... SUCCESS [1.478s]


Thanks,

Dmytro Sen


Re: Review Request 21323: Ambari installation should run the hive schema script for Oracle and Postgres as Metastore DB

Posted by Dmytro Sen <ds...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/21323/
-----------------------------------------------------------

(Updated May 15, 2014, 5:21 p.m.)


Review request for Ambari, Andrew Onischuk, Mahadev Konar, and Vitalyi Brodetskyi.


Bugs: AMBARI-5734
    https://issues.apache.org/jira/browse/AMBARI-5734


Repository: ambari


Description
-------

Hive-metastore package.jdo will create hive metastore schema if the schema does not exist. However, the package does not detect the database flavor. Different database has different synatx. In the case of Oracle, it causes problem such as ORA-01754: a table may contain only one column of type LONG.
The recommended way should be populate hive metastore in advance with scripts provided in /usr/lib/hive/scripts/.... by schematool
instead of using autoCreate.


Diffs
-----

  ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/params.py 5ab1753 
  ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 0e56eb0 
  ambari-server/src/test/python/stacks/2.1/configs/default.json d80c28d 
  ambari-server/src/test/python/stacks/2.1/configs/secured.json 68b04d0 
  ambari-web/app/controllers/wizard/step8_controller.js 4aadcda 

Diff: https://reviews.apache.org/r/21323/diff/


Testing
-------

[INFO] Reactor Summary:
[INFO]
[INFO] Ambari Main ....................................... SUCCESS [8.233s]
[INFO] Apache Ambari Project POM ......................... SUCCESS [0.357s]
[INFO] Ambari Web ........................................ SUCCESS [16.613s]
[INFO] Ambari Views ...................................... SUCCESS [2.899s]
[INFO] Ambari Server ..................................... SUCCESS [12:57.233s]
[INFO] Ambari Agent ...................................... SUCCESS [11.556s]
[INFO] Ambari Client ..................................... SUCCESS [1.478s]


Thanks,

Dmytro Sen


Re: Review Request 21323: Ambari installation should run the hive schema script for Oracle and Postgres as Metastore DB

Posted by Dmytro Sen <ds...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/21323/
-----------------------------------------------------------

(Updated May 12, 2014, 4:26 p.m.)


Review request for Ambari, Andrew Onischuk and Mahadev Konar.


Bugs: AMBARI-5734
    https://issues.apache.org/jira/browse/AMBARI-5734


Repository: ambari


Description
-------

Hive-metastore package.jdo will create hive metastore schema if the schema does not exist. However, the package does not detect the database flavor. Different database has different synatx. In the case of Oracle, it causes problem such as ORA-01754: a table may contain only one column of type LONG.
The recommended way should be populate hive metastore in advance with scripts provided in /usr/lib/hive/scripts/.... by schematool
instead of using autoCreate.


Diffs
-----

  ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/params.py 5ab1753 
  ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 0e56eb0 
  ambari-server/src/test/python/stacks/2.1/configs/default.json d80c28d 
  ambari-server/src/test/python/stacks/2.1/configs/secured.json 68b04d0 
  ambari-web/app/controllers/wizard/step8_controller.js 4aadcda 

Diff: https://reviews.apache.org/r/21323/diff/


Testing (updated)
-------

[INFO] Reactor Summary:
[INFO]
[INFO] Ambari Main ....................................... SUCCESS [8.233s]
[INFO] Apache Ambari Project POM ......................... SUCCESS [0.357s]
[INFO] Ambari Web ........................................ SUCCESS [16.613s]
[INFO] Ambari Views ...................................... SUCCESS [2.899s]
[INFO] Ambari Server ..................................... SUCCESS [12:57.233s]
[INFO] Ambari Agent ...................................... SUCCESS [11.556s]
[INFO] Ambari Client ..................................... SUCCESS [1.478s]


Thanks,

Dmytro Sen