KNOWLEDGE BASE

Extracting from Alibaba MaxCompute does not return the full data


Published: 10 Nov 2021
Last Modified Date: 10 Nov 2021

Issue

When extracting data from Alibaba MaxCompute, Only 10000 rows are returned, which is not equal to all records (datasource).

Environment

  • Tableau Desktop 2021.3.3
  • Alibaba MaxCompute

Resolution

Remove '&interactiveMode=true' in URL and re-connect to database.

Cause

MCQA(MaxCompute Query Acceleration) is enabled when connecting to Alibaba MaxCompute Database.
The following parameter is used when connecting to the database 

"interactiveMode=true"

For example: http://service.cn-beijing.maxcompute.aliyun.com/api?project=****_beijing&interactiveMode=true
Did this article resolve the issue?