search

mradamlacey / elasticsearch-tableau-connector

Tableau Web Data Connector for Elasticsearch
MIT License
149 stars 64 forks source link

Executing Query forever when set up connection #17

Closed hugo-zheng closed 8 years ago

hugo-zheng commented 8 years ago

Hi,

Thanks for your great work on the elasticsearch connector first!

I meet an issue at the end of Tableau Executing query part. in attachment, there is a video recorded the progress.

ENV: Macbook pro, elasticsearch 2.3.3 within Docker 1.11.2, tableau desktop 9.3 Data: only 1 piece: curl -XPUT 'http://localhost:9200/db/user/1' -d ' { "id": 1, "name": "hugo" }' I run a elasticsearch service on my Mac, and use the connector to connect it. It's fine on the connector webpage(see attachment "connector_fine_page" ), index, type showed itself. But after click "submit" button, it turns to tableau loading popup, the steps are: connecting to database, Executing query, Loading metadata, Creating extract database, Executing query... (then stops here, will run about 10 mins to pop a timeout page, see "Executing query forever", "finall error").

Much appreciate if you could look into this.

connector_fine_page executing query forever finall error

video.zip

mradamlacey commented 8 years ago

Can you provide the contents of the Tableau Desktop logs and see what is there?

hugo-zheng commented 8 years ago

Thanks for your quick reply, I checked with http://tableau.github.io/webdataconnector/Simulator/

hugo-zheng commented 8 years ago

seems, it keep calling getNextScrollResult screen shot 2016-07-06 at 3 50 16 pm

hugo-zheng commented 8 years ago

just tried again, there only one record in es, if I set "Total limit on number of rows to sync" to 1, it works fine

mradamlacey commented 8 years ago

I suspect there's a bug when the total number of hits is less than the limit specified in the connector. I will push a fix for this asap.

On Wed, Jul 6, 2016, 3:04 AM hugo-zheng notifications@github.com wrote:

just tried again, there only one record in es, if I set "Total limit on number of rows to sync" to 1, it works fine

— You are receiving this because you commented.

Reply to this email directly, view it on GitHub https://github.com/mradamlacey/elasticsearch-tableau-connector/issues/17#issuecomment-230705048, or mute the thread https://github.com/notifications/unsubscribe/ABv8Hfhj4HaFuTCVvOFV7yQIH8QOmz_Cks5qS2GAgaJpZM4JFBWY .