I am doing the Normalization exercise on DS220 using python driver from local PC.
I created UDT type as shown:
I also created videos_by_actor table as shown:
I am using python to extract csv data into cassandra videos_by_actor table as shown:
The following error is being generated:
The error reads: Invalid string constant. with the encoding column in the csv file covered in parentheses. However, when I printed the encoding column out from csv, it is in curly braces which is normal for the UDT I am creating.
Is this a bug in cassandra python driver? I have ensured to follow the documentation in properly creating encoding UDT type with type frozen<video_encoding>. Is there anything I am missing here?
Finally, If I wanna use Astra for learning purposes, Is there any resource I can use to get started. More importantly, I will like to document my every step in Astra from table creation to insertion and querying just like I would using a python script.
I will appreciate assistance in debugging this issue!