PageRenderTime 43ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/database_properties.q

#
text | 26 lines | 16 code | 10 blank | 0 comment | 0 complexity | ef6641380b5032a5a1fc4b35bbdc8822 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. set datanucleus.cache.collections=false;
    2. 

  2. set datanucleus.cache.collections.lazy=false;
    3. 

  3. 

  4. create database db1;
    5. 

  5. 

  6. show databases;
    7. 

  7. 

  8. create database db2 with dbproperties (
    9. 

  9.   'mapred.jobtracker.url'='http://my.jobtracker.com:53000',
    10. 

  10.   'hive.warehouse.dir' = '/user/hive/warehouse',
    11. 

  11.   'mapred.scratch.dir' = 'hdfs://tmp.dfs.com:50029/tmp');
    12. 

  12. 

  13. describe database db2;
    14. 

  14. 

  15. describe database extended db2;
    16. 

  16. 

  17. 

  18. set datanucleus.cache.collections=false;
    19. 

  19. set datanucleus.cache.collections.lazy=false;
    20. 

  20. 

  21. alter database db2 set dbproperties (
    22. 

  22.   'new.property' = 'some new props',
    23. 

  23.   'hive.warehouse.dir' = 'new/warehouse/dir');
    24. 

  24. 

  25. describe database extended db2;
    26. 

  26. 

  27.