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
