Hello!
I can't understand what's wrong.
drop table if exists t0;
create table t0 (short_descr string) STORED AS SEQUENCEFILE;
from (
select cast(2 as int) identifier2, short_descr area_name from t0) asdf
select *--area_name
order by identifier2 desc, area_name asc
;
The query works fine
if you're doing a lot
of ordering I think.
I'm assuming sequencefiles are faster, but I wouldn't really know :( need
someone else to tell us more about that ;)
-Original Message-
From: Avdeev V. M. [mailto:ls...@list.ru]
Sent: Monday, May 28, 2012 7:17 AM
Question from novice.
Where I can read table design best practices? I have a measure table with
millions of rows and many dimension tables with less than 1000 rows each. I
can't find out the way to get optimal design of both kind of tables. Is there
performance tuning guides or performance
Hello!
I'm very new to the world Hadoop and Hive so I cannot solve a problem that I
encountered.
Hadoop has been deployed on a single-node in a pseudo-distributed mode.
I'm trying to copy data from one table to another. Source table created by
Sqoop, destination table created by query
drilling down to task level.
Those errors will give you abetter understanding on what could be
going wrong here.
Regards
Bejoy
--
From: Avdeev V. M. ls...@list.ru
To: user@hive.apache.org
Sent: Tuesday, May 22, 2012