sdf-labs / sql-functions

7 stars 0 forks source link

Missing function stubs #54

Open sadboy opened 1 week ago

sadboy commented 1 week ago

Describe the bug We don't have stubs for the following Trino functions:

error: Failed to parse 111 functions:
 bitwise_or_agg: Internal error: [BUG] rust function trino::bitwise_or_agg_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 bool_or: Internal error: [BUG] rust function trino::bool_or_boolean is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 covar_pop: Internal error: [BUG] rust function trino::covar_pop_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 covar_pop: Internal error: [BUG] rust function trino::covar_pop_real_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 evaluate_classifier_predictions: Internal error: [BUG] rust function trino::evaluate_classifier_predictions_bigint_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 evaluate_classifier_predictions: Internal error: [BUG] rust function trino::evaluate_classifier_predictions_varchar_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 count_if: Internal error: [BUG] rust function trino::count_if_boolean is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 map_union: Internal error: [BUG] rust function trino::map_union_map_4_5 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 min_by: Internal error: [BUG] rust function trino::min_by_5_4_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 min_by: Internal error: [BUG] rust function trino::min_by_5_4 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 geometry_union_agg: Internal error: [BUG] rust function trino::geometry_union_agg_geometry is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 covar_samp: Internal error: [BUG] rust function trino::covar_samp_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 covar_samp: Internal error: [BUG] rust function trino::covar_samp_real_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_libsvm_regressor: Internal error: [BUG] rust function trino::learn_libsvm_regressor_bigint_map_bigint_double_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_libsvm_regressor: Internal error: [BUG] rust function trino::learn_libsvm_regressor_double_map_bigint_double_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 var_pop: Internal error: [BUG] rust function trino::var_pop_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 var_pop: Internal error: [BUG] rust function trino::var_pop_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 histogram: Internal error: [BUG] rust function trino::histogram_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 variance: Internal error: [BUG] rust function trino::variance_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 variance: Internal error: [BUG] rust function trino::variance_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 stddev: Internal error: [BUG] rust function trino::stddev_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 avg: Internal error: [BUG] rust function trino::avg_intervaldaytosecond is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 avg: Internal error: [BUG] rust function trino::avg_intervalyeartomonth is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 arbitrary: Internal error: [BUG] rust function trino::arbitrary_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 numeric_histogram: Internal error: [BUG] rust function trino::numeric_histogram_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 numeric_histogram: Internal error: [BUG] rust function trino::numeric_histogram_bigint_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 numeric_histogram: Internal error: [BUG] rust function trino::numeric_histogram_bigint_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 numeric_histogram: Internal error: [BUG] rust function trino::numeric_histogram_bigint_real_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 make_set_digest: Internal error: [BUG] rust function trino::make_set_digest_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 tdigest_agg: Internal error: [BUG] rust function trino::tdigest_agg_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 tdigest_agg: Internal error: [BUG] rust function trino::tdigest_agg_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 lead: Internal error: [BUG] rust function trino::lead_1_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 lead: Internal error: [BUG] rust function trino::lead_1_bigint_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_most_frequent: Internal error: [BUG] rust function trino::approx_most_frequent_bigint_bigint_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_most_frequent: Internal error: [BUG] rust function trino::approx_most_frequent_bigint_varchar_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 bitwise_and_agg: Internal error: [BUG] rust function trino::bitwise_and_agg_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 checksum: Internal error: [BUG] rust function trino::checksum_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_distinct: Internal error: [BUG] rust function trino::approx_distinct_boolean is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_distinct: Internal error: [BUG] rust function trino::approx_distinct_boolean_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_distinct: Internal error: [BUG] rust function trino::approx_distinct_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_distinct: Internal error: [BUG] rust function trino::approx_distinct_1_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_distinct: Internal error: [BUG] rust function trino::approx_distinct_unknown is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_distinct: Internal error: [BUG] rust function trino::approx_distinct_unknown_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 spatial_partitioning: Internal error: [BUG] rust function trino::spatial_partitioning_geometry is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 listagg: Internal error: [BUG] rust function trino::listagg_varchar_varchar_boolean_varchar_boolean is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 multimap_agg: Internal error: [BUG] rust function trino::multimap_agg_4_5 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 lag: Internal error: [BUG] rust function trino::lag_1_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 lag: Internal error: [BUG] rust function trino::lag_1_bigint_1 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 map_agg: Internal error: [BUG] rust function trino::map_agg_4_5 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 every: Internal error: [BUG] rust function trino::every_boolean is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 max: Internal error: [BUG] rust function trino::max_3_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_libsvm_classifier: Internal error: [BUG] rust function trino::learn_libsvm_classifier_bigint_map_bigint_double_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_libsvm_classifier: Internal error: [BUG] rust function trino::learn_libsvm_classifier_double_map_bigint_double_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_libsvm_classifier: Internal error: [BUG] rust function trino::learn_libsvm_classifier_varchar_map_bigint_double_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 kurtosis: Internal error: [BUG] rust function trino::kurtosis_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 kurtosis: Internal error: [BUG] rust function trino::kurtosis_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_set: Internal error: [BUG] rust function trino::approx_set_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_set: Internal error: [BUG] rust function trino::approx_set_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_set: Internal error: [BUG] rust function trino::approx_set_varchar is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 min: Internal error: [BUG] rust function trino::min_3_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 max_by: Internal error: [BUG] rust function trino::max_by_5_4_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 max_by: Internal error: [BUG] rust function trino::max_by_5_4 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 regr_slope: Internal error: [BUG] rust function trino::regr_slope_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 regr_slope: Internal error: [BUG] rust function trino::regr_slope_real_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 corr: Internal error: [BUG] rust function trino::corr_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 corr: Internal error: [BUG] rust function trino::corr_real_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 geometric_mean: Internal error: [BUG] rust function trino::geometric_mean_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 geometric_mean: Internal error: [BUG] rust function trino::geometric_mean_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 geometric_mean: Internal error: [BUG] rust function trino::geometric_mean_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 convex_hull_agg: Internal error: [BUG] rust function trino::convex_hull_agg_geometry is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_regressor: Internal error: [BUG] rust function trino::learn_regressor_bigint_map_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_regressor: Internal error: [BUG] rust function trino::learn_regressor_double_map_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_bigint_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_bigint_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_double_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_double_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_real_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 qdigest_agg: Internal error: [BUG] rust function trino::qdigest_agg_real_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 reduce_agg: Internal error: [BUG] rust function trino::reduce_agg_1_10_function_10_1_10_function_10_10_10 is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 bool_and: Internal error: [BUG] rust function trino::bool_and_boolean is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 merge_set_digest: Internal error: [BUG] rust function trino::merge_set_digest_setdigest is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 merge: Internal error: [BUG] rust function trino::merge_hyperloglog is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 merge: Internal error: [BUG] rust function trino::merge_qdigest is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 merge: Internal error: [BUG] rust function trino::merge_tdigest is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_bigint_array_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_bigint_double_array_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_double_array_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_double_double_array_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_real_array_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_real_double_array_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_bigint_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_bigint_double_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_double_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_double_double_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_real_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_real_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 approx_percentile: Internal error: [BUG] rust function trino::approx_percentile_real_double_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 skewness: Internal error: [BUG] rust function trino::skewness_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 skewness: Internal error: [BUG] rust function trino::skewness_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 regr_intercept: Internal error: [BUG] rust function trino::regr_intercept_double_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 regr_intercept: Internal error: [BUG] rust function trino::regr_intercept_real_real is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 var_samp: Internal error: [BUG] rust function trino::var_samp_bigint is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 var_samp: Internal error: [BUG] rust function trino::var_samp_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_classifier: Internal error: [BUG] rust function trino::learn_classifier_bigint_map_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_classifier: Internal error: [BUG] rust function trino::learn_classifier_double_map_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
 learn_classifier: Internal error: [BUG] rust function trino::learn_classifier_varchar_map_bigint_double is missing an implementation.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Additional context Add any other context about the problem here.

wizardxz commented 1 week ago

@sadboy That's aggregation functions. where did you repro this errors?

sadboy commented 1 week ago

There are scalars in there. Regardless we need stubs for everything declared in the yamk

wizardxz commented 1 week ago
  1. The scalar template and aggregate template are different. We don't have a good aggregate template yet.
  2. Which functions are scalar in your list?
  3. where did you see these errors?