Apache Cassandra - Tutorial 12 - CQL - Importing and Exporting Data

Подписаться 8 тыс.

Просмотров 33 тыс.

50% 1

We can import and export data from Apache Cassandra database tables to basic csv files and vise versa.
This allows us to conveniently view what is in a Cassandra database table as well as quickly import data from a csv to a table.
These techniques are particular useful when we are building an application using Cassandra and want to quickly seed our database tables.

Наука

Опубликовано:

21 фев 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@gadeichhorn 5 лет назад

good work! keep them coming ;)

@babusaravanan5071 3 года назад

Good work, Really its helpful.

@sergeikharchikov1157 4 года назад

thank you very much!

@lakshmijagadeesh3403 4 года назад

Is there anyway to import nested json file into cassandra?

@quyenscc Год назад

Thank you for creating such amazing tutorial videos. They are very helpful. Thanks again. There is only one small thing: By the end of each video, you put the recommended videos for anyone interested. I do not know about other viewers, but I am very interested in your videos and do not need the recommendation to look for the next videos. So it does not help me much, indeed it is quite disturbing because I can not see clearly what code you put there when it comes to the end of the videos.

@mritunjay3723 2 года назад

can we just copy from a csv/excel without previously creating a table in cassandra..since in ML a dataset has 1000s of columns

@mrstanlez 2 года назад

very nice. How about creating table in cassandra from java, camel, etc ?

@vigneshwarreddy7442 3 года назад

HI ! All, can we use this copy command from python script ??? if yes, how should we do??? could you please provide me the solution....

@rjxl8 2 года назад

How can we get that csv file to follow along ?

@khanhgia6817 Год назад

What should we do if there are more than one sheet in the excel?

@mohamedaymenmenzer8833 5 лет назад

i have an error : invalid row length 1 should be 3 given up without retries what's the probléme here please ?

@codyloud265 5 лет назад

Open your file.csv with a notepad and check if it has this structure.. header1, header2, header3 val1, val2, val3 val11, val22, val33 Check if the delimiter is different from the comma, probably will be ';' and change it :)