Getting incorrect index when using redis-cli -pipe to read a csv file

Asked May 31 '16 at 14:23

Active Jun 01 '16 at 08:22

Viewed 167 times

I am using this tutorial to read a CSV file using redis-cli -pipe.

The structure of my csv file is:

0,  col1  ,   col2  ,  col3  ,.......,  col20  
1,11222323, random- , ----ww ,......., text    

and so on

Now, I am running this command:

awk -F, 'NR > 1{ print "SET", "\"Number_"$1"\"", "\""$0"\"" }' redis_csv_number_file_2.csv | src/redis-cli --pipe

Found that that this command isn't working at all. Any reasons why it wouldn't work?

edited Jun 01 '16 at 08:22

asked May 31 '16 at 14:23

delalli

1

do you have pipe "|" or comma"," in your input csv ? if pipe use "awk -F\|" – Chet May 31 '16 at 14:35
@Chet It is comma only. – delalli May 31 '16 at 14:38
Please can you edit the same in question and add few lines from your csv? – Chet May 31 '16 at 14:39
@Chet Found that redis is taking `Integer_Col2' values as keys too, while I want it all to be from the first column and it is an anomaly. – delalli May 31 '16 at 14:40
@Chet Updated the question. – delalli May 31 '16 at 14:42

0 Answers0