我收到以下错误
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;
我正在使用启用了 Timescaledb 的 Azure Database for PostgreSQL 服务器。
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/
这是因为 Azure Database for PostgreSQL 服务器不具备所有功能还是其他原因?谢谢!