You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by suresh m <su...@gmail.com> on 2017/06/22 09:15:39 UTC
No of arguments passing issue in kylin query
Hi,
Facing an issue with passing no of arguments in Kylin Query.
When I am querying with less than or eaqual to 5 arguements result is
coming properly. If i pass more than 5 arguments result showing as 0 even
though records there in cube.
sending you the query as well,
SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM (SELECT
AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME
|| ' ' || AL_DRIVER_DIM.LAST_NAME AS
DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER FROM
AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join AL_PROD.AL_TRIP_DIM
AL_TRIP_DIM on AL_PROD_RPT_FACT.TRIP_KEY=AL_TRIP_DIM.TRIP_KEY inner join
AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on
AL_PROD_RPT_FACT.DRIVER_KEY=AL_DRIVER_DIM.DRIVER_KEY inner join
AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
AL_PROD.AL_TIME_DIM AL_TIME_DIM on
AL_PROD_RPT_FACT.TIME_KEY=AL_TIME_DIM.TIM_ID where
AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
(278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
'2017-06-20' order by AL_PROD.CLNDR_DT;
in above query we can see only 5 arguments passing for trip_id. For this
query result is coming properly and it showing 5 trips as well.
But in below query passing 6 trip id's then result is showing as 0 trips
and if i removed 1 trip id from the list then its showing 5 trips as usual.
let me know is there any limitation of passing arguments. If yes let me
know how resolve this.
Regards,
Suresh
Re: No of arguments passing issue in kylin query
Posted by Li Yang <li...@apache.org>.
Not a known issue.. What is your Kylin version?
On Thu, Jun 22, 2017 at 5:16 PM, suresh m <su...@gmail.com> wrote:
> forgot to add 2nd query.
>
> SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
> AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM (SELECT
> AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.
> VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_
> NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_
> DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME
> || ' ' || AL_DRIVER_DIM.LAST_NAME AS
> DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER FROM
> AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join AL_PROD.AL_TRIP_DIM
> AL_TRIP_DIM on AL_PROD_RPT_FACT.TRIP_KEY=AL_TRIP_DIM.TRIP_KEY inner join
> AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
> AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
> AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on
> AL_PROD_RPT_FACT.DRIVER_KEY=AL_DRIVER_DIM.DRIVER_KEY inner join
> AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
> AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
> AL_PROD.AL_TIME_DIM AL_TIME_DIM on
> AL_PROD_RPT_FACT.TIME_KEY=AL_TIME_DIM.TIM_ID where
> AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
> AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
> (274,278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
> '2017-06-20' order by AL_PROD.CLNDR_DT
>
> On Thu, Jun 22, 2017 at 2:45 PM, suresh m <su...@gmail.com> wrote:
>
> > Hi,
> >
> > Facing an issue with passing no of arguments in Kylin Query.
> >
> > When I am querying with less than or eaqual to 5 arguements result is
> > coming properly. If i pass more than 5 arguments result showing as 0 even
> > though records there in cube.
> >
> > sending you the query as well,
> >
> >
> > SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
> > AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM
> (SELECT
> > AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.
> > VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_
> > NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_
> > DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME || ' ' || AL_DRIVER_DIM.LAST_NAME
> > AS DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER
> > FROM AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join
> > AL_PROD.AL_TRIP_DIM AL_TRIP_DIM on AL_PROD_RPT_FACT.TRIP_KEY=AL_
> TRIP_DIM.TRIP_KEY
> > inner join AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
> > AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
> > AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on AL_PROD_RPT_FACT.DRIVER_KEY=
> AL_DRIVER_DIM.DRIVER_KEY
> > inner join AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
> > AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
> > AL_PROD.AL_TIME_DIM AL_TIME_DIM on AL_PROD_RPT_FACT.TIME_KEY=AL_
> TIME_DIM.TIM_ID
> > where AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
> > AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
> > (278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
> > '2017-06-20' order by AL_PROD.CLNDR_DT;
> >
> >
> > in above query we can see only 5 arguments passing for trip_id. For this
> > query result is coming properly and it showing 5 trips as well.
> >
> > But in below query passing 6 trip id's then result is showing as 0 trips
> > and if i removed 1 trip id from the list then its showing 5 trips as
> usual.
> >
> >
> >
> > let me know is there any limitation of passing arguments. If yes let me
> > know how resolve this.
> >
> >
> >
> > Regards,
> >
> > Suresh
> >
> >
> >
>
Re: No of arguments passing issue in kylin query
Posted by suresh m <su...@gmail.com>.
forgot to add 2nd query.
SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM (SELECT
AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME
|| ' ' || AL_DRIVER_DIM.LAST_NAME AS
DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER FROM
AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join AL_PROD.AL_TRIP_DIM
AL_TRIP_DIM on AL_PROD_RPT_FACT.TRIP_KEY=AL_TRIP_DIM.TRIP_KEY inner join
AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on
AL_PROD_RPT_FACT.DRIVER_KEY=AL_DRIVER_DIM.DRIVER_KEY inner join
AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
AL_PROD.AL_TIME_DIM AL_TIME_DIM on
AL_PROD_RPT_FACT.TIME_KEY=AL_TIME_DIM.TIM_ID where
AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
(274,278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
'2017-06-20' order by AL_PROD.CLNDR_DT
On Thu, Jun 22, 2017 at 2:45 PM, suresh m <su...@gmail.com> wrote:
> Hi,
>
> Facing an issue with passing no of arguments in Kylin Query.
>
> When I am querying with less than or eaqual to 5 arguements result is
> coming properly. If i pass more than 5 arguments result showing as 0 even
> though records there in cube.
>
> sending you the query as well,
>
>
> SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
> AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM (SELECT
> AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.
> VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_
> NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_
> DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME || ' ' || AL_DRIVER_DIM.LAST_NAME
> AS DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER
> FROM AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join
> AL_PROD.AL_TRIP_DIM AL_TRIP_DIM on AL_PROD_RPT_FACT.TRIP_KEY=AL_TRIP_DIM.TRIP_KEY
> inner join AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
> AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
> AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on AL_PROD_RPT_FACT.DRIVER_KEY=AL_DRIVER_DIM.DRIVER_KEY
> inner join AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
> AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
> AL_PROD.AL_TIME_DIM AL_TIME_DIM on AL_PROD_RPT_FACT.TIME_KEY=AL_TIME_DIM.TIM_ID
> where AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
> AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
> (278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
> '2017-06-20' order by AL_PROD.CLNDR_DT;
>
>
> in above query we can see only 5 arguments passing for trip_id. For this
> query result is coming properly and it showing 5 trips as well.
>
> But in below query passing 6 trip id's then result is showing as 0 trips
> and if i removed 1 trip id from the list then its showing 5 trips as usual.
>
>
>
> let me know is there any limitation of passing arguments. If yes let me
> know how resolve this.
>
>
>
> Regards,
>
> Suresh
>
>
>