There's a case bug in hive. Put all the names into lower case. I've got a
JIRA open about it somewhere.
Phil.
On Aug 22, 2012 4:39 AM, "Lin" wrote:
> Hi,
>
> I build a compact index IX for table A as follows,
>
> create index IX on table A(a, b) as 'COMPACT'
> with deferred rebuild
> in table A_
Hi,
I build a compact index IX for table A as follows,
create index IX on table A(a, b) as 'COMPACT'
with deferred rebuild
in table A_IX.
When I run the following query,
select c, d from A
where a='a_v' and b ='b_v';
I got the following error:
FAILED: Error in semantic analysis: No partition pr
Hi, all
I tried to use Chinese in hive column comment and table comment,and the
metadata in Mysql is regular,the charset of 'COMMENT' column in 'columns_v2'
table and 'PARAM_VALUE' column in 'table_params' table both are 'utf8'.
When I exec 'select * from columns_v2' with mysql clie
Manish,
Just specify the directory under location and not the actual file. In
your case (notice, there is no .csv in the location). If your field
definitions match the data already present in HDFS, this should work just
fine. Make sure all the files under directory input have the same structure.
Thanks everyone for the different possible solutions.We resolved this by
using the rank function and following the instructions at
https://github.com/edwardcapriolo/hive-rank
This is similar to Bob's approach.
Thanks
On Mon, Aug 20, 2012 at 3:04 AM, Navis류승우 wrote:
> We've solved similar cases
Hi Anson
Hive has the EXPORT IMPORT feature since 0.8 that EXPORTs the table structure
as well as data into a file which can be used for IMPORTing back to a new
instance. A sample query could be
EXPORT TABLE TO 'location in hdfs';
IMPORT FROM 'location in hdfs';
For details please refer the
I have a hive set of of tables. Quite a large number of them are not
external tables but "internalized hive tables". I have another hadoop
instance up and running. Is there a way i can migrate the hive data from
one instance to another, and then create the hive tables on the new
instance? Can t
