hi i would like to know anyone facing issue after creating a pipeline and loading a csv file into the singlestore , for unknown reason i unable to filter the value in the last column in sql of this newly loaded table . Column type is VARCHAR(64) , the only way to perform filter is xx like ‘%abcksd%’ , but unable with xx = ’ abcksd’
the source csv file is exported from ms excel , scp to server and loaded into singlestore with pipeline
below is the command used :
CREATE PIPELINE imp_xtmp_table_mapping
AS LOAD DATA FS ‘/sq/lb/poiv5*.csv’
INTO TABLE xtmp_tb1_p_mapping
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘’ ESCAPED BY ‘\’
LINES TERMINATED BY ‘\n’ STARTING BY ‘’ ;
CREATE TABLE xtmp_table_mapping (
si VARCHAR(64) ,
br VARCHAR(64) ,
pi VARCHAR(64) ,
KEY (pi) USING CLUSTERED COLUMNSTORE,
key(si) using hash,
FULLTEXT ( si , br , pi )
);
select * from xtmp_table_mapping where pi = ’ abcksd’
this return empty results
i have double check and trim all field in excel . but it still the same .
anyone have idea what is the issue ? thank you
