0.00.0100005050NY50000YN1000100fruitsY1masterlocalhost9090clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Yslave1localhost9091clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Nslave2localhost9092clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8NMyCluster4000020005000YNmasterslave1slave2-2015/04/28 14:24:20.479-2015/04/28 14:24:20.479AgileBIlocalhostMONETDBNativepentaho-instaview50000monetdbEncrypted 2be98afc86aa7f2e4cb14a17edb86abd8trueEXTRA_OPTION_INFOBRIGHT.characterEncodingUTF-8EXTRA_OPTION_MYSQL.defaultFetchSize500EXTRA_OPTION_MYSQL.useCursorFetchtruePORT_NUMBER50000PRESERVE_RESERVED_WORD_CASEYSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYbackoffice${VAR_DB_BACKOFFICE_HOST}POSTGRESQLNative${VAR_DB_BACKOFFICE_NAME}${VAR_DB_BACKOFFICE_PORT}${VAR_DB_BACKOFFICE_USER}${VAR_DB_BACKOFFICE_PW}FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_BACKOFFICE_PORT}QUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYUSE_POOLINGNdwh${VAR_DB_DMA_HOST}POSTGRESQLNative${VAR_DB_DMA_NAME}${VAR_DB_DMA_PORT}${VAR_DB_DMA_USER}${VAR_DB_DMA_PW}FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_DMA_PORT}PRESERVE_RESERVED_WORD_CASENQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPENUSE_POOLINGNdwh_ro${VAR_DB_DMA_HOST}POSTGRESQLNative${VAR_DB_DMA_NAME}${VAR_DB_DMA_PORT}${VAR_DB_DMA_USER_RO}${VAR_DB_DMA_PW_RO}FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_DMA_PORT}PRESERVE_RESERVED_WORD_CASENQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPENUSE_POOLINGNgenericlocalhostGENERICJNDI${param_db_connection}5432Encrypted FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER5432PRESERVE_RESERVED_WORD_CASENQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGNlogs${VAR_DB_LOG_HOST}POSTGRESQLNative${VAR_DB_LOG_NAME}${VAR_DB_LOG_PORT}${VAR_DB_LOG_USER}${VAR_DB_LOG_PW}EXTRA_OPTION_POSTGRESQL.SEQUENCE_FOR_BATCH_IDseq_loggingFORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_LOG_PORT}PREFERRED_SCHEMA_NAME${VAR_DB_LOG_SCHEMA}PRESERVE_RESERVED_WORD_CASENQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPENUSE_POOLINGNqa${VAR_DB_QA_HOST}POSTGRESQLNative${VAR_DB_QA_NAME}${VAR_DB_QA_PORT}${VAR_DB_QA_USER}${VAR_DB_QA_PW}FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_QA_PORT}PREFERRED_SCHEMA_NAME${VAR_DB_QA_SCHEMA}QUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPENUSE_POOLINGNstaging${VAR_DB_STAGING_HOST}POSTGRESQLNative${VAR_DB_STAGING_NAME}${VAR_DB_STAGING_PORT}${VAR_DB_STAGING_USER}${VAR_DB_STAGING_PW}FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_STAGING_PORT}PRESERVE_RESERVED_WORD_CASENQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPENUSE_POOLINGNteradata${VAR_DB_TERADATA_HOST}TERADATANative${VAR_DB_TERADATA_NAME}${VAR_DB_TERADATA_PORT}${VAR_DB_TERADATA_USER}${VAR_DB_TERADATA_PW}EXTRA_OPTION_TERADATA.DBS_PORT${VAR_DB_TERADATA_PORT}EXTRA_OPTION_TERADATA.charsetUTF8EXTRA_OPTION_TERADATA.tmodeANSIFORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER${VAR_DB_TERADATA_PORT}QUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPENUSE_POOLINGNData GridMemory Group byYMemory Group byWrite to logYData GridDataGridY1nonefruitString-1-1NquantityInteger-1-1Nbananas3bananas234bananas463bananas36apples3466apples243grapes436grapes234grapes45714496YMemory Group byMemoryGroupByY3ModPartitionerfruitsfruitNfruitquantityquantitySUMMyCluster28896YWrite to logWriteToLogY1nonelog_level_basicYN0=== FINAL RESULTSET ===fruitquantity43296YN