Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to use a select distinct query with limit and offset

How to use a select distinct query with limit and offset

New Contributor

Hello,

I'm using hive-jdbc 2.1.0 connector and when I try this request :

"select * from (select distinct number from table)p limit 100,900";

It's return some duplicated row.

Without any limit it's works perfectly...

Hive LLAP is up.

Hive version :

Hive1.2.1000