为什么较低的分位数大于较高的分位数？
为什么较低的分位数大于较高的分位数？
提问于 2017-06-28 03:06:18
这是我的query
SELECT
APPROX_QUANTILES(JSON_EXTRACT_SCALAR(lighthouse,
'$.audits.first-meaningful-paint.rawValue'),1000)[OFFSET(100)] AS p10,
APPROX_QUANTILES(JSON_EXTRACT_SCALAR(lighthouse,
'$.audits.first-meaningful-paint.rawValue'),1000)[OFFSET(250)] AS p25,
APPROX_QUANTILES(JSON_EXTRACT_SCALAR(lighthouse,
'$.audits.first-meaningful-paint.rawValue'),1000)[OFFSET(500)] AS p50,
APPROX_QUANTILES(JSON_EXTRACT_SCALAR(lighthouse,
'$.audits.first-meaningful-paint.rawValue'),1000)[OFFSET(750)] AS p75,
APPROX_QUANTILES(JSON_EXTRACT_SCALAR(lighthouse,
'$.audits.first-meaningful-paint.rawValue'),1000)[OFFSET(900)] AS p90
FROM
`httparchive.har.2017_06_01_android_pages`
WHERE
lighthouse != 'null'结果是：
Row p10 p25 p50 p75 p90
1 13223.9 2904.2 4851.2 6817 8352.1为什么p10 (13223.9)大于p90 (8352.1)？
编辑:这似乎是BigQuery的一个暂时性问题。我现在得到了预期的结果。提交了一个窃听器。
回答 1
Stack Overflow用户
回答已采纳
发布于 2017-06-28 03:28:59
输入的是字符串，而不是浮点数:)如果你想进行浮点排序，你需要强制转换：
SELECT
quantiles[OFFSET(100)] AS p10,
quantiles[OFFSET(250)] AS p25,
quantiles[OFFSET(500)] AS p50,
quantiles[OFFSET(750)] AS p75,
quantiles[OFFSET(900)] AS p90
FROM (
SELECT
APPROX_QUANTILES(CAST(JSON_EXTRACT_SCALAR(lighthouse,
'$.audits.first-meaningful-paint.rawValue') AS FLOAT64),1000) AS quantiles
FROM
`httparchive.har.2017_06_01_android_pages`
WHERE
lighthouse != 'null'
);
+--------+--------+--------+--------+---------+
| p10 | p25 | p50 | p75 | p90 |
+--------+--------+--------+--------+---------+
| 2578.7 | 3944.1 | 5781.3 | 8092.4 | 10785.5 |
+--------+--------+--------+--------+---------+页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/44788004
复制相关文章
相似问题
腾讯云开发者
