Hello, We use MonetDB Jan2014-SP2. When I try MEDIAN function it simply says: MEDIAN: no such operator 'median(double)' [SQL State=22000] Am I missing something? I tried to execute section of 39_analytics.sql containing the MEDIAN function. It says MEDIAN function is already there. Thank you for any tips. Radovan Test Case: I took the sql from bug 2454: select median(id) from sys.tables; result: An error occurred when executing the SQL command: select median(id) from sys.tables MEDIAN: no such operator 'median(int)' [SQL State=22000] Execution time: 0.03s 1 statement failed.
hi radovan could you give a reproducible example? using jan 2014-sp2, this code works just fine for me :) create table test (a DOUBLE , b INT) ; INSERT INTO test (a , b) VALUES (0.1 , 0); INSERT INTO test (a, b) VALUES (1.1 , 1) ; INSERT INTO test (a, b) VALUES (2.1 , 2) ; SELECT MEDIAN( a ) , MEDIAN( b ) FROM test; On Fri, Aug 8, 2014 at 8:22 AM, Radovan Bičiště < radovan.biciste@ceosdata.com> wrote:
Hello, We use MonetDB Jan2014-SP2. When I try MEDIAN function it simply says: MEDIAN: no such operator 'median(double)' [SQL State=22000]
Am I missing something? I tried to execute section of 39_analytics.sql containing the MEDIAN function. It says MEDIAN function is already there.
Thank you for any tips.
Radovan
Test Case: I took the sql from bug 2454: select median(id) from sys.tables;
result: An error occurred when executing the SQL command: select median(id) from sys.tables
MEDIAN: no such operator 'median(int)' [SQL State=22000]
Execution time: 0.03s
1 statement failed. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi, it works as monetdb but does not as regular user. As a regular user I have to use sys.median .... Thanks On 08/08/2014 02:30 PM, Anthony Damico wrote:
create table test (a DOUBLE , b INT) ; INSERT INTO test (a , b) VALUES (0.1 , 0); INSERT INTO test (a, b) VALUES (1.1 , 1) ; INSERT INTO test (a, b) VALUES (2.1 , 2) ; SELECT MEDIAN( a ) , MEDIAN( b ) FROM test;
participants (2)
-
Anthony Damico -
Radovan Bičiště