Re: 关于from_unixtime查询性能问题

[Zhao Chun]

What's the version of your Doris.
This problem has been fixed, you can upgrade your Doris to master and then
check it.

Thanks,
Zhao Chun


苗强 <920555...@qq.com> 于2020年6月10日周三 下午3:44写道：

> 各位开发同学们好！
> 咨询一个问题，当我在doris使用from_unixtime函数时，耗时非常久，请问下有好的解决办法或规避措施没呢？
>
>
> mysql&gt; select count(installed_at) from table_xx;
> +-----------------------+
> | count(`installed_at`) |
> +-----------------------+
> |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3208506 |
> +-----------------------+
> 1 row in set (0.77 sec)
>
>
> mysql&gt; select count(from_unixtime(installed_at)) from table_xx;
> +--------------------------------------+
> | count(from_unixtime(`installed_at`)) |
> +--------------------------------------+
> |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3208506 |
> +--------------------------------------+
> 1 row in set (2 min 14.86 sec)
>
> &nbsp;
> 查询结果如上所示，installed_at字段类型int(10), 未设置time_zone