Mandar Kavishwar 6 Posted April 7, 2020 Share Posted April 7, 2020 Hi, I am working on a dashboard which connects to Cloudera ImpalaDb. THe dashboard work fine for regular data import. But when it comes to Data On Demand and the row count goes beyond 10000, it sarts giving an error : Could not load on demand data for the table xyz Failed to create DataTable. Is there any solution to fix this issue or any work around Can we make changes in the data source template and make it work Or it is just Impala's issue and cant be fixed frm Spotfire side I am using Spotfire 10.3.1 and have enabled "Allow writing in Temporary Tables" option anf increased Fetch size to 100000. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted April 7, 2020 Share Posted April 7, 2020 Can you share the complete error stack trace Link to comment Share on other sites More sharing options...
Mandar Kavishwar 6 Posted April 8, 2020 Author Share Posted April 8, 2020 Attached error from Spotfire and Log file. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted April 8, 2020 Share Posted April 8, 2020 Please check the following Knowledge Base article , seems like a limitation on Cloudera Impala, https://support.tibco.com/s/article/Filtering-in-related-table-could-not... Link to comment Share on other sites More sharing options...
Zhang Yubing Posted April 19, 2023 Share Posted April 19, 2023 the url is invalid now. i have the same problem Link to comment Share on other sites More sharing options...
Zhang Yubing Posted April 19, 2023 Share Posted April 19, 2023 where can i set the option "Allow writing in Temporary Tables" ? i use spotfire11.4. can you help Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now