search

datastaxdevs / workshop-intro-to-cassandra

Learn Apache Cassandra fundamentals in this hands-on workshop
Apache License 2.0
219 stars 168 forks source link

Datastax Astra - Load error #122

Open nvlkarthik opened 3 years ago

nvlkarthik commented 3 years ago

umbr.csv

I cannot able to load the umbr.csv file even If I declare datatype as varchar for my source date format yyyymmdd. In my source file all the Date format asre stored as 'yyyymmdd' and i want to maintain the same format at destination.

Datastax login : iamkarthiklogan@gmail.com Keyspace : killrvideo

Error : "DateTimeParseException: Text could not be parsed at index 0"

I have successfully loaded the same in GCP Bigtable using custom Data type option.

Thanks Karthik Raja

SonicDMG commented 3 years ago

Hey there Karthik. This is really a question that should be posted to community.datastax.com. A quick look alt your CSV and the error you pasted tells me this is simply a date formatting issue. https://docs.datastax.com/en/cql-oss/3.3/cql/cql_reference/timestamp_type_r.html. The required format is yyyy-mm-dd, not yyyymmdd. I recognize you want to keep the same format, but it is not supported. Any reason why you can't export the data in the required format? Again though, I would post this to community.datastax.com as you may get a better answer or another user who has solved this.

SonicDMG commented 3 years ago

However, take a look at example 8 from DSBulk. https://www.datastax.com/blog/datastax-bulk-loader-more-loading You may be able to use that to reformat the date on the fly.