Encountered some problems when querying data

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Encountered some problems when querying data

刘feng
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.
---------------------------------------------------------------------------------------------------
Reply | Threaded
Open this post in threaded view
|

Re: Encountered some problems when querying data

Liang Chen
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/