====
---- QUERY
# Test printing of default database.
describe database default
---- RESULTS
'default','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR','Default Hive database'
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db1
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db1','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db1.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db2
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db2','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db2.db','test comment'
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db3
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db3','$NAMENODE/testdb3',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db4
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db4','$NAMENODE/test4.db','test comment'
---- TYPES
string, string, string
====
---- QUERY
describe database impala_test_desc_db5
---- RESULTS
'impala_test_desc_db5','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db5.db','test comment'
'managedlocation:','$NAMENODE/test5.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db5
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db5','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db5.db','test comment'
'managedlocation:','$NAMENODE/test5.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db5
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db5','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db5.db','test comment'
'managedlocation:','$NAMENODE/test5.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database formatted impala_test_desc_db5
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db5','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db5.db','test comment'
'managedlocation:','$NAMENODE/test5.db',''
---- TYPES
string, string, string
====
---- QUERY
# Test printing of default database.
describe database default
---- RESULTS
'default','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR','Default Hive database'
---- TYPES
string, string, string
====
---- QUERY
# Test printing of hive_test_desc_db database.
describe database hive_test_desc_db
---- RESULTS
'hive_test_desc_db','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/hive_test_desc_db.db','test comment'
---- TYPES
string, string, string
====
---- QUERY
# Test printing of hive_test_desc_db database with extended information.
describe database extended hive_test_desc_db
---- RESULTS
'hive_test_desc_db','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/hive_test_desc_db.db','test comment'
'Parameter: ','',''
'','$USER','USER'
'Owner: ','',''
'','e','2.82'
'','pi','3.14'
---- TYPES
string, string, string
====
---- QUERY
describe database hive_test_desc_db2
---- RESULTS
'hive_test_desc_db2','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/hive_test_desc_db2.db','test comment'
'managedlocation:','$NAMENODE/test2.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended hive_test_desc_db2
---- RESULTS
'hive_test_desc_db2','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/hive_test_desc_db2.db','test comment'
'managedlocation:','$NAMENODE/test2.db',''
'','$USER','USER'
'Owner: ','',''
---- TYPES
string, string, string
====