You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sumit Kumar <sk...@yahoo.com> on 2014/06/26 00:58:03 UTC
"desc database extended " doesn't print dbproperties?
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
Re: "desc database extended " doesn't print dbproperties?
Posted by Sumit Kumar <sk...@yahoo.com>.
Thanks Navis!
On Wednesday, 25 June 2014 10:44 PM, Navis류승우 <na...@nexr.com> wrote:
Booked in https://issues.apache.org/jira/browse/HIVE-7298
Thanks,
2014-06-26 14:28 GMT+09:00 Navis류승우 <na...@nexr.com>:
Seemed regression of HIVE-6386. Will be fixed in next version.
>
>
>
>2014-06-26 7:58 GMT+09:00 Sumit Kumar <sk...@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
>>
>
Re: "desc database extended " doesn't print dbproperties?
Posted by Navis류승우 <na...@nexr.com>.
Booked in https://issues.apache.org/jira/browse/HIVE-7298
Thanks,
2014-06-26 14:28 GMT+09:00 Navis류승우 <na...@nexr.com>:
> Seemed regression of HIVE-6386. Will be fixed in next version.
>
>
> 2014-06-26 7:58 GMT+09:00 Sumit Kumar <sk...@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
>>
>
>
Re: "desc database extended " doesn't print dbproperties?
Posted by Navis류승우 <na...@nexr.com>.
Seemed regression of HIVE-6386. Will be fixed in next version.
2014-06-26 7:58 GMT+09:00 Sumit Kumar <sk...@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
>