AnsweredAssumed Answered

skewed table and order by clause

Question asked by sgudavalli on Jan 30, 2018
Latest reply on Feb 2, 2018 by maprcommunity

hello,

I am using hive 2.1 and creating a list bucketing table .

CREATE TABLE rtyupljslj (
c1 bigint,
c2 char(5), c3 char(3), c4 char(3),
c5 TINYINT,
c6 INT, c7 TINYINT,
c8 TINYINT,
c9 bigint,
c1 char(2),
c2 char(2),
c3 char(2),
d1 date,
d2 date,
doc string
) partitioned by (p1 char(3), p2 int, p3 TINYINT)
skewed by (c6) on (10000,20000) stored as directories
stored as orc TBLPROPERTIES ("orc.bloom.filter.columns"="usr,scat,ht,act");

 

order by clause on list bucketed table is returning zero records.

selecT * from rtyupljslj order by c9 limit 1000;

when I remove order by clause I can see data.

do you know if list bucketing is supported in hive 2.1 ? is order by supported on a list bucketed table?

appreciate your inputs.

Outcomes