[jira] [Commented] (IGNITE-3626) ODBC: Performance drop when connecting to Ignite with Tableau on Windows.

["Igor Sapego (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-3626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15422560#comment-15422560 ] 

Igor Sapego commented on IGNITE-3626:
-------------------------------------

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)