You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by 苗强 <92...@qq.com> on 2020/06/10 07:44:03 UTC
关于from_unixtime查询性能问题
各位开发同学们好!
咨询一个问题,当我在doris使用from_unixtime函数时,耗时非常久,请问下有好的解决办法或规避措施没呢?
mysql> select count(installed_at) from table_xx;
+-----------------------+
| count(`installed_at`) |
+-----------------------+
| 3208506 |
+-----------------------+
1 row in set (0.77 sec)
mysql> select count(from_unixtime(installed_at)) from table_xx;
+--------------------------------------+
| count(from_unixtime(`installed_at`)) |
+--------------------------------------+
| 3208506 |
+--------------------------------------+
1 row in set (2 min 14.86 sec)
查询结果如上所示,installed_at字段类型int(10), 未设置time_zone
回复: 关于from_unixtime查询性能问题
Posted by 苗强 <92...@qq.com>.
用最新的master分支编译升级后,问题解决!
感谢!
------------------ 原始邮件 ------------------
发件人: "Zhao Chun"<zhaoc@apache.org>;
发送时间: 2020年6月10日(星期三) 下午5:36
收件人: "dev"<dev@doris.apache.org>;
主题: Re: 关于from_unixtime查询性能问题
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
苗强 <920555980@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
Re: 关于from_unixtime查询性能问题
Posted by Zhao Chun <zh...@apache.org>.
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
苗强 <92...@qq.com> 于2020年6月10日周三 下午3:44写道:
> 各位开发同学们好!
> 咨询一个问题,当我在doris使用from_unixtime函数时,耗时非常久,请问下有好的解决办法或规避措施没呢?
>
>
> mysql> select count(installed_at) from table_xx;
> +-----------------------+
> | count(`installed_at`) |
> +-----------------------+
> | 3208506 |
> +-----------------------+
> 1 row in set (0.77 sec)
>
>
> mysql> select count(from_unixtime(installed_at)) from table_xx;
> +--------------------------------------+
> | count(from_unixtime(`installed_at`)) |
> +--------------------------------------+
> |
> 3208506 |
> +--------------------------------------+
> 1 row in set (2 min 14.86 sec)
>
>
> 查询结果如上所示,installed_at字段类型int(10), 未设置time_zone