While Executing Prepared statements form application, we are observing the above-mentioned error from the driver.
DSE Version:- 5.1.5
DSE Java Driver :- 1.6.7
DataStax Academy FAQ
DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.
Check out the Academy FAQ pages for answers to your questions:
- Why can't I book an exam yet?
- What happens to previously scheduled exams?
- Why can't I see my exam results or certificate? [UPDATED August 1]
- What happened to my exam voucher?
- Why are DSE courses missing from the new Academy?
- Why is my course progress not shown on the new Academy?
Unexpected error during query org.apache.cassandra.serializers.MarshalException: Expected 8 or 0 byte long for date (4)
@bb.addagada_90355 Based on the minimal information you provided, my guess is that your queries don't list the columns (use of wildcards) in this manner:
SELECT * FROM ... WHERE ...
If at some point the schema for the table changes, it no longer matches the schema of the cached prepared statement so the values being returned is not what the driver expected.
The best practice is to explicitly enumerate the columns you want to retrieve from the table so the application gets exactly the columns it expects. For example:
SELECT col1, col2, col3 FROM ... WHERE ...
This should prevent the prepared statements from getting out-of-sync with the schema. Cheers!
3 People are following this question.
