Skip to content

Instantly share code, notes, and snippets.

@betterdatascience

betterdatascience/regression.sql

Created November 9, 2020 20:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save betterdatascience/0f9abe29319a20438e45d1491ec01e59 to your computer and use it in GitHub Desktop.
Save betterdatascience/0f9abe29319a20438e45d1491ec01e59 to your computer and use it in GitHub Desktop.
Download ZIP
002_sql_regression
Raw
regression.sql
BEGIN
EXECUTE IMMEDIATE
'CREATE OR REPLACE VIEW
housing_train_data AS
SELECT * FROM housingprices
SAMPLE (75) SEED (42)';
EXECUTE IMMEDIATE
'CREATE OR REPLACE VIEW
housing_test_data AS
SELECT * FROM housingprices
MINUS
SELECT * FROM housing_train_data';
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment