View with Union

[zachariam]

Hi,
I have 2 tables, i want to display data from both tables as single data, i wanted to display data in real time, i don’t want to fill to third table and display. any oracle like VIEW with UNION option available?, no relation between two table data. i want to display record based on entry time from both table as a single data. Msisdn ending with 0 to 5 is coming to one table, 6 to 9 is coming into another table, so i want to combine both data and display as single table data in real time .

[candido.dessanti]

Hi @zachariam,

we have UNION ALL, but it has to be activated with a server’s parameter called enable-union

You can check this discussion for examples.

Union all problem

Hi @Gopinath_Jaganmohan, the SQL operator union all got several enhancements lately, so work perfectly with TEXT encoded fields that haven’t the dictionary shared [image] Now you can also use aggregates in the queries [image] To enable the union all feature, you have to use the enable-union parameter set to true mapd@zion-tr:/opt/mapd/omnisci-ee-5.10.0-20220107-8939c3b1c4-Linux-x86_64-render$ bin/omnisci_server --data /opt/mapd_storage/data48 --stringdict-parallelizm --enable-union=true I…

Take care about the usage of union-all because you could face some performance problems, especially when dealing with big tables using many fields.

Regards,
Candido