2 Replies Latest reply: Jul 23, 2014 9:51 AM by MRERP2 RSS

    How to cancel Limit rownum <1234....

    MRERP2

      Hi,

       

      I've connect through ODBC connection pool to Vertica (HP) Database.

      Vertica's SQL doesn't work with operator "rownum<...".

      But OBIEE generate it on DB SQL statments, according to ResultRowLimit definition.

      For example:

       

      select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4

      from ( select distinct 0 as c1,

      D1.c1 as c2,

      D1.c2 as c3,

      D1.c3 as c4

      from

      (select T380477.PERIOD_NAME as c1,

      T380477.PERIOD_NUM as c2,

      T380477.PERIOD_ID as c3

      from XXBI_DIM_GL_PERIODS T380477

        ) D1

      order by c4, c3 ) D1

      where rownum <= 1000000000

       

      So the question is: is there a way to cancel rownum limit ?

       

      Thanks,

      Ark