Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen
Created September 18, 2014 10:25
Show Gist options
  • Save PMeinshausen/b0e0bdbab4399c948543 to your computer and use it in GitHub Desktop.
Save PMeinshausen/b0e0bdbab4399c948543 to your computer and use it in GitHub Desktop.
--This syntax assumes that each sequence can be fitted into the memory of the worker.
--Syntax (version 1.1)
SELECT * FROM IDWT(
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')
METATABLE('meta_table_name')
OUTPUTTABLE('output_table_name')
INPUTCOLUMNS('col1', 'col2',...,'colN')
SORTCOLUMN('sort_column_name')
[PARTITIONCOLUMNS('partition_column_name1',
'partition_column_name2',...,'partition_column_nameN')]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment