Line data    Source code

       1             : unsigned char _39_analytics_hge_sql[2720] = {
       2             : "create aggregate stddev_samp(val HUGEINT) returns DOUBLE\n"
       3             : "  external name \"aggr\".\"stdev\";\n"
       4             : "GRANT EXECUTE ON AGGREGATE stddev_samp(HUGEINT) TO PUBLIC;\n"
       5             : "create window stddev_samp(val HUGEINT) returns DOUBLE\n"
       6             : "  external name \"sql\".\"stdev\";\n"
       7             : "GRANT EXECUTE ON WINDOW stddev_samp(HUGEINT) TO PUBLIC;\n"
       8             : "create aggregate stddev_pop(val HUGEINT) returns DOUBLE\n"
       9             : "  external name \"aggr\".\"stdevp\";\n"
      10             : "GRANT EXECUTE ON AGGREGATE stddev_pop(HUGEINT) TO PUBLIC;\n"
      11             : "create window stddev_pop(val HUGEINT) returns DOUBLE\n"
      12             : "  external name \"sql\".\"stdevp\";\n"
      13             : "GRANT EXECUTE ON WINDOW stddev_pop(HUGEINT) TO PUBLIC;\n"
      14             : "create aggregate var_samp(val HUGEINT) returns DOUBLE\n"
      15             : "  external name \"aggr\".\"variance\";\n"
      16             : "GRANT EXECUTE ON AGGREGATE var_samp(HUGEINT) TO PUBLIC;\n"
      17             : "create window var_samp(val HUGEINT) returns DOUBLE\n"
      18             : "  external name \"sql\".\"variance\";\n"
      19             : "GRANT EXECUTE ON WINDOW var_samp(HUGEINT) TO PUBLIC;\n"
      20             : "create aggregate covar_samp(e1 HUGEINT, e2 HUGEINT) returns DOUBLE\n"
      21             : "  external name \"aggr\".\"covariance\";\n"
      22             : "GRANT EXECUTE ON AGGREGATE covar_samp(HUGEINT, HUGEINT) TO PUBLIC;\n"
      23             : "create window covar_samp(e1 HUGEINT, e2 HUGEINT) returns DOUBLE\n"
      24             : "  external name \"sql\".\"covariance\";\n"
      25             : "GRANT EXECUTE ON WINDOW covar_samp(HUGEINT, HUGEINT) TO PUBLIC;\n"
      26             : "create aggregate var_pop(val HUGEINT) returns DOUBLE\n"
      27             : "  external name \"aggr\".\"variancep\";\n"
      28             : "GRANT EXECUTE ON AGGREGATE var_pop(HUGEINT) TO PUBLIC;\n"
      29             : "create window var_pop(val HUGEINT) returns DOUBLE\n"
      30             : "  external name \"sql\".\"variancep\";\n"
      31             : "GRANT EXECUTE ON WINDOW var_pop(HUGEINT) TO PUBLIC;\n"
      32             : "create aggregate covar_pop(e1 HUGEINT, e2 HUGEINT) returns DOUBLE\n"
      33             : "  external name \"aggr\".\"covariancep\";\n"
      34             : "GRANT EXECUTE ON AGGREGATE covar_pop(HUGEINT, HUGEINT) TO PUBLIC;\n"
      35             : "create window covar_pop(e1 HUGEINT, e2 HUGEINT) returns DOUBLE\n"
      36             : "  external name \"sql\".\"covariancep\";\n"
      37             : "GRANT EXECUTE ON WINDOW covar_pop(HUGEINT, HUGEINT) TO PUBLIC;\n"
      38             : "create aggregate median(val HUGEINT) returns HUGEINT\n"
      39             : "  external name \"aggr\".\"median\";\n"
      40             : "GRANT EXECUTE ON AGGREGATE median(HUGEINT) TO PUBLIC;\n"
      41             : "create aggregate quantile(val HUGEINT, q DOUBLE) returns HUGEINT\n"
      42             : "  external name \"aggr\".\"quantile\";\n"
      43             : "GRANT EXECUTE ON AGGREGATE quantile(HUGEINT, DOUBLE) TO PUBLIC;\n"
      44             : "create aggregate median_avg(val HUGEINT) returns DOUBLE\n"
      45             : "  external name \"aggr\".\"median_avg\";\n"
      46             : "GRANT EXECUTE ON AGGREGATE median_avg(HUGEINT) TO PUBLIC;\n"
      47             : "create aggregate quantile_avg(val HUGEINT, q DOUBLE) returns DOUBLE\n"
      48             : "  external name \"aggr\".\"quantile_avg\";\n"
      49             : "GRANT EXECUTE ON AGGREGATE quantile_avg(HUGEINT, DOUBLE) TO PUBLIC;\n"
      50             : "create aggregate corr(e1 HUGEINT, e2 HUGEINT) returns DOUBLE\n"
      51             : "  external name \"aggr\".\"corr\";\n"
      52             : "GRANT EXECUTE ON AGGREGATE corr(HUGEINT, HUGEINT) TO PUBLIC;\n"
      53             : "create window corr(e1 HUGEINT, e2 HUGEINT) returns DOUBLE\n"
      54             : "  external name \"sql\".\"corr\";\n"
      55             : "GRANT EXECUTE ON WINDOW corr(HUGEINT, HUGEINT) TO PUBLIC;\n"
      56             : };
      57             : #include "monetdb_config.h"
      58             : #include "sql_import.h"
      59             : #ifdef _MSC_VER
      60             : #undef read
      61             : #pragma section(".CRT$XCU",read)
      62             : #endif
      63         326 : LIB_STARTUP_FUNC(init_39_analytics_hge_sql)
      64         326 : { sql_register("39_analytics_hge", _39_analytics_hge_sql); }