Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen
Created September 18, 2014 10:09
Show Gist options
  • Save PMeinshausen/6eaa5447042379f55951 to your computer and use it in GitHub Desktop.
Save PMeinshausen/6eaa5447042379f55951 to your computer and use it in GitHub Desktop.
--Syntax (version 1.1)
SELECT * FROM DWT2D(
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')
METATABLE('meta_table_name')
INPUTCOLUMNS('col1', 'col2',...,'colN')
[PARTITIONCOLUMNS('partition_column_name1',
'partition_column_name2',...,'partition_column_nameN')]
INDEXCOLUMNS('indexy_column_name','indexx_column_name')
[RANGE('(starty,startx),(endy,endx)')]
[WAVELETNAME('wavelet_name') |
WAVELETFILTERTABLE('wavelet_filter_table_name')]
LEVEL(level)
[EXTENSIONMODE('extension_mode')]
[COMPACTOUTPUT('true'|'false')]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment