Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

file-import option insert key-value pair with set command #131

Open
fabian23test opened this issue Aug 23, 2023 · 0 comments
Open

file-import option insert key-value pair with set command #131

fabian23test opened this issue Aug 23, 2023 · 0 comments

Comments

@fabian23test
Copy link

Hi all,

I am trying to use RIOT for a mass upload of data from the CSV file. I have used the following command:

riot file-import --header set --keyspace myKeySpace --keys PhoneNo

the CSV looks like:

"PhoneNo","Name"
"0199000222","Benjamin Friedrich"
"0199000221","Eric Bahr"

and it works. The data structure that is created in Redis has the following format:

key: 0199000222
value: {"PhoneNo":"0199000222","Name":"Benjamin Friedrich"}

key: 0199000221
value: {"PhoneNo":"0199000221","Name":"Erich Bahr"}

However, the structure is not exactly what I am looking for. I would like a more simple structure, something like:

key: 0199000222
value: Benjamin Friedrich

key: 0199000221
value: Eric Bahr

How can I achieve that using the riot tool?

Thanks for your time and consideration.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant