Allow usage of SQL Common Table Expressions in SQLManager

h2oai / h2o-3

H2O is an Open Source, Distributed, Fast & Scalable Machine Learning Platform: Deep Learning, Gradient Boosting (GBM) & XGBoost, Random Forest, Generalized Linear Modeling (GLM with Elastic Net), K-Means, PCA, Generalized Additive Models (GAM), RuleFit, Support Vector Machine (SVM), Stacked Ensembles, Automatic Machine Learning (AutoML), etc.

http://h2o.ai

Apache License 2.0

6.86k stars 1.99k forks source link

Allow usage of SQL Common Table Expressions in SQLManager #12258

Open exalate-issue-sync[bot] opened 1 year ago

exalate-issue-sync[bot] commented 1 year ago

Our user [~accountid:5a97e375228ed33491d07b31] reported an issue with SQLManager.

Currently, H2O-3 enforces all queries to start with "SELECT" Keyword. This does not allow our users to use Common Table Expressions.

The problem with SQLManager has been reported in https://0xdata.atlassian.net/browse/PUBDEV-5367 (commentary).

hasithjp commented 1 year ago

JIRA Issue Migration Info

Jira Issue: PUBDEV-5391 Assignee: New H2O Bugs Reporter: Pavel Pscheidl State: Open Fix Version: N/A Attachments: N/A Development PRs: N/A