yum upgrade doesn't allow existing db use new window functions
Hi, I ran: yum upgrade MonetDB-SQL-server5 MonetDB-client When I create a new db I can call: select first_value(col1) over (partition by col2) from analytics; as per the blog monetdb.org/blog/extended_sql_window_functions However a db that existed before the update returns: Function first_value not found. I can see first_value in sys.functions. Any suggestions? Thanks!
Hi! I dont know why, but sometimes you need to the prefix sys. to the function to make it happend. Try the following: select *sys.*first_value(col1) over (partition by col2) from analytics; Rgds Ariel On Tue, Jul 9, 2019 at 1:44 PM Andy Allaway <heyitsmeandy@outlook.com> wrote:
Hi, I ran: yum upgrade MonetDB-SQL-server5 MonetDB-client
When I create a new db I can call:
select first_value(col1) over (partition by col2) from analytics;
as per the blog monetdb.org/blog/extended_sql_window_functions
However a db that existed before the update returns: Function first_value not found.
I can see first_value in sys.functions.
Any suggestions?
Thanks! _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
That worked - Thanks! From: Ariel Abadi Sent: Tuesday, July 9, 11:49 AM Subject: Re: yum upgrade doesn't allow existing db use new window functions To: Communication channel for MonetDB users Hi! I dont know why, but sometimes you need to the prefix sys. to the function to make it happend. Try the following: select sys.first_value(col1) over (partition by col2) from analytics; Rgds Ariel On Tue, Jul 9, 2019 at 1:44 PM Andy Allaway <heyitsmeandy@outlook.com<mailto:heyitsmeandy@outlook.com>> wrote: Hi, I ran: yum upgrade MonetDB-SQL-server5 MonetDB-client When I create a new db I can call: select first_value(col1) over (partition by col2) from analytics; as per the blog monetdb.org/blog/extended_sql_window_functions<http://monetdb.org/blog/extended_sql_window_functions> However a db that existed before the update returns: Function first_value not found. I can see first_value in sys.functions. Any suggestions? Thanks! _______________________________________________ users-list mailing list users-list@monetdb.org<mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Andy Allaway -
Ariel Abadi