Home:ALL Converter>Cassandra error: `DriverException: Failed decoding result column "starttime" of type time`

Cassandra error: `DriverException: Failed decoding result column "starttime" of type time`

Ask Time:2021-09-22T05:29:35         Author:Ashot

Json Formatter

I have a table with column starttime having type time. Wrongly the client code (c++) inserted some data as string for that column. Now when I run select * from table1; I am getting this error:

Traceback (most recent call last):
  File "C:\Cassandra\apache-cassandra-3.11.3\bin\\cqlsh.py", line 1050, in perform_simple_statement
    result = future.result()
  File "C:\Cassandra\apache-cassandra-3.11.3\bin\..\lib\cassandra-driver-internal-only-3.11.0-bb96859b.zip\cassandra-driver-3.11.0-bb96859b\cassandra\cluster.py", line 3925, i
n result
    raise self._final_exception
DriverException: Failed decoding result column "starttime" of type time: value must be less than number of nanoseconds in a day (86400000000000)

Is there a way to get that data so I can create a new table with correct column type and manually insert the data there?

Author:Ashot,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/69275762/cassandra-error-driverexception-failed-decoding-result-column-starttime-of