Hi Can you raise an apache JIRA at : https://issues.apache.org/jira/projects/CARBONDATA and provide the test data and script, need to reproduce this issue.
Regards Liang 刘feng wrote > Hello，dev > > 1,When using the ‘like’query in sql, I found a bug. > > E.g: select ake005,count(1) from ca_08_kc22 where ake005 like '330100001%' > and akc225>10 group by ake005; > > Get sample data: > > +----------------+------+--+ > > | ake005 | _c1 | > > +----------------+------+--+ > > | 330100001 | 1 | > > | 110900005b | 1 | > > | 310902005B | 7 | > > | 14B0016RGG | 8 | > > | 311502004 | 1 | > > | 310517009 | 1 | > > | G050100212 | 2 | > > | 14D0018IJG | 1 | > > | 5411300000489 | 1 | > > | 120700001 | 3 | > > | G050600001 | 2 | > > | G090400050 | 1 | > > | ZCY2016674 | 1 | > > | CY2000127 | 1 | > > | 330100003 | 1 | > > | G070200011 | 1 | > > > > > > desc formatted ca_08_kc22; > > | ake005 string KEY COLUMN > > akc225 double MEASURE > > > > spark 1.6.2 > > carbondata 1.1.0 > > > > 2, When I load the data, how can the field be trimmed? > > > > Thanks & Regards, > > ---------------------------------------------------------------------------- > --------------------------- > > liufeng > > > > > > --------------------------------------------------------------------------------------------------- > Confidentiality Notice: The information contained in this e-mail and any > accompanying attachment(s) > is intended only for the use of the intended recipient and may be > confidential and/or privileged of > Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader > of this communication is > not the intended recipient, unauthorized use, forwarding, printing, > storing, disclosure or copying > is strictly prohibited, and may be unlawful.If you have received this > communication in error,please > immediately notify the sender by return e-mail, and delete the original > message and all copies from > your system. Thank you. > --------------------------------------------------------------------------------------------------- -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
