CODEWITHSUNDEEP
csvubuntucassandradatastax
wundolab
wundolab

Reputation: 175

DatastaxBulk loader problem with null headers

I have a .csv file to load on Apache Cassandra with DatastaxBulk Loader. So, I have 10 columns to load, every column has a float values but the first one have no header.

So, many timest I have and error that consist in failure load for the table because I have to map all headers...I don't know how solve this situation. Somen suggestion? Thank you very much.

Upvotes: 1

Views: 265

Answers (1)

Alex Ott
Alex Ott

Reputation: 87184

Without header, DSBulk doesn't know how to map values from CSV into your table. So you must to use the -m option to provide the mapping between CSV columns & columns of the table, like this:

dsbulk load -url path.csv -k keyspace -t table -header false \
  -m "0=table_col1, 1=table_col2, 2=..."

P.S. I already posted links to the blog posts about DSBulk in answer to your earlier question, so just look into the first two of them.

Upvotes: 2

Related Questions