ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Igor Sapego (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-3626) ODBC: Performance drop when connecting to Ignite with Tableau on Windows.
Date Tue, 16 Aug 2016 10:36:20 GMT

    [ 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)

Mime
View raw message