Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen
Created September 18, 2014 16:58
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 PMeinshausen/b450a5cae39b672ba909 to your computer and use it in GitHub Desktop.
Save PMeinshausen/b450a5cae39b672ba909 to your computer and use it in GitHub Desktop.
--Syntax (version 1.0)
SELECT * FROM LARS(
ON (SELECT 1)
PARTITION BY 1
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
[SSLTRUSTSTOREPASSWORD('SSLtruststorepassword')]
INPUTTABLE('input_table_name')
OUTPUTTABLE('output_table_name')
COLUMNNAMES('Y', 'X1', 'X2', ..., 'Xp')
[METHOD('lar' | 'lasso')]
[INTERCEPT('true' | 'false')]
[NORMALIZE('true' | 'false')]
[MAXITERNUM('max_iterations')]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment