Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of skbrnwl-dev@yahoo.com
 designates 98.139.212.165 as permitted sender)
Message-ID: <1403737083.74383.YahooMailNeo@web142806.mail.bf1.yahoo.com>
Date: Wed, 25 Jun 2014 15:58:03 -0700
From: Sumit Kumar <skbrnwl-dev@yahoo.com.INVALID>
Reply-To: Sumit Kumar <skbrnwl-dev@yahoo.com>
Subject: "desc database extended <dbname>" doesn't print dbproperties?
To: "user@hive.apache.org" <user@hive.apache.org>,
  "dev@hive.apache.org" <dev@hive.apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="515012262-616444276-1403737083=:74383"

--515012262-616444276-1403737083=:74383
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hey guys,=0A=0AI just discovered that this syntax doesn't print the dbprope=
rties any more. I've two hive versions that i'm testing following query on:=
=0A=0A=A0 create database test2 with dbproperties ('key1' =3D 'value1', 'ke=
y2' =3D 'value2');=0A=A0 desc database extended test2;=0A=0A=0AThe output o=
n hive 11 is:=0A=0Ahive>=A0=A0 desc database extended test2;=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =0AOK=0Atest2=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0 hdfs://xxxx:9000/warehouse/test2.db=A0=A0=A0=A0=
=A0=A0 {key2=3Dvalue2, key1=3Dvalue1}=0ATime taken: 0.021 seconds, Fetched:=
 1 row(s)=0A=0A=0AThe output on hive 13 is:=0Ahive> desc database extended =
test2;=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 =0AOK=0Atest2=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 hdfs://xxxx:9000/ware=
house/test2.db=A0=A0=A0 hadoop=0ATime taken: 0.023 seconds, Fetched: 1 row(=
s)=0A=0A=0AIf you look closely, you would notice that no key value informat=
ion from dbproperties was printed in hive13 case and somehow magically "had=
oop" (i guess it's my userid) appeared.=0A=0AAny idea if this functionality=
 changed since hive 11? Do we have a reference jira? I searched on the wiki=
s and JIRAs but couldn't find a reference; surprised that the language manu=
al wiki (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DD=
L) doesn't even talk about this functionality any more. Would appreciate in=
put on this.=0A=0A=0AThanks,=0A-Sumit=0A
--515012262-616444276-1403737083=:74383--