Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen
Created September 18, 2014 10:29
Show Gist options
  • Select an option

  • Save PMeinshausen/39a4960a9c5c3b60d1f5 to your computer and use it in GitHub Desktop.

Select an option

Save PMeinshausen/39a4960a9c5c3b60d1f5 to your computer and use it in GitHub Desktop.
--Syntax (version 1.1)
SELECT * FROM IDWT2D(
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')]
[COMACTOUTPUT('true'|'false')]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment