Layer7 API Management

 View Only

API Gateway Cassandra (Greater Than) (Less Query) Error

  • 1.  API Gateway Cassandra (Greater Than) (Less Query) Error

    Posted Jul 08, 2020 12:40 PM
    We have a Cassandra instance that we are querying from API Gateway.  The query is:

    select id,logtime,browserversion,eauthurl,apiurl,status,failurereason,errormessage,errordetails,gatewaytransactionid from eauth_ui_event_log where logtime >= ${startTimestamp.result} and logtime <= ${stopTimestamp.result} allow filtering;

    The error I'm getting back is:

    "Perform Cassandra Query" assertion failed due to: Codec not found for requested operation: [timestamp <-> java.lang.String]

    I have an insert query that works just fine.  I found some stuff about different syntax in Java, but of course I can't use that in API Gateway.  Any help is greatly appreciated.