kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From suresh m <suresh.m8...@gmail.com>
Subject No of arguments passing issue in kylin query
Date Thu, 22 Jun 2017 09:15:39 GMT
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