search

brianmhess / cassandra-loader

Delimited file loader for Cassandra
Apache License 2.0
197 stars 93 forks source link

Loader can't load data to a table with a UDT column #21

Open rs017991 opened 8 years ago

rs017991 commented 8 years ago

It would be really great for the loader to support User-defined types.

Note that collections may contain UDTs and UDTs may contain collections/other UDTs, so CQLDelimParser.schemaBits(...) would need to support some level of recursion.

Side note: The skipCols options cannot be used to skip over a column with a non-supported type because parsers are eagerly built.

brianmhess commented 8 years ago

Skip columns would work if you quoted the UDT, or if the UDT did not have embedded delimiters.

diegopeleteiro commented 8 years ago

Indeed it would be great to have support to UDTs

trex77 commented 5 years ago

The tool is great. I really loved it. Is there any solution to UDT types other than skiping the columns? My data have sets and collections and the unloader tool gives the error below:

Exception in thread "main" java.util.concurrent.ExecutionException: java.text.ParseException: Set data type not recognized (udt) at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:192) at com.datastax.loader.CqlDelimUnload.run(CqlDelimUnload.java:402) at com.datastax.loader.CqlDelimUnload.main(CqlDelimUnload.java:471)

brianmhess commented 5 years ago

There is a udt branch you could try. I think that got pretty solid, but I haven't been working on this in a while.

kalpana04-star commented 4 years ago

This utility support UDTs?

brianmhess commented 4 years ago

Check out the "udt" branch. You may also want to look at the dsbulk utility from DataStax.