Encountered some problems when querying data

Posted by 刘feng on Oct 16, 2017; 9:45am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Encountered-some-problems-when-querying-data-tp24114.html

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.
---------------------------------------------------------------------------------------------------