Hey guys,
I just discovered that this syntax doesn't print the dbproperties any more.
I've two hive versions that i'm testing following query on:
create database test2 with dbproperties ('key1' = 'value1', 'key2' =
'value2');
desc database extended test2;
The output on hive 11 is:
hive> desc database extended test2;
OK
test2 hdfs://xxxx:9000/warehouse/test2.db {key2=value2,
key1=value1}
Time taken: 0.021 seconds, Fetched: 1 row(s)
The output on hive 13 is:
hive> desc database extended test2;
OK
test2 hdfs://xxxx:9000/warehouse/test2.db hadoop
Time taken: 0.023 seconds, Fetched: 1 row(s)
If you look closely, you would notice that no key value information from
dbproperties was printed in hive13 case and somehow magically "hadoop" (i guess
it's my userid) appeared.
Any idea if this functionality changed since hive 11? Do we have a reference
jira? I searched on the wikis and JIRAs but couldn't find a reference;
surprised that the language manual wiki
(https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) doesn't
even talk about this functionality any more. Would appreciate input on this.
Thanks,
-Sumit
