cancel
Showing results for 
Search instead for 
Did you mean: 

Incorta table load/query timing

RADSr
Captain
Captain

Doing some testing.  I have two tables from the same source - they should be mutually exclusive result sets, but may not be.   

I created a third table using two SQLi -based tables to query the first two and set the key columns to eliminate any duplicate rows.

*  All three are currently in the same schema and I've modified the load order so the two "source" tables are in group 1 and the composite table is in group 2*

Can I reliably expect that the two source tables will run to completion first and the composite table will then query those results?     IOW - when do Incorta tables ( parquet files ) get locked/sequestered for load querying?     

 

-- IncortaOne@PMsquare.com --
5 REPLIES 5

mhelmy
Employee
Employee

Stay tuned!OrchestratedLoadPlan.png