Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1244.3)
Subject: Re: CREATE INDEX
From: Adriaan Tijsseling <adriaan@tijsseling.com>
In-Reply-To: 
 <CA+FBdFSbQmP5TozMJRhBZDVhX4YC5=u52ggT2LYHqgvnt52BnQ@mail.gmail.com>
Date: Mon, 12 Sep 2011 21:07:22 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <D80386B5-6241-45FD-BD32-B9E7E2C1BFD5@tijsseling.com>
References: <417DC562-060C-47AB-8951-E1C6EE553947@tijsseling.com>
 <CA+FBdFSbQmP5TozMJRhBZDVhX4YC5=u52ggT2LYHqgvnt52BnQ@mail.gmail.com>
To: user@hive.apache.org

Thanks. I see this:

CREATE INDEX index_name
ON TABLE base_table_name (col_name, ...)
AS index_type
[WITH DEFERRED REBUILD]
[IDXPROPERTIES (property_name=3Dproperty_value, ...)]
[IN TABLE index_table_name]
[
   [ ROW FORMAT ...] STORED AS ...
   | STORED BY ...
]
[LOCATION hdfs_path]
[TBLPROPERTIES (...)]
[COMMENT=20
"index comment"]

Sadly, there's no explanation what IDXPROPERTIES could be. It looks to =
be similar to TBLPROPERTIES, but that isn't documented well either.=20


On 2011/09/12, at 19:11, Ashutosh Chauhan wrote:

> =
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#Langua=
geManualDDL-Create%2FDropIndexhas
> DDL commands using which you can create and manipulate indices in
> Hive.
>=20
> Hope it helps,
> Ashutosh
>=20
> On Mon, Sep 12, 2011 at 05:46, Adriaan Tijsseling =
<adriaan@tijsseling.com>wrote:
>=20
>> Does anyone know the proper documentation for using the "CREATE =
INDEX"
>> command in hive? The hive homepage doesn't have the information.
>>=20
>> Cheers,
>>=20
>> Adriaan
>>=20
>>=20