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. --------------------------------------------------------------------------------------------------- |
Administrator
|
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/ |
Free forum by Nabble | Edit this page |