You need to use the connector that connects your S3 bucket to your database. After that, you can use the commands.
First, read the file from s3 into an RDD in your system.
val rdd = sc.textFile("s3n://mybucket/file_name")
After that, load the red to Cassandra table. Also, check the proper format.