testdata/workloads/functional-query/queries/QueryTest/describe-db.test

====
---- QUERY
# Test printing of default database.
describe database default
---- RESULTS
'default','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR','Default Hive database'
'managedlocation:','$NAMENODE/$MANAGED_WAREHOUSE_DIR',''
---- 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',''
'managedlocation:','$NAMENODE/$MANAGED_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'
'managedlocation:','$NAMENODE/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db2.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db3
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db3','$NAMENODE/testdb',''
'managedlocation:','$NAMENODE/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db3.db',''
---- TYPES
string, string, string
====
---- QUERY
describe database extended impala_test_desc_db4
---- RESULTS
'','$USER','USER'
'Owner: ','',''
'impala_test_desc_db4','$NAMENODE/test2.db','test comment'
'managedlocation:','$NAMENODE/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db4.db',''
---- TYPES
string, string, string
====
---- QUERY
# TODO: Currently Hive ignores the specified managedlocation due to HIVE-24175,
# so we are using the default locations in the checks. Restore the specified
# location once HIVE-24175 is resolved.
describe database impala_test_desc_db5
---- RESULTS
'impala_test_desc_db5','$NAMENODE/$EXTERNAL_WAREHOUSE_DIR/impala_test_desc_db5.db','test comment'
'managedlocation:','$NAMENODE/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db5.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/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db5.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/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db5.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/$MANAGED_WAREHOUSE_DIR/impala_test_desc_db5.db',''
---- TYPES
string, string, string
====