我收到以下错误
SQL Error [0A000]: ERROR: functionality not supported under the current license "ApacheOnly", license¶ Hint: Upgrade to a Timescale-licensed binary to access this free community feature
运行以下代码时:
CREATE VIEW test.weather_metrics_daily
WITH (timescaledb.continuous)
AS
SELECT
time_bucket('1 day', time) as bucket,
city_name,
avg(temp_c) as avg_temp,
avg(feels_like_c) as feels_like_temp,
max(temp_c) as max_temp,
min(temp_c) as min_temp,
avg(pressure_hpa) as pressure,
avg(humidity_percent) as humidity_percent,
avg(rain_3h_mm) as rain_3h,
avg(snow_3h_mm) as snow_3h,
avg(wind_speed_ms) as wind_speed,
avg(clouds_percent) as clouds
FROM
test.weather_metrics
GROUP BY bucket, city_name;
我正在为PostgreSQL服务器使用Azure数据库,启用了Timescaledb。
SELECT default_version, installed_version FROM pg_available_extensions
where name = 'timescaledb';
I get the version 1.7.4 on both
我正在跟踪入门文档:https://docs.timescale.com/timescaledb/latest/getting-started/
这是因为PostgreSQL服务器的Azure数据库不具备所有功能或其他功能吗?谢谢!
发布于 2021-08-31 08:12:00
Мелкий 在https://dba.stackexchange.com/q/298765/185681上的回答
这是因为Azure是一种云服务,因此不能提供免费的TimescaleDB“社区”许可。根据TimescaleDB常见问题解答:
TimescaleDB是一个用于时间序列的关系数据库,有些特性是在Apache2.0许可下授权的,但是您所知道和喜爱的许多特性都是通过时间尺度许可(包括连续聚合、压缩、数据保留策略、操作、多节点等)获得许可的。微软、数码海洋等公司提供的“Apache2.0”版TimescaleDB只包含Apache中的特性。时间刻度许可禁止云提供商提供TimescaleDB作为服务的“社区版本”.
。
https://stackoverflow.com/questions/68985789
复制相似问题