Support for Temp tables


#1

Hello,

Is N1QL provides temporary tables kind of feature in SQL?

Thanks,
Sameer


#2

Sameer,

I think the short answer is no. I will ask the PMs though to get you a more succinct answer.

Austin


#3

Hi Sameer,

N1QL does not support temporary tables currently. FYI (you may know already) N1QL does support subqueries, if that would be of use instead of temp tables.

Thanks,
Colm.


#4

Hi @sameerd, can you help us with what you wanted to do with the team table? I have seen a lot of uses but wanted to understand your specific use case for temp objects.
thanks
-cihan


#5

Hi All,

Thank you for the responses.

cihangirb - The purpose we are looking for temp tables is, we get data from multiple sources and we embed this data into sing table(if we consider SQL here) that gets used for further processes.

For example, We get user information from 3 source table like UserDetails, UserEmailIds and UserTelephoneNumbers. Using these 3 tables we generate final table User which has all the information. So these 3 tables becomes our temp tables which we delete after generating final User table.

Thanks,
Sameer


#6

Makes sense - would you like these to be indexable or do you not care?
thanks
-cihan