Seemed regression of HIVE-6386. Will be fixed in next version.
2014-06-26 7:58 GMT+09:00 Sumit Kumar <skbrnwl-...@yahoo.com>:
> 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
>
