[
https://issues.apache.org/jira/browse/KYLIN-2121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15683921#comment-15683921
]
Yifan Zhang commented on KYLIN-2121:
------------------------------------
Hi [~lidong_sjtu],
This issue comes with infinite "SQLMoreResults" calls.
The reason why the query will not end is that the PowerBI(or Excel) has some
mechanism to double check transaction done by retrying "SQLMoreResults" times.
When finished loading all data a SQL_NO_DATA code will returned. And in
following process of ODBC the statement will be reset by cleanup phase. But
then in the final check, Driver could not tell if the statement been released
and a SQL_SUCCESS returned which means "has more data".
Will add a pre-check of stmt status and include in following patch. please help
to review
> Failed to pull data to PowerBI or Excel on some query
> -----------------------------------------------------
>
> Key: KYLIN-2121
> URL: https://issues.apache.org/jira/browse/KYLIN-2121
> Project: Kylin
> Issue Type: Bug
> Components: Driver - ODBC
> Reporter: Dong Li
> Assignee: Yifan Zhang
> Priority: Minor
>
> select part_dt, sum(price) as total_selled, count(distinct seller_id)
> as sellers from kylin_sales group by part_dt order by part_dt
> (The load data process never will finisfh, as in video, but you can see
> Error in log "Value was either too large or too small for an Int32" )
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
