+1 for solution 1 but the limit statment will get the head or tail of segment list? or need order by some columns? Please describe the details.
----- Best Regards David Cai -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/