Re: Encountered some problems when querying data

Posted by Liang Chen on Oct 16, 2017; 11:27am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Encountered-some-problems-when-querying-data-tp24114p24122.html

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/