When we create a cube with some temporary tables in Impala the sequence is as follows:
1. Create a table
2. Insert data in the table.
3. Select data from the table to publish the cube
4. Drop the table
The issue is that when we try to publish the data in the cube, sometimes 0 rows are published and sometimes 200 rows are published.
All the rows are not able to publish in the cube.
It seems that the Select is executed before Insert is finished.
The same sequence is working with another database for publishing the cubes.
Can anybody suggest how to resolve this issue.
Is it problem with Microstrategy or is it problem with Impala ?
Dilip – and what version of MSTR is this? Also, have you assured that the MSTR VLDB object for Impala is installed and configured?