Sorry, the exception is actually as follows.
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. Table not found
default__employee_id_idx_id_employee_id__
On Mon, Feb 9, 2015 at 2:45 PM, DU DU wrote:
> Hi folks,
> I got following errors in Hive 1.0.0. However, I
Try:
Export HADOOP_HEAPSIZE=1000 ( 1gb) Before running your hive query
And keep keep increasing the size to needed value
Another option is setting Xmx in hive-env.sh
Sent from my iPhone
On Oct 27, 2012, at 12:21 PM, Peter Marron
wrote:
> Hi,
>
> I have a fairly low-end machine running Ubu
Thanks. I see this:
CREATE INDEX index_name
ON TABLE base_table_name (col_name, ...)
AS index_type
[WITH DEFERRED REBUILD]
[IDXPROPERTIES (property_name=property_value, ...)]
[IN TABLE index_table_name]
[
[ ROW FORMAT ...] STORED AS ...
| STORED BY ...
]
[LOCATION hdfs_path]
[TBLPROPERTIES (
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create%2FDropIndexhas
DDL commands using which you can create and manipulate indices in
Hive.
Hope it helps,
Ashutosh
On Mon, Sep 12, 2011 at 05:46, Adriaan Tijsseling wrote:
> Does anyone know the proper docum
yup, I'd be interested in this too. I'd like to know how the indices
are applied/used and which queries can they be useful.
Thanks,
--
Rohan Monga
On Mon, Sep 12, 2011 at 6:16 PM, Adriaan Tijsseling
wrote:
> Does anyone know the proper documentation for using the "CREATE INDEX"
> command in h
