[ https://issues.apache.org/jira/browse/IGNITE-3626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15422560#comment-15422560 ]
Igor Sapego edited comment on IGNITE-3626 at 8/16/16 10:35 AM: --------------------------------------------------------------- I've tried connecting to Ignite with Tableau and took some logs. All I did was establishing single connection once and I've got results that you can find below. It seems like Tableau tries connecting two times with empty connect string first and runs some test queries. Again, this all happens during *single* connection. Tableau actually makes 3 connection attempts during one connection. First connection attempt with default arguments {noformat} Request: CREATE LOCAL TEMPORARY TABLE XTB_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTB_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT COL FROM (SELECT 1 AS COL) AS SUBQUERY Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT * INTO XTC_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP LIMIT 1 Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTC_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT 1 Result: Error: Cache doesn't exist (did you configure it?): null {noformat} Second connection attempt with default arguments {noformat} Request: CREATE LOCAL TEMPORARY TABLE XTB_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTB_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT COL FROM (SELECT 1 AS COL) AS SUBQUERY Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT * INTO XTC_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP LIMIT 1 Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTC_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT 1 Result: Error: Cache doesn't exist (did you configure it?): null {noformat} Connection with proper arguments {noformat} Request: CREATE LOCAL TEMPORARY TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Result: Error: Failed to parse query: CREATE LOCAL TEMPORARY TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Request: DROP TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect Result: Error: Unsupported query: DROP TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect Request: SELECT COL FROM (SELECT 1 AS COL) AS SUBQUERY Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT TOP 1 COL FROM (SELECT 1 AS COL) AS CHECKTOP Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT SUBCOL AS COL FROM (SELECT 1 AS SUBCOL) SUBQUERY GROUP BY 1 Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT SUBCOL AS COL FROM (SELECT 1 AS SUBCOL) SUBQUERY GROUP BY 2 Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT SUBCOL AS COL FROM (SELECT 1 AS SUBCOL) SUBQUERY GROUP BY COL Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT TOP 1 * INTO XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP Result: Error: Failed to parse query: SELECT TOP 1 * INTO XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP Request: DROP TABLE XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect Result: Error: Unsupported query: DROP TABLE XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect {noformat} was (Author: isapego): I've tried connecting to Ignite with Tableau and took some logs. All I did was establishing single connection once and I've got results that you can find below. It seems like Tableau tries connecting two times with empty connect string first and runs some test queries. First connection attempt with default arguments {noformat} Request: CREATE LOCAL TEMPORARY TABLE XTB_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTB_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT COL FROM (SELECT 1 AS COL) AS SUBQUERY Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT * INTO XTC_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP LIMIT 1 Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTC_A_FDEBJGEH_AFHI_EJAC_IGGC_EBJBCDCDCCB_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT 1 Result: Error: Cache doesn't exist (did you configure it?): null {noformat} Second connection attempt with default arguments {noformat} Request: CREATE LOCAL TEMPORARY TABLE XTB_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTB_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT COL FROM (SELECT 1 AS COL) AS SUBQUERY Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT * INTO XTC_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP LIMIT 1 Result: Error: Cache doesn't exist (did you configure it?): null Request: DROP TABLE XTC_A_HEDAAJBG_AFFG_EEHJ_JCAB_IECJAAGJEGD_Connect Result: Error: Cache doesn't exist (did you configure it?): null Request: SELECT 1 Result: Error: Cache doesn't exist (did you configure it?): null {noformat} Connection with proper arguments {noformat} Request: CREATE LOCAL TEMPORARY TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Result: Error: Failed to parse query: CREATE LOCAL TEMPORARY TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect (COL INTEGER) ON COMMIT PRESERVE ROWS Request: DROP TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect Result: Error: Unsupported query: DROP TABLE XTB_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect Request: SELECT COL FROM (SELECT 1 AS COL) AS SUBQUERY Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT TOP 1 COL FROM (SELECT 1 AS COL) AS CHECKTOP Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT SUBCOL AS COL FROM (SELECT 1 AS SUBCOL) SUBQUERY GROUP BY 1 Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT SUBCOL AS COL FROM (SELECT 1 AS SUBCOL) SUBQUERY GROUP BY 2 Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT SUBCOL AS COL FROM (SELECT 1 AS SUBCOL) SUBQUERY GROUP BY COL Result: One column of type IGNITE_TYPE_INT returned. Request: SELECT TOP 1 * INTO XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP Result: Error: Failed to parse query: SELECT TOP 1 * INTO XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect FROM (SELECT 1 AS COL) AS CHECKTEMP Request: DROP TABLE XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect Result: Error: Unsupported query: DROP TABLE XTC_A_ABEJAEGI_BFDC_EDBB_BCDC_FAFDCEEAFGG_Connect {noformat} > ODBC: Performance drop when connecting to Ignite with Tableau on Windows. > ------------------------------------------------------------------------- > > Key: IGNITE-3626 > URL: https://issues.apache.org/jira/browse/IGNITE-3626 > Project: Ignite > Issue Type: Bug > Components: odbc > Affects Versions: 1.6 > Reporter: Igor Sapego > Assignee: Igor Sapego > Priority: Critical > Labels: important, odbc > Fix For: 1.8 > > > It seems like we have a performance drop on Ignite after we connect to it > with Tableau on Windows (only connecting, no queries are being run). -- This message was sent by Atlassian JIRA (v6.3.4#6332)