Version 1.7
SELECT * FROM CFilter ( ON (SELECT 1) PARTITION BY 1 [ Domain ('host:port') ] [ Database ('db_name') ] [ UserID ('user_id') ] [ Password ('password') ] [ SSLSettings ('SSLsettings') ] [ SSLTrustStorePassword ('SSLtruststorepassword') ] InputTable ('input_table') OutputTable ('output_table') InputColumns ({ 'input_column' | 'input_column_range' }[,...]) JoinColumns ({ 'join_column' | 'join_column_range' }[,...]) [ AddColumns ({ 'add_column' | 'add_column_range' } [,...]) ] [ PartitionKeyColumn ('partition_key_column') ] [ MaxItemSet ('max_item_set') ] [ DropTable ({'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'}) ] );
For information about the authentication arguments, refer to the following usage notes in Aster Analytics Foundation User Guide, Chapter 2:
- Connecting to Aster Database Using Authentication Cascading
- Connecting to Aster Database Using SSL JDBC Connections