kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: No of arguments passing issue in kylin query
Date Thu, 29 Jun 2017 10:19:18 GMT
Not a known issue..  What is your Kylin version?

On Thu, Jun 22, 2017 at 5:16 PM, suresh m <suresh.m8687@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 <suresh.m8687@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
> >
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message