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/11 02:00:37 UTC

回复： 关于from_unixtime查询性能问题

用最新的master分支编译升级后，问题解决！
感谢！


&nbsp;




------------------&nbsp;原始邮件&nbsp;------------------
发件人:&nbsp;"Zhao Chun"<zhaoc@apache.org&gt;;
发送时间:&nbsp;2020年6月10日(星期三) 下午5:36
收件人:&nbsp;"dev"<dev@doris.apache.org&gt;;

主题:&nbsp;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&gt; 于2020年6月10日周三 下午3:44写道：

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